quiz5-er-model-solutuion.pdf - Name USC ID Quiz 5 ER Modeling(10 points 15 minutes Please depict an ER diagram to model an application that manages the

quiz5-er-model-solutuion.pdf - Name USC ID Quiz 5 ER...

This preview shows page 1 out of 1 page.

Name: ___________________________ USC ID: ______________________ INF 551, Spring 2017 Quiz 5: ER Modeling (10 points. 15 minutes) Please depict an ER diagram to model an application that manages the purchases made at electronic stores, with the following requirements. For each store , it needs to record its ID ( unique ), name , and city where the store is located. For each product , it records its serial number ( unique ), brand , model , and price . It also needs to record operating system and hard drive , but only for laptops . For each purchase , it needs to record the name of buyer and seller (i.e., sales person), the store where the purchase was made, the products purchased, and the purchase date . For each buyer and seller , it records his/her
Image of page 1

You've reached the end of your free preview.

Want to read the whole page?

  • Fall '14
  • Entity-relationship model, Entity Set, use of wrong shape, missing attribute

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes