The following EER diagram models the business rules of an online auction website
ID: 3879805 • Letter: T
Question
The following EER diagram models the business rules of an online auction website
Based on your understanding of the above EER diagram, mark each of the following statements as True or False, and justify your answer:
1. A member can be a seller and buyer at the same time.
2. A buyer can bid on several items.
3. A buyer can be uniquely identified by his email address.
4. Several sellers can sell the same item.
5. A member should be a seller or a buyer.
DESCRIPTION HOME ADDRESS ITEM TITLE PHONE NUMBER PASSWORD PRIZE NAME SELL START DATE EMAIL ADDRE MEMBER ITEM END DATE BID NUMBER HIGEST PRICE RECORD BUYER SELLER RATING THE PARTICIPAN BID PRICE BANK ACCOUN NUMBER TIME FEEDBACK SHIPPING ADDRESS ROUTING NUMBER COMMENTExplanation / Answer
1. A member can be a seller and buyer at the same time.: False, as you can see Buyer ISA Member and Seller ISA member, but different entity
2. A buyer can bid on several items.: Member BIDS(relationship) ITEM is m to n relationship
3. A buyer can be uniquely identified by his email address: False, because email alone is not a primary key, but email and member number together make composite primary key
4. Several sellers can sell the same item.: No, because it is a 1 to M relation
5. A member should be a seller or a buyer.: true