Transform the following ERD/document to 3-Normalization-Form (3NF) relations. dr

Question

Transform the following ERD/document to 3-Normalization-Form (3NF) relations. draw relational tables. And make sure you include functional dependency notation

Patient # | Name | First Seen Social Worker Visit DateVisit Time Reason for VisitNew Level of Pain 9844 John Miller10/1/2008 Matt Baker 10/11/2009 2:30 pm Severe leg for past 2 days 10/18/2009 11:30 am Follow-up, also None 1/3/2010 10 am 3/15/2010 10:30 am Routine need flu shot Routine 4211 Sheryl Franz 1/3/2009 Lynn Riley 1/3/2010 2 pm Referred by care physician 2/11/2010 9 Physical 3/22/2010 4:00 pm Routine and Greater difficulties with writing & buttoning shirts 812 Shot 8766 Juan Ortega 2/2/2009 Matt Baker 2/2/2010 9:30 am Blurred vision 0 n right eye Follow-up 2/14/2010 9:30 am Pins/needles in both legs; trouble with balance 3/18/2010 P??? New symptoms

Explanation / Answer

Functional Dependency:   

Patient # -- > { Name, First seen, Social worker }

Functional Dependency:

{ Patient #, Visit Date, reason for visit } ---> { Reason for visit, new symptoms, Level of pain }

Patient # Name First Seen Social Worker 9844 John Miller 10/1/2008 Matt Baker 4211 Sheryl Franz 1/3/2009 Lynn Riley 8766 Juan Ortega 2/2/2009 Matt Baker

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.