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...
Which statement is false?
a. With datagram sockets a process establishes a connection to another process. b. The TCP protocol is used for transmission with stream sockets. c. The UDP protocol is used for transmission with datagram sockets. d. With the UDP protocol packets can be lost, duplicated or even arrive out of sequence.
In the code shown here, what is the correct array declaration for the array used in FillArray?
``` int FindAverage(float numbers[][25]); int main() { //declarations go here int total; total = FillArray(numbers); ``` A. int numbers[25]; B. int numbers[25][25]; C. float numbers[25][25]; D. float numbers[25];
________ testing is how much did the user remember after a period of non-use
A) Emotional response B) Accuracy C) Recall D) Performance
Thus, each salesperson passes in between 0 and 5 sales slips per day. Assume that the information from all of the slips for last month is available. Write a program that will read all this information for last month’s sales and summarize the total sales by salesperson by product. All totals should be stored in the two-dimensional array sales. After processing all the information for last month,
print the results in tabular format with each of the columns representing a particular salesperson and each of the rows representing a particular product. Cross total each row to get the total sales of each product for last month; cross total each column to get the total sales by salesperson for last month. Your tabular printout should include these cross totals to the right of the totaled rows and to the bottom of the totaled columns. (Sales Summary) Use a two-dimensional array to solve the following problem. A company has four salespeople (1 to 4) who sell five different products (1 to 5). Once a day, each salesperson passes in a slip for each different type of product sold. Each slip contains the following: a) The salesperson number b) The product number c) The total dollar value of that product sold that day