Please enable JavaScript.
Coggle requires JavaScript to display documents.
Charisma Technology Furniture Database (Staff Table (Full name, Car…
Charisma Technology Furniture Database
Staff Table
Full name
Car Licence (BOOLEAN)
Truck Licence (BOOLEAN)
Reason for booking
Department
ID number
Licence Infringements/Demerit Points
PRIMARY KEY = ID
Vehicle table
Types of vehicles
Car
Truck
Requires truck licence
Van
Vehicle Registration
Vehicle Model
Vehicle Insurance
Fuel Type
Diesel, petrol, e.c.t
Maintenance things
mileage
incidents
date of last service
date of next service
PRIMARY KEY = REGO
Project Management
Part A
Draft: Thrusday 12th September
Final: Tuesday 17th September
Part B
Draft: Friday wk 1 Term 4
Final: Friday wk 2 Term 4
Rentals
Staff member
Car [REGO = ID]
Date/Time rented
Reason
Date/Time returned
Incidents (if applicable)
Mileage before/mileage after
PRIMARY KEY = REGO + DATE