Question: 3.18 Give an SQL schema definition for the employee database of Figure 3.19. Choose an appropriate domain for each attribute and an appropriate primary key


3.18 Give an SQL schema definition for the employee database of Figure 3.19. Choose an appropriate domain for each attribute and an appropriate primary key for each relation schema. Include any foreign-key constraints that might be appropriate. employee (ID, person_name, street, city) works (ID, company_name, salary) company (company name, city) manages (ID, manager_id) Figure 3.19 Employee database
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
