Question: a. Write the proper sequence of activities in the design of a video rental database. The initial ERD is shown in above (or refer to

a. Write the proper sequence of activities in the design of a video rental database. The initial ERD is shown in above (or refer to textbook figure 9.9). The design must support all rental activities, customer payment tracking, and employee work schedules, as well as track which employees checked out the videos to the customers.

b. After you finish writing the design activity sequence, complete the ERD to ensure that the database design can be successfully implemented. Make sure that the design is normalized properly and that it can support the required transactions.

c. Implement solution using Microsoft Access. Be sure to populate the database with proper data to insure its data integrity.

RENTAL CUSTOMER VIDEO PK FK VIDEO_ID CUST NUM PK PK VIDEO_ID PK

RENTAL CUSTOMER VIDEO PK FK VIDEO_ID CUST NUM PK PK VIDEO_ID PK FK CUST NUM CUST LNAME CUST FNAME CUST INITIAL CUST E MAIL VIDEO CLASS VIDEO TITLE RENTAL OUT VIDEO_CHG RENTAL RETURN Figure 9.9 as described

Step by Step Solution

★★★★★

3.54 Rating (158 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Step 1 Given Write the proper sequence of activities for the design of a video rental database The initial ERD was shown in Figure 99 The design must ... 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 Databases Questions!

The following figure shows a Microsoft Access query design screen for a employee query. Use information provided on this figure to answer the following questions: 1. How many tables are used in this...

You will take on the role of a project manager assigned to guide a product to market effectively. Your output is a complete project plan that includes, but is not limited to, a WBS, network diagrams,...

What factors suggest that Microsoft's PSS Division needs a more comprehensive and flexible approach for its service offerings? Admittedly, Microsoft's support services were not as good as those...

Write the proper sequence of activities in the design of a video rental database. (The initial ERD was shown in Figure 9.9.) The design must support all rental activities, customer payment tracking,...

The following are examples of audit procedures: 1. Review the accounts receivable with the credit manager to evaluate their collectibility. 2. Compare a duplicate sales invoice with the sales journal...

Toyota has grown to become the largest auto manufacturer in the world, with plants located around the world. In 20052007 the company hired 40,000 new employees to keep up with this growth. A...

Write the SQL code to change the EMP_PCT value to 3.85 for the person whose employee number (EMP_NUM) is 103. Next, write the SQL command sequences to change the EMP_PCT values as shown in...

Write a query to display the employee number, last name, first name, and sum of invoice totals for all employees who completed an invoice. Sort the output by employee last name and then by firstname....

Write a query to display the employee number, last name, first name, salary from date, salary end date, and salary amount for employees 83731, 83745, and 84039. Sort the output by employee number and...

Question Which of the statements below best describes the following ER Diagram: Question options: A professor may teach one or more classes but a student must take one or more classes. A class must...

Saleri Manufacturing Corporation produces a product in three departments. The product is cut out of sheet metal in the Cutting Department, then transferred to the Forming Department, where it is bent...

In a game of billiards, ball A is given an initial velocity v0 along the longitudinal axis of the table. It hits ball B and then ball C, which are both at rest. Balls A and C are observed to hit the...

Item 6 9 . 0 9 points eBookHint Print References Check my workCheck My Work button is now enabled Item 6 Problem 7 . 7 You purchased a call option on euros with a strike price of $ 1 . 1 0 per euro....

Repeat Exercise 5 for the baseline and prequiz anxiety scores. (If your software does not have the sign test, repeat Exercise 4 for the anxiety variable.) Data from exercise 5 If your software has...

a. After a dose, the concentration of medication in the blood declines due to metabolic processes. The half-life of a medication is the time required after an initial dosage for the concentration to...

A study in Switzerland examined the number of cesarean sections (surgical deliveries of babies) performed in a year by samples of male and female doctors. Here are summary statistics for the two...

A lens has focal length f = 35 cm. Find the type and height of the image produced when a 2.2-cm-high object is placed at distances (a) f + 10 cm (b) f - 10 cm.

In right triangle ABC above, AB = 15 and AC = 30. What is the value of a - c? O30 O 15 00 0-30

Scenario 4: A new CEO took over the reins of the non-profit t2 years ago. Things were a mess: They were near bankruptcy, employees had little guidance, and the once stellar reputation of the agency...

List two reasons of using contraceptive methods by married couples. (b) Write in proper sequence the processes going on in the different organs of the reproductive system of a human female starting...

On January 1, Year 1, Par Ltd. purchased 75% of the outstanding common shares of Son Ltd. for $120,000 in cash. On the date of the purchase, Son had common shares of $38,000 and retained earnings of...

Note: Instructions for Section B and C. Read the case study carefully. All questions are compulsory. Answer each of the question in specific points. Try to avoid writing in paragraphs. Write specific...

Note: Instructions for Section B and C. Read the case study carefully. All questions are compulsory. Answer cach of the question in specific points. Try to avoid writing in paragraphs. Write specific...

develop a memorandum addressed to the CFO that explains how you want to change your IT Department into a CIO organization and why. Your memo will address each of the topics listed below, and should...