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

Please create query for DML & DDL of RDBMS based on the ERD for:
A) List service transaction where the date is February 2020. Display Column : id, date, car model name, vehicle number, customer name, service name, price. B) List total income for each service in 2020 (year). Display Column : service name, total income
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
