logo

Conversion Of Database Form 2022

12 Pages787 Words43 Views
   

Added on  2022-08-26

About This Document

In this task, you will perform normalization on a crude dataset so that it could be stored as a relational database. MetroCabs is a private taxi company that offers cab hire services to their regular business clients. You are provided the following data about some of their recent services. The data includes important details on which client hired a taxi on given dates. MetroCabs has a small number of full-time drivers who drive different cars based on vehicle availability. Client ID Client Name Cab Hire Time Cab ID Cab Details Pickup Address Driver Name Driver's License Number 124 Shaun 5/09/2019 14:20 26 Subaru Impreza 2015 6 Kambara Dr, Mulgrave Jeffrey Etheridge *******19 7/09/2019 11:00 11 Toyota Camry 2007 14 Gainsborough Ave, Wheelers Hill Sam Harper *******73 12/09/2019 16:45 18 Honda Civic 2009 6 Kambara Dr, Mulgrave 345 Patrick 6/09/2019 20:10 34 Ford Falcon 2010 52 Brunswick Rd, Mitcham Sanjay Ugle *******24 6/09/2019 22:30 8 Columbia Ave

Conversion Of Database Form 2022

   Added on 2022-08-26

ShareRelated Documents
Running head: DATABASE
DATABASE SYSTEMS
Name of the Student:
Name of the University:
Author Note
Conversion Of Database Form 2022_1
1
Dependency Diagram
Given data is described in the table provided below:
Conversion Of Database Form 2022_2
2
Conversion Of Database Form 2022_3
3
The development of the dependency diagram has been done based on the data provided
above. The dependency diagram provides the details of the dependency of a particular entity on
the other entities in the system.
The following dependencies can be utilized from the dependency diagram developed
above:
ClientID -> ClientName
CabHireTime, ClientID -> PickUpAddress, CabID, DriverName
DriverName -> DriverLicenceNumber
CabID -> CabDetails
Conversion Of Database Form 2022_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Database Systems - Computer Science
|7
|467
|17

Database Design and Development
|7
|1063
|493

Introduction to the ERD diagram
|6
|1099
|602

STUDENT NAME : MANISH KHATIWODA Student Id :11681209.
|5
|431
|34

Database Management System: Case Study of BigM System
|12
|1280
|412

ICT211 - Relational Database Design
|6
|701
|111