-
Normal form voilations and fixing(Normalization)
Hello everyone,
This is something i have been stuck on for quite a while now.
Can you please help me following tables.
Normal forms violated in the following designs and fix them. There may be multiple normal form violations in the design.
1)PATIENT
patient_id
patient_fname
patient_lname
patient_street
patient_city
patient_state
patient_zip
patient_phone
doctor_id
doc_fname
doc_lname
doc_phone
doc_beeper
2)PATIENT
patient_id
insurance_company
patient_fname
patient_lname
patient_street
patient_city
patient_state
patient_zip
patient_phone
insurance_contact_first
insurance_contact_last
insurance_phone
Thank you
Maheja
-
Sounds like a homework. Check Codd's book.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|