Database Design

Design an E-R Diagram for a marketplace company (such as e-Bay) where individuals can sell and buy products.

The ER must be able to keep track of customers who sell items and customers who bought them; some customers may do both.

Customer info must include street address, city, state, and zip code. Product info must include name, description, color, and size.

Each product sold or for sale must be identifiable, so the E-R must be able to store the sale date if sold, and the current status of the sales process (available, ordered, shipped, delivered).

Develop an ER diagram for each of these questions based on Ebay.

1. Define entity sets that contain all data objects that you need. Define attributes and a primary key for each entity set

2. Define relationships between entities that reflect the requirements completely

3. Define total and partial participation in the relationships

4. Improve your design: eliminate redundancy, correct errors, etc