COMP1711: Data Dictionary for Car Rental System Database Design

This assignment presents a comprehensive data dictionary for a car rental system, detailing various entities such as Service, Vehicle, FleetMembership, Tariffs, Drivers, Invoice, Client, Company, and Depot. Each entity's attributes are described, including their data types, lengths, and whether they can be null. The dictionary provides a structured overview of the database schema, outlining key information such as service details, vehicle specifications, fleet and tariff information, driver and client details, and financial aspects like invoices and insurance policies. The document also includes details on relationships, such as foreign keys, to establish connections between the tables. This structured presentation of the database design aids in understanding the system's architecture and data organization, serving as a valuable resource for database design and analysis.

COMP1711
Attributes Data Dictionary
Student Name: Student Id: Student FAN:
Student Name: Student Id: Student FAN:
Entity or
Relationship
Name
Attributes Description
Data Type
and
Length
Null
s
Multi-
valued
Service ServiceID unique service
number int Not
Null
RegistrationNumber unique registration
number String(7) Not
Null
Date service date Date Not
Null
Service Description description of
service details String(50) Not
Null
Cost cost of service Number(5) Not
Null
Vehicle RegsitrationNumber unique registration
number String(7) Not
Null
FleetMembershipNumb
er
unique fleet
membership
number
int Not
Null
Colour clour of vehicle String(20) Not
Null
Make maker of vehicle String(8) Not
Null
NumberOfDoors number of doors of
vehicle int Not
Null
BodyStyle body style of vehicle String(8) Not
Null
TrimLevel trim level of vehicle String(8) Not
Null
Depotcode unique depot code int Not
Null
FleetMembershi
p
FleetMembershipNumb
er
unique fleet
membership
number
int Not
Null
Tariffs TariffCode unique tariff code String(2) Not
Null
Conditions tariff descriptions String(50) Not
Null
RegistrationNumber unique registration
number String(7) Not
Null
DailyRental daily rent with tariff Number(3) Not
Null
Drivers DriverID Unique driver
number int Not
Null

COMP1711
DriverLicense unique license
number String(12) Not
Null
DriverName name of driver String(49) Not
Null Yes
Invoice InvoiceID unique invoice
number int Not
Null
BookingID unique booking
number int Not
Null
FinalCost Final cost Currency(5
)
Not
Null
ClientID unique client
number int
Not
Null
PayDate Payment Date
Not
Null
Booking BookingID unique booking int
Not
Null
Time Time of booking Date
Not
Null
Date Date of booking Date
Not
Null
PickUpDepot unique pickupdepot
number int
Not
Null
DropOffDepot unique dropoffdepot
number int
Not
Null
CreditCardType Credit card type String(2)
Not
Null
CreditCardNumber Credit card number String(21)
Not
Null
DriverID unique driver
number int
Not
Null
ClientID unique client
number int
Not
Null
Distance Total distance Number(5)
Not
Null
TariffCode unique tariffcode
number int
Not
Null
NumberOfDays Number of days Number(2)
Not
Null
PolicyID unique policy
number Number(5)
Not
Null
Client ClientID unique client int
Not
Null
DriverLicense Driver license String(12)
Not
Null
ClientName Client name String(49)
Not
Null Yes
Address Depot address String(49)
Not
Null Yes

COMP1711
PhoneNumber Phone number Number(2)
Not
Null
Company CompanyID unique company int
Not
Null
ClientID unique client
number int
Not
Null
CompanyName Company name Stiring(15)
Not
Null
Insurance PolicyID unique policy
number Number(5)
Not
Null
PolicyType Policy type String(10)
Not
Null
Cost Cost of insurance
Currency(3
)
Not
Null
Depot DepotCode unique depot code int
Not
Null
Address Depot address String(49)
Not
Null Yes
PhoneNumber Phone number String(14)
Not
Null
FaxNumber Fax number String(14)
Not
Null
Location Depot location String(20)
Not
Null Yes