Question: Table 1 below lists customer/car hire data. Each customer may hire cars from various branches throughout Pahang. A car is registered at a particular branch

 Table 1 below lists customer/car hire data. Each customer may hire

Table 1 below lists customer/car hire data. Each customer may hire cars from various branches throughout Pahang. A car is registered at a particular branch and can be hired out to a customer on a given data. carReg og make model hireDate branch No WHU4267 Proton Waja WNE2591 Chevrol et Optra Table 1 cust custName ID 3 Daylan 1 Shafiq 7 Safuan 5 Norizan 9 Neo 10 Rupynn 21 Yap 8 Shamini 13 Emy 14/7/08 21/7/08 16/7/08 18/7/08 20/7/08 14/7/08 16/7/08 22/7/08 26/7/08 01 01 02 02 02 03 03 04 04 branch Location Kuantan Kuantan Maran Maran Maran Pekan Pekan Raub Raub JGB1947 Nissan Sentra CBL9 Proton Perdana (a) Describe why the table shown above is not in First Normal Form (INF) [2 Marks] (b) Identify the functional dependencies represented by the data shown in the table [10 Marks] (b) Using the functional dependencies identified in (b), normalize table 1 to Third Normal Form (3NF). Show your step. Identify the primary and foreign keys in every step. [18 Marks]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!