Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hi, I have completed this question, but I am not sure if I have normalized correctly. If someone could do this problem so I could
Hi, I have completed this question, but I am not sure if I have normalized correctly. If someone could do this problem so I could check my work against it I would appreciate it.
3. (22) Normalize the following relation to 3rd normal form. Identify & draw the complete FDs for all normal forms through to 3NF. Application Summary: A patient's visit to the doctor. A patient visits the doctor for a specific ailment. The doctor may then diagnose and treat the problem with medication. For simplicity, you can assume that once the patient takes the medication, it is not needed a second time. Do not add or delete any attributes or keys. Specialty - the doctors expertise Patientins - insurance Medsinstr - compliance instructions for the medication PatName - patient's name 1NF: Docid Patienti DocName Specialty Patname Patientage Medsid visitDate Diagnosis Treatment Patent ins Dosage Medsinst a) Identify all full (above the diagram), partial, and transitive dependencies (below the diagram) and label them. b) Improve the relations to 2NF. Show and label all FDs and all dependency arrows. Identify all primary keys for each FD. c) Improve the relations to 3NF. Show and label all FDs and all dependency arrows. Identify all primary keys for each FD. d) Draw the relational schema for the final database table structure. Name each relation and identify all primary and foreign keys. 3. (22) Normalize the following relation to 3rd normal form. Identify & draw the complete FDs for all normal forms through to 3NF. Application Summary: A patient's visit to the doctor. A patient visits the doctor for a specific ailment. The doctor may then diagnose and treat the problem with medication. For simplicity, you can assume that once the patient takes the medication, it is not needed a second time. Do not add or delete any attributes or keys. Specialty - the doctors expertise Patientins - insurance Medsinstr - compliance instructions for the medication PatName - patient's name 1NF: Docid Patienti DocName Specialty Patname Patientage Medsid visitDate Diagnosis Treatment Patent ins Dosage Medsinst a) Identify all full (above the diagram), partial, and transitive dependencies (below the diagram) and label them. b) Improve the relations to 2NF. Show and label all FDs and all dependency arrows. Identify all primary keys for each FD. c) Improve the relations to 3NF. Show and label all FDs and all dependency arrows. Identify all primary keys for each FD. d) Draw the relational schema for the final database table structure. Name each relation and identify all primary and foreign keysStep 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