Doctors and patients are in a binary one-to-many relationship as:
Doctor Patient To accomplish this in a relational database _____.
A) The primary key of the DOCTOR relation is placed as a foreign key in the PATIENT relation.
B) The primary key of the PATIENT relation is placed as a foreign key in the DOCTOR relation.
C) Either of choice a or b will work.
D) Neither of choice a or b will work.
E) Nothing extra has to be done to accomplish this in a relational database.
Correct Answer:
Verified
Q9: A foreign key _.
A) must have the
Q10: The relational data model was first described
Q11: In relational database, the basic data structure
Q12: An attribute(s) that acts as a foreign
Q13: Storing a binary many-to-many relationship in a
Q15: An attribute(s) that functions as the primary
Q16: Which of the following relational algebra commands
Q17: Relational database management first became commercially viable
Q18: Which of the following relational algebra commands
Q19: Consider relations X and Y, each representing
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents