one-to-one relationship problem in SQL

Question

You have two tables, STUDENT and COMPUTER which are in a one-to-one relationship. The foreign key is StudNumber in COMPUTER that references StudNumber as the primary key of STUDENT. Describe what must be done to convert the one--to-one STUDENT -COMPUTER relationship to a one-to- many relationships where one employee can have more than one computer.

Answer 1

In the one to one relationship, there will be a constraint on StudNumber as a foreign key in COMPUTER stating that StudNumber must be exclusive. To convert the relationship to a one-to-many relationship, merely drop this constraint.