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.

![15237|637x171](upload://jTQvphC8e5yNPalkIuWgHxdNOhl.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.
![15238|643x408](upload://4xBlCtJuJeL0CJTQZ7aPlv2gjxn.png)
Students should identify that jobId is the PK for the table and then show the three functional dependencies. Students may split up the pickupDateTime column to separate Date and Timeā€¦This is OK but not necessary. The original table is in 2NF and is transformed into 3NF by removing functional dependencies fd2 and fd3. The structure of the three tables created is shown below.

![15239|342x370](upload://jPLeXICvs5x8km25mTe1rshokZb.png)

Computer Science & Information Technology

You might also like to view...

Which of the following does not complete the sentence correctly? An interface_____________.

a. forces classes that implement it to declare all the abstract interface methods. b. can be used in place of an abstract class when there is no default implementation to inherit. c. is declared in a file by itself and is saved in a file with the same name as the interface followed by the .java extension. d. can be instantiated.

Computer Science & Information Technology

You begin the Label Wizard by selecting the type of label that you want to use

Indicate whether the statement is true or false

Computer Science & Information Technology

A(n) ________ is a set of values that Excel saves and can substitute automatically in your worksheet

Fill in the blank(s) with correct word

Computer Science & Information Technology

Selecting the Rows 5 & 6 then choose Insert->Row. What will happen? Select one:

a. 2 Rows will be inserted after Row 7 b. 2 Rows will be inserted after Row 4 c. 2 Rows will be inserted after Row 5 d. 2 Rows will be inserted after Row 6

Computer Science & Information Technology