DriEv, an Electric Vehicle (EV) rental company, is building an electronic database to manage its EV fleet of electric cars and bikes. 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)
Write an SQL insert statement to add a new Tesla Model S vehicle to the database where the vehicle id, brand, model and type are 172737, “Tesla”, “Model S” and “Liftback” respectively (year is not provided).
[4]
Short Answer4 MarksPremium
5 Uses4 Views2 Likes
Login or Create an Account to view the mark scheme, comment, and add to a test