Consider an ONLINE_AUCTION database system in which members(buyers and sellers) participate in the sale of items. Design anER/EER diagram for this ONLINE_AUCTION database. The datarequirements for this system are summarized as follows:
• The online site has members, each of whom is identified by aunique member number and is described by an e-mail address, name,password, home address, and phone number.
• A member may be a buyer or a seller. A buyer has a shippingaddress recorded in the database. A seller has a bank accountnumber and routing number recorded in the database.
• Items are placed by a seller for sale and are identified by aunique item number assigned by the system. Items are also describedby an item title, a description, starting bid price, biddingincrement, the start date of the auction, and the end date of theauction.
• Items are also categorized based on a fixed classificationhierarchy (for example, a modem may be classified as COMPUTER →HARDWARE → MODEM).
• Buyers make bids for items they are interested in. Bid price andtime of bid is recorded. The bidder at the end of the auction withthe highest bid price is declared the winner and a transactionbetween buyer and seller may then proceed.
• The buyer and seller may record feedback regarding theircompleted transactions. Feedback contains a rating of the otherparty participating in the transaction (1–10) and a comment.