The following data are required to be stored by a family physician.
Family#, FamilyAddress, Patient#, PatientName, ServiceCode, ServiceFee, ServiceDate
A family can have several patients. A patient belongs to a single family. Each service has a code and a fee. A patient can get only one service on a given date. Show the database design in third normal form for the above data.