Download cheatsheet databasees waddshe and more Study notes English in PDF only on Docsity! Fundamentals of Database Systems Assignment - Entity Relationship Diagram (By group) Create an Entitity Relationship Diagram. Consider an online auction database system in which members (buyers and sellers) participate in the sale of items. The data requirements for this system are summarized as follows: * The online site has members who are identified by a unique member id and are described by an email address, their name, a password, their home address, and a phone number. * Amember may be a buyer or a seller. A buyer has a shipping address recorded in the database. A seller has a bank account number and routing number recorded in the database. * Items are placed by a seller for sale and are identified by a unique item number assigned by the system. Items are also described by an item title, an item description, a starting bid price, bidding increment, the start date of the auction, and the end date of the auction. * Items are also categorized based on a fixed classification hierarchy (for example a modem may be classified as /COMPUTER/HARDWARE/MODEM). © Buyers make bids for items they are interested in. A bidding price and time of bid placement is recorded. The person at the end of the auction with the highest bid price is declared the winner and a transaction between the buyer and the seller may proceed soon after. © Buyers and sellers may place feedback ratings on the purchase or sale of an item. The feedback contains a rating between 1 and 10 and a comment. Note that the ratings are placed on a completed transaction by the buyer or seller of the item in the transaction. Criteria for grading: 1)Design of ERD - 30% 2)Correct format of ERD - 35% 3)Layout of submission (ER Diagram) — 15% 4)Properly followed all instructions — 20% Total — 100%