Map the ER diagram for the Jones Dozers Sales and Rentals Database, shown in Fig
ID: 3749344 • Letter: M
Question
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 create this ER diagram in ERDplus and then convert it to a relational schema. Verify the converted relational schema to ensure correctness.]
LastInspectDate Date SerialNo DateMade Price RentTransID EQUIPMENT Rented Via RENTAL SRepLName SRepFName Conducts (SRrepName) CustID SRepID Rents Via Rank Sold Via CustName Has CUSTOMER SALES REP EquipDetailID CustCategor Buys Via (0,3) Conducts Mentor Protege EQUIPMENT DETAIL SaleTransID Mentors Make Model SALE Type Price Date Copyright 2014 Pearson EducationExplanation / Answer
If you have any doubts, please give me comment...
If you need SQL Schema, let me know...
CUSTOMER(CustID, CustName, CustCategory);
SALES_REP(SRepID, SRepLName, SRepFName, Rank, MentorID);
EQUIPMENT_DETAIL(EquipDetailID, Make, Type, Model);
EQUIPMENT(SerialNo, LastInspectDate, DateMade, EquipDetailID, SaleTransID);
RENTAL(RentTransID, Price, Date, EquipSerialNo, CustID, SRepID);
SALE(SaleTransID, Price, Date, CustID, SRepID);