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.

![15235|642x170](upload://oeJZT3CUlZHqeJFiZPKRXK5R8Dk.png)

(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.

![15236|712x449](upload://rOagqXEKwmgMs6iydRZNeCtuPsf.png)
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

Computer Science & Information Technology

You might also like to view...

If an assigned task is ____________________, then the task belongs to that person to complete.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

Slides can only be printed in expanded view, not in collapsed view

Indicate whether the statement is true or false

Computer Science & Information Technology

____________is a free add-on application which, once downloaded, is integrated directly onto the PowerPoint Ribbon with its own set of tools located on the Mix tab.

A. Office Mix B. Mix and Mash C. Outlook D. Excel

Computer Science & Information Technology

A(n) ____ label in a switch statement represents a specific value and is followed by one or more statements that are executed if the value of the label matches the value of the switch statement's expression.

A. if B. default C. case D. break

Computer Science & Information Technology