Question: 14. How would you implement the 1:1 relationship in the following scenario: Photon Holdings Berhad is a Malaysian automotive company which produces many car models.

 14. How would you implement the 1:1 relationship in the following

14. How would you implement the 1:1 relationship in the following scenario: Photon Holdings Berhad is a Malaysian automotive company which produces many car models. Each salesperson working for Photon is in charge of selling only one particular car model. Every car model is sold exclusively by one salesperson. However, some salespeople have yet to be assigned any car model to sell. A. Place the primary key of SALESPERSON as the foreign key of CAR. B. Place the primary key of CAR as the foreign key of SALESPERSON. C. Place the primary key of SALESPERSON as the foreign key of CAR, and the primary key of CAR as the foreign key of SALESPERSON. D. Combine SALESPERSON and CAR into the same entity

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!