Question: This assignment require you to apply the Data Modeling concept and skill learned from Chapter 6 to build an ERD based on the previous AVS

This assignment require you to apply the Data Modeling concept and skill learned from Chapter 6 to build an ERD based on the previous AVS case (A Video Store) from your Assignment 2 & 3.

Turn in an ERD with appropriate relationship sentences. You can use drawing tools in MS Word or MS Visio to create your ERD. Make sure your relationship sentences are consistent with your relationship in your ERD.

Customer infomation Video damage fee Damaged video Information Manager 1Video Supplier Video descriptive Information Maintai Register Validate user Validation Successful Registration Issue video oo :) Rent Check Overdue Customer Manager Display overd

Video damage fee Customer infomation Damaged video Information Manager * AVS Customer card Overdue damasd video fee Overdue damaged Video fee paymant Maintain Video Supplier Video descriptive Information video inventory Maintain sustomer data New video Video removed information from stock Fee Overdue video fe Video D1 Customer -record payment Video information Overdue videos D2 Customers Rentals Customer data Rented 3. Overdue video xideo Maintain Overdue fee assessmant Returned video video rental data Overdue videonotice AVS Card Customer Video to retum Video to rent

Step by Step Solution

★★★★★

3.49 Rating (149 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

soltuion step 1creating ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Create an ERD based on the Crows Foot model, using the following requirements: An INVOICE is written by a SALESREP. Each sales representative can write many invoices, but each invoice is written by a...

Based on what you learned from the Umpqua Bank video case, Umpqua has created a competitive advantage by doing all of the following except for: Creating an environment in which people like to hang...

Read the case study, A Story of Failure: Golden Gate Airlines and answer the following questions: What type of planning strategy do you believe Justin Collins could have implemented that might have...

Consider the engine thrust data in Exercise 12-64.Refit the model using as the response variable and x*3 = ln x3 as the regressor (along with x4 and x5). (a) Test for significance of regression using...

Metamorphism occurs at depth. Since geologists cannot see this going on, can they apply the axiom of the present is the key to the past?

The figure shows a steel countershaft that supports two pulleys. Pulley C receives power from a motor producing the belt tensions shown. Pulley A transmits this power to another machine through the...

Two hydraulic piston/cylinders are connected through a hydraulic line so they have roughly the same pressure. If they have diameters of D1 and D2 = 2D1 respectively, what can you say about the piston...

One of the main uses of the linear -olefins prepared by oligomerization of ethylene is in the preparation of linear low-density polyethylene. Linear low-density polyethylene is a copolymer produced...

Determine the escape speed for a rocket on the far side of Ganymede, the largest of Jupiters moons (Figure P13.41). The radius of Ganymede is 2.64 X 106 m, and its mass is 1.495 X 1023 kg. The mass...

Consider two identical fans, one at sea level and the other on top of a high mountain, running at identical speeds. How would you compare (a) the volume flow rates and (b) the mass flow rates of...

Suppose a customer rents a vehicle for three months from Commodores Rental on November 1, paying $6,000 ($2,000/month). (1) Record the rental for Commodores on November 1. (2) Record the adjusting...

In your learning journal, reflect on your skills and interests. Write a paragraph explaining what you could offer this organization as a volunteer. (Write in accordance with the above organization)

Evaluate 7 x + 1 0 ( 3 x + 4 ) ( x + 1 ) d x

Fries, a farmer, received a notice from the manufacturer of a farm harvester that a cable on the machine was defective and likely to snap. Fries ignored the warning, and two weeks later the cable...

You are the manager of a software development group within a large corporation. Your group would be more productive if the PCs were upgraded, but you do not have any money left in your annual...

Read FAQ 1.4.1 about two-sided alternative hypotheses and answer the following questions. a. Why dont we first take a sample and use the observed sample proportion to help us decide which direction...

Define: Multinational market regions Free-trade area European Parliament Customs union Single European Act Common market Political union Maastricht treaty Treaty of Amsterdam

The NMR and IR spectra for four unknown compounds A through D are presented below and on the next two pages. Possible empirical formulas for them (not in any particular order) are C 6 H 5 Br, C 6 H 6...

A shaft carries five masses A, B, C, D and E which revolve at the same radius in planes which are equidistant from one another. The magnitude of the masses in planes A, C and D are 50 kg, 40 kg and...

Write the SQL code to create the table structures for the entities shown in Figure P7.65. The structures should contain the attributes specified in the ERD. Use data types that would be appropriate...

What is the minimal data rule in conceptual design? Why is it important?

What is business intelligence? Give some recent examples of BI usage, using the Internet for assistance. What BI benefits have companies found?

At Hersheys, the chocolate maker, a particular candy bar is supposed to weigh 11 ounces. However, the company has received complaints that the bars are under weight. To assess this situation, the...

Fifty sampling units of equal size were inspected, and the number of nonconforming situations was recorded. The total number of instances was 449. a. Determine the appropriate control chart to use...

On Saturday morning, Jennifer Bentford received a call at her home from the production supervisor at Bentford Electronics Plant 1. The supervisor indicated that she and the supervisors from Plants 2,...