Thursday, June 7, 2007

Question 70

An “employee” table is partitioned into four tables. Which table does not satisfy the condition that “items other than keys are subordinate only to key items”?
In this example, the underlined item represents the primary key.

Employee
Employee
number
Name Birthdate Salary Postal code Address Position Department Work location


a)
Employee number Salary Work location
b)
Employee number Name Birthdate
c)
Employee number Position Department
d)
Employee number Postal code Address

answer

No comments: