CIS3730 Lab Assignment #5 Complete Solution

Question: #8923

CIS 3730 Database Management Systems
Lab Assignment #5

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

3. Assignment Submission & Assessment Rubric
The submission of this assignment is a Word document containing:
Your ER diagram
Explanation of the model.
Upload the Word document to the Lab Assignment 5 in the Dropbox in Brightspace. The Access database is not required.
The assessment rubric for each query is shown below: Weight
Correct representation
50%
Model completeness
20%
Explanation
30%
Note that a late assignment is accepted 24 hours after the due date with a 10% penalty. The assignment dropboxe is configured to accept late submissions up to 24 hours after the due date/time. Lab assignment submission by email is not accepted.

Solution: #8951

CIS3730 Lab Assignment #5 Complete Solution

3.1 Product • List price is a real number represents the listing price of the product, e.g $17.00 • Dimenssion is a composite attribute of width and height •...