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...
To retrieve specific columns from a table, use _________ to separate the column names.
a. ? b. * c. , d. -
A(n) ________ is a text box and a list that is hidden until you click its arrow
Fill in the blank(s) with correct word
The ________ input type element allows visitors to select one or more options from a predefined set of options
Fill in the blank(s) with correct word
When installing software, the _____ program begins as soon as the installation file is downloaded.
A. extraction B. setup C. verification D. driver