Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started