Question
Make a mySQL ERD 1NF: PATIENT (HouseholdNum, HouseHoldName, Street, City, State, Zip, Balance, PatientNum, PatientName, ServiceCode, Description, Fee, Date) PK:
| 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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Concepts of Database Management
Authors: Philip J. Pratt, Mary Z. Last
8th edition
1285427106, 978-1285427102
