Make a mySQL ERD 1NF: PATIENT (HouseholdNum, HouseHoldName, Street, City, State, Zip, Balance, PatientNum,
Question:
1NF: | PATIENT (HouseholdNum, HouseHoldName, Street, City, State, Zip, Balance, PatientNum, PatientName, ServiceCode, Description, Fee, Date) PK: PatientNum |
2NF: | PATIENT_HOUSEHOLD (HouseholdNum, HouseHoldName, Street, City, State, Zip, Balance) PK: HouseholdNum PATIENT (PatientNum, HouseholdNum, PatientName, ServiceCode, Date) PK: PatientNum FK: HouseholdNum SERVICE (ServiceCode, Description, Fee) PK: ServiceCode |
3NF: | PATIENT_HOUSEHOLD (HouseholdNum, HouseHoldName, Street, City, State, Zip, Balance) PK: HouseholdNum PATIENT (PatientNum, HouseholdNum, PatientName) PK: PatientNum FK: HouseholdNum SERVICE (ServiceCode, Description, Fee) PK: ServiceCode PATIENT_SERVICE (PatientNum, ServiceCode, Date) PK: (PatientNum, ServiceCode) FK: PatientNum, ServiceCode |
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last