Scribd
Upload
10 views1 page

Car Rental Database Normalization Guide

The document discusses a normalization exercise for a car rental company's un-normalized database table containing details of hired cars. It highlights the issues with the current structure, proposes validation checks for specific fields, and outlines the steps to achieve first normal form (1NF) and second normal form (2NF). The exercise aims to improve data integrity and organization within the database.

Uploaded by

ZION SALTIBUS
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
10 views1 page

Car Rental Database Normalization Guide

The document discusses a normalization exercise for a car rental company's un-normalized database table containing details of hired cars. It highlights the issues with the current structure, proposes validation checks for specific fields, and outlines the steps to achieve first normal form (1NF) and second normal form (2NF). The exercise aims to improve data integrity and organization within the database.

Uploaded by

ZION SALTIBUS
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Information Technology Unit 2

Normalization Exercise

A car rental company keeps details of cars that are hired by persons in an un-normalized
database table as shown in Table 1.

The relation in Standard Notation is as follows:

HiredCars (ClientNumber, ClientName, Gender, DateOfBirth, M/VRegistration, Make, Model,


DateHired, DateReturned)

TABLE 1

Client Client Gender Date of M/V Make Model Date Date


Number Name Birth Registration Hired Returned
1024 Ian, C M 20/10/1945 8066 AJ Ford Capri 2/2/2007 1/3/2007
1645 AD Toyota Prado 15/5/2007 14/8/2007
2256 Rose, R F 2/1/1956 7484 BX Isuzu Gemini 5/5/2007 12/5/2007
0246 AE Ford Escort 21/1/2007 25/1/2007
3844 DM Mazda 626 6/9/2007 7/11/2007
3033 Lily, W F 26/3/1987 7777 DR Toyota Corona 1/1/2007 1/7/2007
.

8989 Bush, T M 8/12/1977 8888 CA Honda Accord 4/11/2007 7/11/2007

1. What makes Table 1 un-normalized?

2. Name and describe a suitable validation check for TWO fields in Table 1. Your
validation checks must be different.

3. Apply normalization rules to Table 1 to reflect first normal form (1NF) and second
normal form (2NF).

You might also like