User Account

All Pages

Develop an entity-relationship diagram

Assignment Help Database Management System
Reference no: EM13334050

Advanced Entity Relationship Diagram

An online video distributor such as Netflix might want to create an information system for online sales of movies in both DVD and Blu-ray format. People will be allowed to register as customers of the online site and to update their stored information. Information must be maintained about customers' shipping addresses, e-mail addresses and credit cards. In a single sale, customers will be allowed to purchase any quantity of videos. The items in a single sale will be shipped to a single address and will have a single credit card charge.

A customer will be provided with a virtual shopping cart to stare items to be purchased. As each item is selected, it is added to the shopping cart. When the customer finishes shopping, he will be directed to a checkout area where he can purchase all of the items in the shopping cart. At this time, payment and shipping information is entered. Once the sale is complete, the shopping cart will be deleted and the customer will be sent a receipt bye-mail.

1.      List the entity classes and attributes that would be necessary for this information system.

2.      Develop an Entity-Relationship Diagram that would represent the necessary entities and their relationships.

3.      You may hand-draw and scan your ERD, create the ERD in Word, PowerPoint, or Access, or use a dedicated ERD creation program such as E/R Assistant, available for download at:

https://highered.mcgraw-hill.com/sites/0072942207/student_view0/e_r_assistant.html

 

Reference no: EM13334050

Questions Cloud

What is the stock price today assuming a required return : In practice, a common way to value a share of stock when a company pays dividends is to value the dividends over the next five years or so, then find the "terminal" stock price using a benchmark PE ratio.
Explain carbon dioxide gas measured at 30.0 degrees c : How many ml of 0.122 M MnO4- are required to react with an excess of C2O4^2- in order to produce 75.25 ml of carbon dioxide gas measured at 30.0 degrees C and 715 torr? MnO4- (aq) + C2O4^2- (aq) -------> MnO2 (s) + CO2 (g) Basic solution
Find the work involved in increasing her angular speed : A ballerina spins initially at 1.06 revs/second when her arms are extended. She then draws in her arms to the body, find the work involved in increasing her angular speed
Determine the potential energy of the pair of charges : Two point charges Q1 = +4.30 nC and Q2 = -2.30 nC are separated by 27.0 cm. What is the potential energy of the pair of charges
Develop an entity-relationship diagram : List the entity classes and attributes that would be necessary for this information system.
What is probability that more of the business travelers say : A Travel Weekly International Air Transport Association survey asked business travelers about the purpose for their most recent business trip. 19% responded that it was for an internal company visit.
Calculate the total electric potential at the origin : Two point charges are on the y-axis. A 5.0 µC charge is located at y = 1.40 cm, and a -2.30 µC charge is located at y = -1.60 cm. Find the total electric potential at the origin
What will you need to understand and measure : 1. What will you need to understand and measure for an effective reengineering project?
Determine how much must be remitted for the purchase : The current price of the $1,000 bond is $978. On February 1, you purchase $10,000 face amount, and your broker charges a $25 commission. How much must you remit for the purchase

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd