Questions 1 How will you implement the 1 N maximum cardinali

Questions:

1) How will you implement the 1: N maximum cardinality relationships between PATIENT and PRESCRIPTION as well as between PHYSICIAN and PRESCRIPTION?

2) How will you implement the 1:1 maximum cardinality relationships between PHYSICIAN and OFFICE?

Solution

1) 1:N is implemented between patient and prescription by inserting multiple prescription records that with same patientrecordnumber as foreign key in prescription table.
Similarly,at the same time mutiple records in prescription table can have same physicianId as a foriegn key attribute

2) to implement 1:1 cardinality between physician and office ,
Create office table structure with physician Id as primary key so that one office record has only one physician theoretically.