Refer to the ER diagram and prepare/ edit the relational schema:

Refer to the Relational Schema as follows and edit it:

Relational Schema

Customer(CustomerID, fName, lName, Adress, Sex, SalesID)

Cust_Email(CustomerID, Email)

Cust_Phone(CustomerID, Phone)

Salesman(SalesID, fName, lName, Email, Phone, Sex, Salary)

Car(CarID, madeYear, Trim, Transmission, Cost)

Car_Color(CarID, Color)

Deal(DealID, CarID, startDate, endDate, Discount, salePrice)

Sale(PayID, DealID, CustomerID, SalesID, CarID, invoiceNo,)

Sale_PayMethod(PayID, PayMethod, Amount)

And answer the questions:

Q1. Develop a relational Schema/ correct the given schema. (Most important thing)

Q2. List all the foreign keys, alternate keys and Primary keys given.

Q3. Write the relation between Car, Salesman, and other entities.

Deal PayID invoiceNo customerID PayMethod[] deal ID DealID (P.K.) CarlD startDate endDate Discount salePrice Customer Car CustomerlD (P.K Name IName Adress Email[1..2] Phone[1..2] Sex CarlD (P.K.) madeYear Trim Transmission Cost colorl1 Sale Salesman SaleslD (PK.) fName IName Email Phone Sex Salary