Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider the following data requirements for an AUCTION site The AUCTION site has members, each member is identified by a unique ID and has an
Consider the following data requirements for an AUCTION site The AUCTION site has members, each member is identified by a unique ID and has an e-mail address, name (First, Middle, and Last name), birth date, age, password, home address, and phones' numbers. The database should keep track of the country, city, and zip code of the .member's home address A member must be a buyer, a seller, or both. A buyer has a shipping address that should be recorded. A seller has a bank name and IBAN (International Bank (Account Number The database should keep track of the items; and each item has an item name, a description, starting bid price, bidding increment, the start date of the auction, the end date of the auction, and the duration of the auction. In addition, each item is placed by one seller for bidding and is identified by a unique ID. The seller can place many items for bidding Buyers make bids for items they are interested in. Bid price and time of bid are recorded. The bidder at the end of the auction with the highest bid price is declared the .winner The winner must feedback to the seller regarding their completed transaction. Feedback contains a rating (1 to 10) and a .comment Design and draw an enhanced entity- relationship diagram (EER- diagram) for the AUCTION sit using min-max notation
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started