Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Donald A. Carpenter Fred R. McFadden

1st Edition

8178088045, 978-8178088044

More Books

Students also viewed these Databases questions

Question

Distinguish between hearing and listening.

Answered: 1 week ago

Question

Use your voice effectively.

Answered: 1 week ago