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 piano's data along with Current_User
Enter sample data for 2 technicians - technician 1 and technician 2
List technician's 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 technician's 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