Data Modelling Assignment: Wheels-4-U

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