Question: Look at the following ERD: Please create query for DML & DDL of RDBMS based on the ERD for: A) List service that are not
Look at the following ERD:

Please create query for DML & DDL of RDBMS based on the ERD for:
A) List service that are not ordered / bought during Jan 2020 until Dec 2020.
B) Update all price by adding 10% of current price for all car_model_id = 10.
C) Update status_id of service car that are not ordered during Jan 2020 until Dec 2020 into inactive.
Service Category id FK1 name status_id ServiceCar PK id FK1 category_id OcFK2 car_model_id price Car Model PK id + name + Service Transaction Detail |PK, FK transaction_id PK, FK service_id price Service Transaction IPK id date car_model_id FK2 customer_id #FK1 Customer IPK id FK1 name FK2 car_model_id vehicle_number vehicle_year
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
