Question
Create MySQL ERD 1NF: PATIENT (HouseholdNum, HouseHoldName, Street, City, State, Zip, Balance, PatientNum, PatientName, ServiceCode, Description, Fee, Date) PK: PatientNum 2NF: PATIENT_HOUSEHOLD (HouseholdNum, HouseHoldName, Street,
Create MySQL ERD
| 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
