The table below lists customer/car hire data. Each customer may hire cars from various outlets throughout Glasgow. A car is registered at a particular outlet and can be hired out to a customer on a given date.
(a) The data in the table is susceptible to update anomalies. Provide examples of how insertion, deletion, and modification anomalies could occur on this table.
(b) Identify the functional dependencies represented by the data shown in the table. State any assumptions you make about the data.
(c) Using the functional dependencies identified in part (b), describe and illustrate the process of normalization by converting Table 1 to Third Normal Form (3NF) relations. Identify the primary and foreign keys in your 3NF relations.
(a) Using the data shown in the table above, the student should provide examples of how insertion, deletion, and update anomalies could occur.
(b) For answer see figure below.
(c) For answer see figure below.
The primary key of the original relation is appointment number (appNo) and the relation is
already in 2NF. The original relation also has two alternate keys instructorID, dateTime and
clientID, dateTime. The functional dependencies fd2 to fd5 represent transitive dependencies
in the original relation and must be removed to create the following relations in 3NF.
Appointment (appNo, dateTime, instructorID, clientID)
Primary Key appNo
Alternate Key dateTime, instructorID
Alternate Key dateTime, clientID
Foreign Key instructorID references Instructor (instructorID)
Foreign Key clientID references Client (clientID)
Instructor (instructorID, iFName, iLName)
Primary Key instructorID
Client (clientID, cFName, cLName, cAddress)
Primary Key clientID
You might also like to view...
A comatose, critically ill patient is on continuous tube feedings when the family decides to stop the feedings. Who has the right to make this decision for the patient?
A) The physician B) The person with durable power of attorney C) The spouse D) The critical care nurse
While assessing a new patient in the clinic area, the nurse administers the SAD PERSONAS. For what is the nurse most likely assessing?
A) Risk of depression B) Risk of self-mutilation C) Risk of violence D) Risk of suicide
You are working with a client who is taking a neuroleptic medication that has recently been changed and increased. You notice that the client has a high fever (104 degrees Fahrenheit), is confused, and has extreme muscle rigidity
You would do which of the following? a. Suspect that the client has an infectious process, and call the health care provider, expecting an order for an antibiotic. b. Call an ambulance immediately, notify the health care provider, and prepare for seizure control and cardiopulmonary resuscitation (CPR). c. Suspect neuroleptic malignant syndrome, hold the neuroleptic medication, and call the health care provider. d. Give the neuroleptic on time as ordered, call the health care provider to report the symptoms, and see if additional medication is needed.
A patient with cancer who is receiving chemotherapy develops a fever. The patient's chest radiograph is normal. The patient's neutrophil count is 750/mm3. The nurse expects the provider to:
a. begin empiric therapy with intravenous antibiotics. b. obtain cultures and wait for results before prescribing antibiotics. c. order colony-stimulating factor to minimize neutrophilia. d. reassure the patient that serious infection is unlikely.