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

  How to use traditional database design method

Explain how you would follow three phases of traditional database design method (Hierarchical, Network, and Relational), considering the following scenario.

  Decompose relation into relations which are in bcnf

it is not essential to give violations which have more than one attribute on right side. Decompose the relation, as essential, into collection of relations which are in BCNF.

  Query using a literal character string

query specifying specific columns query using a column alias query using the concatenation operator query using a literal character string

  Create the digitalx database

Create the DigitalX database. Design tables and relationships and ensure that email addresses may only be used once in the database.

  Design er schema to keep track of information of votes

Design an er schema for keeping track of information about votes taken in the U.S. House of Representatives during the current two year congressional session.

  Write sql select statements to retrieve

How many models of the Titanic have been shipped? What was the date of the first shipment and when was the last shipment sent - Write SQL SELECT statements to retrieve

  Write an essay on marketing management

The customer is always right -The customer doesn't know what's best. It's the baker's (marketer's) job to educate him. The above statements succinctly point out a subtle battle which rages within the marketing discipline.

  Design a database for an insurance company

Consider a video game store. For each game, the database contains information about title, producing company name, designer(s) name(s), version of the game, type of the game and characters in the game.

  Describe the core concepts of data quality

Write clearly and concisely about relational database management systems using proper writing mechanics and technical style conventions.

  Create a relational database schema

Draw the ER diagram for the database described above and create a relational database schema for this model assuming

  Discuss the formula for computing entropy

The paper must discuss the relationship of Entropy to the likelihood that an attack can be successful, the formula for computing Entropy.

  Explain evaluating a proposal for acquisition and sourcing

When evaluating a proposal for acquisition and sourcing, are there considerations that are unique in the case of an IT project versus a non-IT project

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!

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