Database Management Systems

Assignment

This lab assignment is to practice data modeling of a given user view of an online retail store.

You must complete the assignment independently and submit your original work. "Plagiarism or duplicate lab assignments will be given a grade of 'zero', a point deduction equivalent to one final grade level (i.e. from a B- to a C-), and a charge of academic dishonesty. Both the person copying the assignment and the person supplying the copy will be penalized equally."

1. The Online Store User View

The screen below shows the screen of a book sold by the online store after a user (customer) searched the book on the web site.

2. Data Modeling Tasks

This assignment has the following tasks:

1) Analyze the data elements in the screen and categorize them into entities, entity types, attributes and relationships based on your understanding of the data and your domain knowledge on online retail store.

2) Draw an ER diagram to represent the data in the screen using either PowerPoint or Visio using Peter-Chen's ER diagram notation. Your ER diagram need to capture all

CIS 3730 Database Management Systems data elements appeared in the screen and show the entity types and their attributes and relationships between those entity types. You should extract the data from screen and don't need to assume other data not shown on the screen.

3) Explain your ER diagram by describing what data each entity type/attribute/relationship in the diagram represents and your decision on choosing the specific concept to represent the data.

The conceptual model must be complete:

Each entity type must be given a meaningful name

Each entity type must have an attribute or attributes

Each entity type must have a key attribute(s) shown as the underlined attribute(s) in the diagram. Each relationship must be given a meaningful name and connected to entity types in the diagram