Databases and Information Management
(tutorial2 worksheet)
Q1a
Entity integrity – each table has a primary key which is unique and does not contain null value.
Referential integrity - the foreign key can be null but if there is a value, the value must match the value of the primary key in the related table.
Q1b
Course code|[SK] Course name|[SK] Course manager|Course manager’s phone|
[FK] Course code|Student ID|[SK]Student name|[SK]Student address|Student phone|
*underlined = primary key
[FK] = foreign key
[SK] = secondary key
No comments:
Post a Comment