Question
GoGoGo is a car rental company with branches located throughout Ireland. Each branch has an id, address, and county. Branches can have several phone numbers.
GoGoGo is a car rental company with branches located throughout Ireland.
Each branch has an id, address, and county.
Branches can have several phone numbers.
Each site is allocated a stock of vehicles for hire,
A vehicle can be assigned to only one branch at a time.
A vehicle has a registration number, model, year, status (available, hired, broken), capacity (how many people can fit inside), cost to rent per day and which branch it is currently assigned to.
Each vehicles registration number uniquely identifies them and is used when a customer rents a vehicle.
Customers can rent one or more vehicle at a time.
For each rental we need to know which vehicle or vehicles were rented by which customer, which staff member was responsible for the rental as well as the date the customer started the rental period, and the date the customer wishes to terminate the rental.
Customers may rent vehicles for various periods of time (minimum 1 day to maximum 1 year).
Each individual rental agreement between a customer and the Company is uniquely identified using a rental number.
The data stored on customers includes the customer id, name, phone number, date of birth, and driving licence number.
All customers must have a driving license.
Information stored about staff includes staff id, name, phone number, date hired, job title, and salary.
Each staff member is associated with a single branch but may be moved to an alternative branch as required, although only the current location for each member of staff is stored.
Create a Logical Entity Relationship diagram of your database normalised to 3rd Form. Include Primary/foreign keys and intersection tables.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started