Write a C++ Program to show all the major functionalities of your database product, including the following activities:

1. First, display the ER-diagram (10 pts);

2. For each table, perform a query to show all data; (20 pts)

3. For each table, perform a query using at least one of the aggregate functions; (30 pts)

4. For each relationship, perform a joint query on the tables that are DIRECTLY related through that relationship. (40 pts)

Key Attributes For Attributes :

(i) For Employment : Social_Security_Number

(ii) Support Staff : Staff_ID

(iii) Administrator : Unique_ID

(iv) Auto Salesman : Salesman_ID

(v) Vehicle Parts : Product_ID

(vi) Vehicle : VIN_Number , License_Plate_Number , Registration_Number

(vii) Customer : Social_Security_Number

Relationships :

(i) 1 Customer can buy N vehicle from a auto salesman , Similarly N Customers can buy M vehicles from auto salesman. So , 1:N---N:M multiplicity between Customer and Auto Salesman.

(ii) 1 Employment can have only 1 support staff. So , 1:1 multiplicity between Employment and Support Staff.

(iii) 1 Employment can have only 1 Administration. So , 1:1 multiplicity between Employment and Administration.

(iv) 1 Administration can buy N vehicle Parts , Similarly N Administration can buy M vehicle parts. So , 1:N---N:M multiplicity between Administration and Vehicle Parts.

(v) 1 Auto Salesman manages 1 Employment. So 1:1 multiplicity between Auto Salesman and Employment.

(vi) 1 Auto Salesman can purchase N Vehicles. So , 1:N multiplicity between Auto Salesman and Vehicle.

(vii) 1 Vehicle needs N Vehicle Parts for repairing. So , 1:N multiplicity between Vehicle and Vehicle Parts.