Database Systems - Computer Science

Running head: DATABASE SYSTEMS
DATABASE SYSTEMS
Name of the Student:
Name of the University:
Author Note

1
DATABASE SYSTEMS
Dependency Diagram
The given table is provided below:
Clien
t ID
Client
Name
Cab Hire Time Ca
b
ID
Cab Details Pickup
Address
Driver
Name
Driver's
License
Number
124 Shaun 5/09/201914:20 26 Subaru
lmpreza
2015
6 Kambara
Or, Mulgrave
Jeffrey
Etheridg
e
92476531
9
124 Shaun 7/09/201911:00 11 Toyota
Camry
2007
14
Gainsboroug
h Ave,
Wheelers
Hill
Sam
Harper
74087247
3
124 Shaun 12/09/201916:4
5
18 Honda
Civic 2009
6 Kambara
Or, Mulgrave
Sam
Harper
74087247
3
345 Patric
k
6/09/2019 20:10 34 Ford
Falcon
2010
52
Brunswick
Rd, Mitcham
Sanjay
Ugle
84378512
4
345 Patric
k
6/09/2019 22:30 34 Ford
Falcon
2010
8 Columbia
AveJ
C.roydon
Jeffrey
Etheridg
e
92476531
9
209 Sarah 3/09/2019 09:00 11 Toyota 21 Devon St, Vipul 72359620

2
DATABASE SYSTEMS
Camry
2007
Chaltenham Jad 1
209 Sarah 12/09/201913:1
5
34 Ford
Falcon
2010
21 Devon St,
Chaltenham
lshan
Mishra
52108724
3
209 Sarah 15/09/201918:0
5
29 Holden
Commodor
e 2012
21 Devon St,
Chaltenham
Sam
Harper
74087247
3
The above table has been developed in order to take into account the duplicities in the
data. The dependency diagram from the table developed above has been provided below:
Step by step decompositions
Step 1: first normal form
Hire (clientID (pk), ClientName, CabHireTime, CabID, CabDetails, PickUpAddress,
DriverName, DriverLicenseNumber)
Step 2: second normal form