Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

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 keys

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Ronald W Hilton

7th Edition

0073022853, 978-0073022857

Students also viewed these Accounting questions