( Reference: Textbook Minicase MC3, pp. 90 ) Map the ER diagram for Snooty Fashi

Question

(Reference: Textbook Minicase MC3, pp. 90)

Map the ER diagram for Snooty Fashions Operations Database (created in Assignment 2) into a relational schema using ERDplus. You may refer to the Assignment 2 solution (available under Week 2 folder at 12:01 am on Tuesday morning of Week 2) to see the correct ER diagram for the requirements provided. Insert the relational schema image as you answer.

[Hint: You can convert the ER diagram created in ERDplus directly into a relational schema. Verify the converted relational schema to ensure correctness.]

Explanation / Answer

Customer(CustID,CustName,NumOutfits)

CustomerPhone(CustID,CusPhone)

Outfit(OutfitID,OutfitPrice,OutfitPDOC,CustID,DesID)

Designer(DesID,DesSSN,DesFname,DesLname,FSID)

FashionShow(FSID,FSDate,FSLocation)

WorksOn(TTSSN,OutfitID,DateStarted)

TailoringTechnician(TTSSN,TTFname,TTLname)

underlined are primary keys and italicized are foreign keys.

Do ask if any doubt. Please upvote.

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.