100%(5)5 out of 5 people found this document helpful
This preview shows page 1 out of 1 page.
Name: ___________________________USC ID: ______________________INF 551, Spring 2017Quiz 5: ER Modeling (10 points. 15 minutes)Please depict an ER diagram to model an application that manages the purchases made at electronicstores, with the following requirements.For eachstore, it needs to record itsID(unique),name, andcitywhere the store is located.For eachproduct, it records itsserial number(unique),brand,model, andprice.It also needs to recordoperating systemandhard drive, but only forlaptops.For eachpurchase, it needs to record thename of buyer and seller(i.e., sales person), thestorewhere the purchase was made, theproductspurchased, and the purchasedate.For eachbuyerandseller, it records his/her
You've reached the end of your free preview.
Want to read the whole page?
Entity-relationship model,Entity Set,use of wrong shape,missing attribute