Examine the Patient Medication Form for the Wellmeadows Hospital case study shown
(a) Identify the functional dependencies represented by the attributes shown in the form in Figure 14.18. State any assumptions that you make about the data and the attributes shown in this form.
(b) Describe and illustrate the process of normalizing the attributes shown in Figure 14.18 to produce a set of well-designed 3NF relations.
(c) Identify the primary, alternate, and foreign keys in your 3NF relations.
Answer: (a) Identify the functional dependencies represented by the data shown in the form
patientNo ??fullName
wardNo ??wardName
wardName ??wardNo
drugNo ? name, description, dosage, methodOfAdmin
patientNo, drugNo, startDate ? unitsPerDay, finishDate
The functional dependencies for bedNo are unclear. If bedNo was a unique number for the
entire hospital, then could say that bedNo ??wardNo. However, from further examination of
the requirements specification, we can observe that bedNo is to do with the allocation of
patients on the waiting list to beds.
You might also like to view...
It requires more steps and custom scripts to process data for storage in a database from checkboxes than from a list box.
Answer the following statement true (T) or false (F)
The value returned from the scanf function is the number of values successfully formatted.
Answer the following statement true (T) or false (F)
What is important to do to a SQLite database to release any resources obtained by the object so that unexpected errors do not occur in your application during use?
a. Shutdown the database by calling the release() method on the SQLiteOpenHelper object. b. End any queries by calling the endQuery() method on the SQLiteOpenHelper object. c. Stop the database by calling the stop() method on the SQLiteOpenHelper object. d. Close the database by calling the close() method on the SQLiteOpenHelper object.
Similar to Access Reports, ________ can provide valuable descriptive information for anyone who is using forms in a database
Fill in the blank(s) with correct word