Applying normalisation to 3NF on the table shown results in the formation of the three 3NF tables shown
What will be an ideal response?
(a) Identify the functional dependencies that exist between the columns of each tableand identify the primary key and any alternate and foreign key(s) (if present) for each table.
(b) Describe why storing the FastCabs data across three 3NF tables avoids the update
anomalies described in Exercise 14.17(c). [Typo in 6 th Edition]
(c) Describe how the original table shown can be re-created through
relational joins between primary key and foreign keys columns of the tables
You might also like to view...
The ________ positioning layout option is used to place an object at a fixed position on the page
A) Absolute B) Relative C) Bounded D) Unmovable
In a Java program, the file name must be the same as the ____ name.
A. method B. data C. object D. class