Attributes Data Dictionary

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