University Data Modelling Assignment Solution: Wheels-4-U Project

This document presents a comprehensive data modeling assignment solution for the Wheels-4-U case study. It begins with the construction of an information model, detailing the entity data dictionary, which describes various entities such as FleetMember, Vehicle, and Booking, along with their aliases and occurrences within the organization. The solution then outlines the relationship data dictionary, illustrating relationships like 'MemberOf,' 'ServicedBy,' and 'BookedBy,' providing descriptions and occurrences. A relationship-entity data dictionary is also included, specifying multiplicities for each entity in the relationships. Furthermore, the assignment includes a detailed attributes data dictionary, defining attributes for each entity, such as Service_ID, RegistrationNo, and ClientID, along with data types, lengths, nullability, and multi-valued characteristics. Finally, an Entity-Relationship Diagram (ERD) visually represents the data model, offering a clear understanding of the relationships between entities.

Running head: DATA MODELLING ASSIGNMENT
Data Modelling Assignment: Wheels-4-U
Name of the Student
Name of the University
Author’s Note

1
DATA MODELLING ASSIGNMENT
1. Construction of Information Model
1.1. Entity Data Dictionary
Name of the Entity Description Aliases Occurrence
FleetMember VehicleMembership Member Many
Vehicle VehicleDescription Car Many
Service VehicleService RepairWork Many
Depot VehicleLocation Location Many
Booking HireDetails Hire Many
Tarrif DiscountDetails Discount Many
Driver DriverInformation Drivers Many
Invoice BookingBillingDetails Billing Many
Company ClientCompany Organization Many
Client CleintDetails Customer Many
1.2. Relationship Data Dictionary
Name of the
Relationship
Description Aliases Occurrence
MemberOf VehicleMembership Grouped in One
ServicedBy Vehicle Serviced Serviced by One
LocatedAt LocateVehicle Currently at One
Applied Applied Discount Discounted Many
DrivenBy AllocateDriver Allocated One
BookedBy VehicleBooking Booking Many
PaidFor BookingPayment Paid One

2
DATA MODELLING ASSIGNMENT
WorksFor Job Description Works One
InsuredFor Description of
Insurance Claim
Insured by Many
PaidBy CustomerPayment Account One
PickedAt Pick up and dropped
by driver
Drop location
1.3. Relationship-Entity Data Dictionary
Entity Multiplicity Relationship Multiplicity Name
Vehicle Many Member of One FleetMember
Vehicle One Service By Many Service
Vehicle Many Location Many Depot
Booking Many Drove by One Driver
Booking Many Applied One Tarrif
Invoice One PaidFor One Booking
Booking Many BookedBy One Cleint
Invoice One PaidBy One Client
Client One WorksFor One Company
Insurance One InsuredFor Many Booking
Booking One PickedAt Many Depot
1.4. Attributes Data Dictionary
Name of
Relation
Attributes Description Length
and Type
Null
Value
Multi
Valued

3
DATA MODELLING ASSIGNMENT
of
DataType
Service Service_ID It should be
unique
Int NotNull
Registratio_Numbe
r
It should be
unique
String NotNull
Date Date of
service is
needed to be
recorded
Date NotNull
ServiceDescription Description
of service
and details
String NotNull
Cost Service
Cost details
Number NotNull
Vehicle RegistrationNo It should be
unique
String NotNull
FleetmembershpNo It should be
unique
Int NotNull
Colour Vehicle
colour
String NotNull
Make Make
details of
the vehicle
String NotNull
NoOfDoors Details of Int NotNull

4
DATA MODELLING ASSIGNMENT
number of
doors in the
vehicle
Body Style Vehicle
body style
String NotNull
TrimLevel Vehicle trim
level details
String NotNull
DepoCode It should be
unique
Int NotNull
Tarrif TarrifCode It should be
unique
String NotNull
Condition Description
of the tarrif
String NotNull
RegistrationNo It should be
unique
String NotNull
RentDelay Details of
daily rent
and tarrifs
String NotNull
FleetMember FleetMemberNo It should be
unique
Int NotNull
Driver DID It should be
unique
Int NotNull
DLicense It should be
unique
String NotNull
DName Driver name String NotNull

5
DATA MODELLING ASSIGNMENT
Invoice InvoiceID It should be
unique
Int NotNull
BookingID It should be
unique
Int NotNull
FinalCost The
payment
details of
booking
Currency NotNull
ClientID It should be
unique
Int NotNull
PaymentDate Payment
details is
needed to be
recorded
String NotNull
Booking BookingID It should be
unique
Int NotNull
Date Booking
date
Date NotNull
Time Booking
time details
Date NotNull
PickingUpDepo It should be
unique
Int NotNull
DroppingOffDepo It should be
unique
Int NotNull
TypeOfCreditCard Details of String NotNull

6
DATA MODELLING ASSIGNMENT
credit card
type
CreditCardNo Details of
credit card
number
String NotNull
DriverID It should be
unique
Int NotNull
ClientID It should be
unique
Int NotNull
DriverID It should be
unique
Int NotNull
TarrifCode It should be
unique
Int NotNull
Distance The total
distance
travelled
should be
recorded
Number NotNull
PolicyID It should be
unique
Int NotNull
NoOfDays The details
of usage and
number of
days should
be recorded
Number NotNull

7
DATA MODELLING ASSIGNMENT
Client ClientID It should be
unique
Int NotNull
DrivingLicense The details
of driver
license it
should be
recorded
String NotNull
CName The name of
the client
should be
recorded
String NotNull
Address The details
of depo and
client
address
should be
recorded
String NotNull
ContactDetails The phone
number or
email Id
should be
recorded
String NotNull
Company CompanyID It should be
unique
Int NotNull
ClientID It should be Int NotNull

8
DATA MODELLING ASSIGNMENT
unique
CompanyName The name of
the
company
details
should be
recorded
String NotNull
Insurance PolicyID It should be
unique
Int NotNull
TypeofPolicy The details
of the policy
is needed to
be recorded
String NotNull
Cost The
insurance
cost is
needed to be
recorded
Currency NotNull
Depot DepoCode It should be
unique
Int NotNull
Address The address
of the depo
should be
present
String NotNull
ContactDetails The phone String NotNull

9
DATA MODELLING ASSIGNMENT
or email id
should be
there to
reach the
depo
FAX Fax number
is needed to
sending
important
document
String NotNull
Location The location
of the depo
should be
available
String NotNull

10
DATA MODELLING ASSIGNMENT
2. Entity-Relationship Diagram (ERD)