ERD 2: 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 hierarc hy (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 recorde d. The person at the end of the auction with the highest bid price is declared th e winner and a t ransaction between the buyer and the seller may proceed soon after. Buyers and sellers may place feedback ratings on the purchase or sale of a n item. The feedb ack conta ins a rating between 1 and 1 0 and a comment. Note that the ratings are placed on a completed transaction by the buyer or seller of the item in the transaction.
ERD 2: 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 hierarc hy (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 recorde d. The person at the end of the auction with the highest bid price is declared th e winner and a t ransaction between the buyer and the seller may proceed soon after. Buyers and sellers may place feedback ratings on the purchase or sale of a n item. The feedb ack conta ins a rating between 1 and 1 0 and a comment. Note that the ratings are placed on a completed transaction by the buyer or seller of the item in the transaction.
Chapter1: Overview Of Database Concepts
Section: Chapter Questions
Problem 5HOA: Access path A database table is composed of records and fields hold data. Data is stored in records....
Related questions
Question
Transcribed Image Text:ERD 2:
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 hierarc
hy (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 recorde d. The pers on at the end
of the auction with the highest bid price is declared th e
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 a n item.
The feedback conta ins a rating between 1 and 1 0 and
a comment. Note that the ratings are placed on a completed transaction by the buyer
or seller of the item in the transaction.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage