Purchase Solution

Database Proper Sequences

Not what you're looking for?

Ask Custom Question

Write the proper sequence of activities in the design of a rental video database. (The initial ERD was shown in the figure). The design must support all rental activities, customer payment tracking, and employee work schedules, as well as track which employees checked out the video to the customers. After you finish writing the design activity sequence, complete the ERD to ensure that the database can be successfully implemented. (Make sure that the design is normalized properly and that it can support the required transactions)

Figure 9.7

A composite entity
Customer

PK CUST NUM

CUST_NAME
CUST_FNAME
CUST_INITIAL
CUST_E_MAIL

Customer
PK CUST NUM

CUST_NAME
CUST_FNAME
CUST_INITIAL
CUST_E_MAIL

Customer
PK CUST NUM

CUST_NAME
CUST_FNAME
CUST_INITIAL
CUST_E_MAIL

REQUEST IS WRITTEN IN

Purchase this Solution

Solution Summary

The expert examines database for proper sequences.

Purchase this Solution


Free BrainMass Quizzes
Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Basic Networking Questions

This quiz consists of some basic networking questions.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.