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

  Selecting opies of book titled the big magic

How many copies of the book titled „The big magic? are owned by the local library whose name is "Newtown" library?

  Provide an expression in relational algebra

Provide expression in relational algebra for each of the following queries: Give all the managers in database a 10 percent salary raise. Give all the other employees a 5 percent salary raise.

  Prepare a dfd and context diagram for the system

Journal entries have to be reconciled with the spreadsheet on a daily basis - Prepare a context diagram for the system and also prepare a diagram 0 DFD for the system

  Creates a database named personnel

Write an application that creates a database named Personnel. The database should have a table named Employee, with columns for employee ID, named position, and hourly pay rate.

  Express the relationships graphically with an e-r diagram.

A vendor builds multiple types of tablet computers. Each hs a type identification number and a name. The key specifications for each type include amount of storage and display type.

  Solve the serious data redundancy problems

One of the many problems with data redundancy is the likely occurrence of data inconsistencies-two different initials have been entered for the teacher named Maria Cordon.)

  Explain relational database and metadata

Which is not a factor to consider in software evaluation and explain relational database and Metadata - Build an entity relationship model

  Study on managing the software enterprise

This course is for those in a management capacity, or those interested in management, involving the strategic consideration of software acquisition, development and project management.

  Write select statement that returns two columns

Write a SELECT statement that returns two columns: VendorName and PaymentSum, where PaymentSum is the sum of the PaymentTotal column.

  Explaining concept of organizational intelligence

Need a page and half on concept of organizational intelligence. It must specifically talk about organizational intellignece being outcome of organization's efforts to gather store, process and interpret data.

  Find all non-trivial dependencies

Compute the closure sets of R, find all non-trivial dependencies and what are the candidate keys of R?

  Design the screen with the actual values

Design the screen with the actual values. Students have to also create a data dictionary to explain what type of data is expected to display with the given input.

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