Unformatted text preview: Name, Department, …….) Note to the solution: Note that this is the most simplified solution. In reality, there should be tables like Creditterms, ShippingTerms, Carrier (Shipping), Departments and etc. Accordingly, fields like CreditTerm, ShippingTerm and Shipvia in the PurchaseOders table should be changed to the foreign keys of respective tables; and Department in Employees should be Dept#, which is a foreign key linking to Departements table....
View Full Document
- Winter '12
- Foreign key, Candidate key, Departments of France, departments