Table of Contents
Introduction to Database
Follow are some key concepts:
Entity (or Table)
- An entity represents a real-world object.
- In a database, each entity is a table.
Example entities:
ProfessorsStudentsClassesProjects
Attributes (or Columns)
- An attribute is a property of an entity (a column in the table).
- Each row (record) in the table has values for these attributes.
Example (Students table):
| StudentID |
Name |
Major |
Year |
| 1 |
Alice |
CS |
2 |
| 2 |
Bob |
Math |
3 |
Here, StudentID, Name, Major, Year are attributes.