Map the ER diagram for the Jones Dozers Sales and Rentals Database, shown in Figure 1,...

Transcribed Image Text:

Map the ER diagram for the Jones Dozers Sales and Rentals Database, shown in Figure 1, into a relational schema using ERDplus. Insert the relational schema image as you answer. [Hint: You can first create this ER diagram in ERDplus and then convert it to a relational schema. Verify the converted relational schema to ensure correctness.] LastInspectDate SerialNo Make EQUIPMENT EquipDetailID Has EQUIPMENT DETAIL Type DateMade Model Rented Via Sold Via Price SaleTransID Price Date RENTAL Rents Via Buys Via SALE Date RentTransID CustID CUSTOMER Conducts CustName (CustCategory) Conducts (SRepLName) SRepID SALES REP (0,3) Mentor (SRrepName) (0,1) SRepFName Protege Mentors Rank Map the ER diagram for the Jones Dozers Sales and Rentals Database, shown in Figure 1, into a relational schema using ERDplus. Insert the relational schema image as you answer. [Hint: You can first create this ER diagram in ERDplus and then convert it to a relational schema. Verify the converted relational schema to ensure correctness.] LastInspectDate SerialNo Make EQUIPMENT EquipDetailID Has EQUIPMENT DETAIL Type DateMade Model Rented Via Sold Via Price SaleTransID Price Date RENTAL Rents Via Buys Via SALE Date RentTransID CustID CUSTOMER Conducts CustName (CustCategory) Conducts (SRepLName) SRepID SALES REP (0,3) Mentor (SRrepName) (0,1) SRepFName Protege Mentors Rank