Reference no: EM13922116
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
|
Presenter notes section of the presentation
: Note: The slides in your presentation should include only the main points you wish to make, with more extensive information included in the presenter notes section of the presentation.
|
|
Explain crummey powers and how they are used
: Explain Crummey Powers and how they are used. What is the benefit of such an arrangement? Give some examples.
|
|
Calculate a table of interest rates for 5 years
: Future value of single sum problem. You put $2,000 in an investment account today which will earn 8% over the next 14 years, what is the future value?
|
|
Lease payments and utilities on the production
: During its first year of operations, Silverman Company paid $14,000 for direct materials and $19,000 for production workers' wages. Lease payments and utilities on the production facilities amounted to $17,000 while general, selling, and administrati..
|
|
Assignment on database management systems
: This lab assignment is to practice data modeling of a given user view of an online retail store.
|
|
Draw dependency diagram to show the functional dependencies
: Draw a dependency diagram to show the functional dependencies in the relation and decompose GRADE REPORT into a set of 3NF relations
|
|
Which costs are pertinent to economic decision making
: Which costs are pertinent to economic decision making? Which costs are not relevant? A noted economist was asked what he did with his "free time." He responded by saying that "time is not free." Explain this response.
|
|
How do agents and brokers differ
: How do agents and brokers differ? After hearing the advice that it is usually best to buy life insurance from a person who has been in the business at least five years, a life insurance company general agent became upset and said rather vehemently, “..
|
|
What was cost of goods sold for the year
: What was Cost of Goods Sold for the year Direct materials costing $70,236 were purchased.Direct labor cost was $26,268.
|