A company called FastCabs provides a taxi service to clients. The table shown displays some details of client bookings for taxis. Assume that a taxi driver is assigned to a single taxi but a taxi can be assigned to one or more drivers.
What will be an ideal response?
(a) Identify the functional dependencies that exist between the columns of the table and identify the primary key and any alternate key(s) (if present) for the table.
(b) Describe why the table is not in 3NF.
(c) The table shown is susceptible to update anomalies. Provide examples of
how insertion, deletion and modification anomalies could occur on this table.
Computer Science & Information Technology
You might also like to view...
To modify the border of a cell or cells, click the Borders button in the ________ group of the Home tab
A) Editing B) Font C) Styles D) Paragraph
Computer Science & Information Technology
A document may wordwrap differently depending on the type of printer being used.
Answer the following statement true (T) or false (F)
Computer Science & Information Technology