Question: Can anyone solve this for me using any database software ? The online site has members, each of whom is identified by a unique member

Can anyone solve this for me using any database software?

The online site has members, each of whom is identified by a unique member number and is described by an e-mail address, name, password

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, starting price, and end of auction date.

Items are also categorized based on a fixed classification hierarchy (for example, a modem may be classified as COMPUTERHARDWARE MODEM).

Buyers make bids for items they are interested in. Bid price and time of bid is recorded.

The buyer and seller may record feedback regarding their completed transactions. Feedback contains a rating of the other party participating in the transaction (110) and a comment.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Write SQL statements to retrieve the following: a. Name of all sellers b. Name of all buyers c. Name of sellers who have given a rating of 1 d. Name of buyers who have received a rating of 1 Consider...

EXERCISE using draw.io 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...

Can you please provide me with a correct Enhanced Entity Relation Diagram? I would like to check it with my own solution. Thank You! Consider an ONLINE AUCTION database system in which members...

Enhanced ER Modeling Problems :::: drawing the diagram is also needed. Consider an online auction database system in which members (buyers and sellers) participate in the sale of items. The data...

Create the relations using SQL statement in MS ACCESS and input at least 15 records for each relation. Make sure your input results in at least one output for each SQL statements Consider an ONLINE...

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...

1. Design EER diagram 2. Map your EER diagram into relational schema and specify all primary keys and foreign keys 3. Decompose your relations to 3NF 4. Create the relations using SQL statement in MS...

Consider the EER design for the ONLINE_AUCTION database that was modeled using a tool like ERwin or Rational Rose in Laboratory Exercise 4.29. Using the SQL schema generation feature of the modeling...

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...

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...

Argon gas (10.0 g) is added to a 10.0 L chamber fitted with a piston at 273K already containing 10.0 g of Nitrogen gas, causing an isothermal expansion of the chamber to 13.5 L. What is the new...

Anders is comparing two books, X and Y. He thinks book X is harder to read than book Y. a What things make a book hard or easy to read? b What statistical questions can you ask to compare how easy it...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

In Visual Studio 2017 with an open OLAP Cube, what is the connection to an advanced OLAP viewer?

What is the main benefit of the multidimensional framework of OLAP Cubes?

Provide an example of how the sort level Unspecified can be excluded from the Gender Dimension in a Pivot Table worksheet genderwaggap01.