A piano manufacturer employs piano technicians who are responsible for inspecting the instruments before they are shipped to the customers. Each piano is inspected by at least two technicians (identified by their employee number). For each separate inspection, the company needs to record its date and a quality evaluation grade.

Based on the following ERD

Create all relevant tables with the following constraints: *

Serial Number > 0

Employee Number > 0 and Employee Number < = 50

Quality Grades are: Excellent, Good, Satisfactory, Poor, Unacceptable

Enter sample data for 2 pianos piano 1 and piano 2

List pianos data along with Current_User

Enter sample data for 2 technicians technician 1 and technician 2

List technicians data along with Current_User

Technician 1 inspected piano 1 twice and technician 2 inspected piano 2 twice. Enter sample dates and quality grades for this case.

List all inspection dates and quality grades along with Current_User and foreign keys to pianos and technicians

Add attribute Employee Address

Enter sample addresses for 2 technicians

List technicians names and addresses along with Current_User

Remove all pianos from the database **

Confirm that that PIANO table is empty

Delete all tables

Confirm that deleted tables do not exist in your database catalog

* Hint: before creating tables map ERD to logical data model that describes tables and their primary and foreign keys.

** Hint: before deleting parent data delete their children data