aa

Database Design Exercise (

Go to www.ebay.com and browse various features that are available. In doing so, consider the database entities that may exist in the database that supports the ebay application. Using the database modeling approach demonstrated in class, create an Entity Relationship Diagram (ERD) to represent how the database entities are related. Also define the primary and foreign keys on each entity.

Points Requirement

25 Listing of Key Entities

25 Primary Keys Defined

25 Foreign Keys Defined

25 Entity Relationships Defined

Evaluation

· Please complete the database design and turn in on paper.

· This assignment may be hand written

· Selected students will be asked to present their web sites to the class.

Basic ERD Symbols

PK

Primary Key

May Have

FK

Foreign Key

Must Have

One and only one

One or more