State primary key for each table and all other attributes

Assignment Help Database Management System

Reference no: EM131207657

Design a relational database for a video rental store. The store, which rents only DVDs and has no sales other than DVD rentals, has approximately 5,000 customers and approximately 1,200 DVD titles. There are 25 suppliers of DVDs. Business rules include:

(1) each DVD title may have many copies;

(2) customers use their telephone numbers to uniquely identify themselves for video rentals;

(3) a telephone number may apply to anyone in the household;

(4) customers may rent more than one copy of any title, but, obviously, a copy of a title can only be rented by one customer at a time; and

(5) suppliers may provide many titles and a DVD may be acquired from several different suppliers.

•Design the necessary database tables.

•State the primary key for each table as well as all other necessary attributes.

•Make certain the tables are in third normal form.

• Mark the attribute you have selected as the primary key (PK) as well as the attributes that serve as foreign keys (FK).

Reference no: EM131207657

Questions Cloud

Design a discrete common emitter bjt amplifier : Design a discrete common emitter BJT amplifier to have overall gain of -8 V/V. (Determine value for R1, R2, RC and RE)

Explain the present realities of women leadership roles : Given your personality, hypothesize three (3) ways that you would handle the situation depicted in the case study if you were Mark. Provide support for your methodologies.

Explain principles of digital analysis : Explain Principles of digital analysis discussion. When creating forensic images, verifying an image's integrity (i.e., whether or not it is an exact bit-for-bit copy of the original evidence) is very important.

What issues addressed from counseling perspective for lisa : Determine what issues were addressed from a counseling perspective for Lisa. Describe the plan you will implement to begin working more effectively with Lisa's three children while in foster care.

State primary key for each table and all other attributes : Design the necessary database tables. - State the primary key for each table as well as all other necessary attributes.

How they each influenced you to become a global citizen : After reading the article by Reysen and Katzarska-Miller, explain why there has been disagreement between theorists about the definition of global citizenship and develop your own definition of global citizenship.

Estimate the cost formula for each cost incurred by baylor : Baylor Balloon Bouquets incurred the following monthly costs.- Using the formy = mx + b, estimate the cost formula for each cost incurred by Baylor Balloon Bouquets.

Write a python function to check whether a number is perfect : Write a Python function to check whether a number is perfect or not. According to Wikipedia : In number theory, a perfect number is a positive integer that is equal to the sum of its proper positive divisors.

Apply principles of critical thinking to contemporary issues : Identify three out of five skills or competencies you have acquired through participation in general education courses that will help you strive to meet your academic and career goals.

User Account

All Pages