Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Development For Dummies

Authors: Allen G. Taylor

1st Edition

978-0764507526

More Books

Students also viewed these Databases questions

Question

4. What will the team agreement contain?

Answered: 1 week ago