Saved Bookmarks
| 1. |
You have two tables, EMPLOYEE and COMPUTER that are in a one-to-one relationship. The foreign key is Emp Number in COMPUTER which references Emp Number as the primary key of EMPLOYEE. Explain what must be done to convert the one-to-one EMPLOYEE-COMPUTER relationship to a one-to-many relationship where one employee can have more than one computer. |
|
Answer» In the one-to-one relationship, there will be a constraint on Emp Number as a foreign key in COMPUTER stating that Emp Number must be unique. To convert the relationship to a one-to-many relationship, just drop this constraint. |
|