4. What problem might arise when using a primary key of course number for the data in Problem 2? (Hint: Think about what would happen if the Department Name [not shown in the data] changes.)

The student grading system Relational Data Model is given below.

It consist of 4 relations namely- Student, Course, Professor, Grade. The Primary key and foreign keys are clearly mentioned in each relations.

Student St_ number St name En_year Major PK Course course_number PK Course title Professor id FK Grade St number PK, FK PK, FK Professor Professor_id Name Department Course number Grade PK Student St_ number St name En_year Major PK Course course_number PK Course title Professor id FK Grade St number PK, FK PK, FK Professor Professor_id Name Department Course number Grade PK