Login or Create an Account to view the mark scheme (answer), 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’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
6 Uses23 Views3 Likes