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:

Look at the following ERD: Please create query for DML & DDL

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!