Relational Database Technology
Data is stored in tables
- One table for each type of object or “entity”
- Each of the following would have a table
- students table lists all students - one row for each student
- course table lists all courses - one row for each course
- instructor table lists all instructors - one row for each instructor
- Each row has a unique identifier
- Primary key (PK)
- Primary key is never null and cannot be a duplicate
- What is the primary key for a student in UW database?