Login or Create an Account to view the mark scheme, comment, and add to a test
DriEv, an Electric Vehicle (EV) rental company, is building an electronic database to manage its EV fleet of electric cars and bikes. DriEv records and tracks vehicles, customers and rental agreements.
(a).
Outline one benefit an electronic databases, compared to only keeping paper records, affords DriEv.
[2]DriEv’s electronic database design includes the following schema:
tbl_vehicles(vehicle_id, year, brand, model, type)
tbl_rentals(vehicle_id, start_date, days_rented, daily_rate, customer_id)
tbl_customers(customer_id, last_name, first_name, email)
(b).
What is the degree relationship between tbl_vehicles records and tbl_rentals records respectively?
[1]DriEv recently acquired a new Tesla Model S to add to its growing fleet of EVs.
(c).
Write an SQL insert statement to add a new Tesla Model S to the database where the vehicle id, brand, model and type are 172737, “Tesla”, “Model S” and “Liftback” respectively (year is not provided).
[4]Alaister, a manger at DriEv, would like to know how many unique customers in total have rented a Tesla vehicle since the company was founded.
(d).
Create a query to fulfil Alaister’s request for information.
[5]
Extended Response12 MarksPremium
6 Uses26 Views3 Likes