Design an entity relationship diagram

Assignment Help Database Management System

Reference no: EM131252369

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.

• A member 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 rating is placed by the buyer or seller involved in the completed transaction.

Design an Entity-Relationship diagram for the auction database and enter the design using a data-modeling tool such as ERWin.

Reference no: EM131252369

Questions Cloud

Research children health issue focus on environmental factor : Research children's health issues, focusing on environmental factors and links to poverty. The assessment of environmental processes includes agents and factors that predispose communities and populations to injury, illness, and death.

Discuss the use of figurative language in the poem plum : Discuss the use of figurative language in the poem "Plum" (205) - Discuss how the AIDS epidemic is portrayed in the poem "Thinking about Bill. Dead of AIDS" (634).

Describe at least three special education services : Describe at least three special education services for students with impairments in sight and hearing;

Design an enhanced entity relationship diagram : Design an enhanced Entity-Relationship diagram for the grade book database and enter the design using a data-modeling tool such as ERWin.

Design an entity relationship diagram : Design an Entity-Relationship diagram for the auction database and enter the design using a data-modeling tool such as ERWin.

Calculate the firm marginal revenue and marginal cost : Calculate the firm's marginal revenue and marginal cost at every level of output. Is this firm operating in perfect competition? How do you know? Find the firm's maximum profit output and maximum profit price

Develop a thesis pertaining to the assigned film text : Writing an outline for a five paragraph analytical essay building on a clear and concise thesis statement, including topic sentences and secondary supports. Identifying and explaining three scenes from the film text in support of the thesis statem..

What are two main goals of federal aviation administration : What are two main goals of Federal Aviation Administration? Describe them. Who is current FAA Administrator? Tell me about him. According to the text, list and describe the six safety certificates issued by the FAA.

Design an entity relationship diagram : Design an Entity-Relationship diagram for the baseball database and enter the design using a data-modeling tool such as ERWin.

User Account

All Pages