Describe and illustrate the process of normalizing the data shown in Figure 14.18 to First (1NF), Second (2NF), and Third (3NF).
What will be an ideal response?
First Normal Form
patientNo, drugNo, startDate, fullName, wardNo, wardName, bedNo, name,
description, dosage, methodOfAdmin, unitsPerDay, finishDate
Second Normal Form
patientNo, drugNo, startDate, wardNo, wardName, bedNo, unitsPerDay, finish
Date
drugNo, name, description, dosage, methodOfAdmin
patientNo, fullName
Third Normal Form
patientNo, drugNo, startDate, wardNo, bedNo, unitsPerDay, finish Date
drugNo, name, description, dosage, methodOfAdmin
patientNo, fullName
wardNo, wardName
(c) Identify the primary, alternate, and foreign keys in your 3NF relations.
patientNo (FK), drugNo(FK), startDate, wardNo(FK), bedNo, unitsPerDay, finish
Date
drugNo, name, description, dosage, methodOfAdmin
patientNo, fullName
wardNo, wardName (AK)
(Primary keys underlined.)
You might also like to view...
The ________ window provides information about a multitude of topics
Fill in the blank(s) with correct word
The Print Preview feature in Excel 2013 is available:
A) on the View tab. B) in Microsoft Office Backstage view. C) on the Quick Access Toolbar. D) on the Page Layout tab.