User Account

All Pages

Start a dvd rental program at his stores

Assignment Help Database Management System
Reference no: EM13949716

1. Ray wants to start a DVD rental program at his stores that he plans to call Henry's DVD Club. He refers to each of his customers as "members." Each member in the club is assigned a number. He also stores the members' names and addresses. In addition, he stores the number of rentals the member has made and the date the member joined the club. He periodically has promotions during which members can earn bonus units that they can later apply to the cost of renting DVDs. He needs to store the number of bonus units the member has earned.

2. Modify in Exercise 1 so that it will also support the following situation. Ray wants to store information about the DVDs the club owns. When the club purchases a DVD, Ray assigns it a number. Along with the number, he stores the number of the movie on the DVD, the date the DVD was purchased, the number of times it has been rented, and the number of the member who is currently renting it. (If the DVD is not currently being rented, the member number will be null.) Ray also needs to store the number of the branch to which the DVD is assigned. Finally, Ray would like to store the history of the rental of each particular DVD. In particular, he needs to store the DVD number, the date of the rental, the date it was returned, and the number of the member who rented the DVD. Assume that a DVD could potentially be rented more than once on the same day. (Hint: Review the discussion of the categories of primary keys to determine what type of primary key would be appropriate for this relation.)

Reference no: EM13949716

Questions Cloud

Advise beryl of the advantages of each of her alternatives : Paladin Company manufactures plain paper fax machines in a small factory in Minnesota. Advise Beryl of the advantages and disadvantages of each of her alternatives.
Assume that angie can sell cracked cookies : Assume that Angie can sell cracked cookies for $1.10 each. What should Angie price each cookie?
Contracted as a budget consultant by lbj company : You have just been contracted as a budget consultant by LBJ Company, a distributor of bracelets to various retail outlets across the country. The company has done very little in the way of budgeting and at certain times of the year has experienced..
Determine the specified property at the indicated state : 1. Determine the volume change, in ft3, when 1 lb of water, initially saturated liquid, is heated to saturated vapor while pressure remains constant at 1.0, 14.7, 100, and 500, each in lbf/in.2 Comment. 2. For H2O, determine the specified property..
Start a dvd rental program at his stores : Ray wants to start a DVD rental program at his stores that he plans to call Henry's DVD Club. He refers to each of his customers as "members."
What is the reliability of the computer : What is the reliability of the computer? A backup computer identical to the one being used will be installed to improve overall reliability. Assuming the new computer automatically functions if the main one fails, determine the resulting reliabili..
How can we say that price equals to the present value : How can we say that price equals to the present value of all future cash flows when many actual investors may be seeking capital gains and planning to hold their shares for only a year or two? Explain.
Write a routine miscellaneous memo requesting action : Directions: Write a work memo as described: Think of an idea you would like to see implemented in your job (e.g., a way to increase productivity, improve service, increase business, or improve working conditions.) Write a routine miscellaneous memo r..
How many francs does lee expect to receive on october first : If the price of the shutters is set using the spot rate as of July 1, how many francs does Lee expect to receive on October 1? How many yen does he expect on October 1?

Reviews

Write a Review

Database Management System Questions & Answers

  Describe sql superkeys

Discussion of database with the goal of creating Web database applications. There is something of a disconnect between modeling data in an object-oriented language, such as Java, and a traditional database

  Create an idefix or er diagram for the database

Import your IDEF1X diagram into Oracle and create the appropriate tables and relationships. Your design should include a specification of tables, attributes, primary and foreign keys, referential integrity constraints, and referential integrity ac..

  Explain how to create query in access query wizard

Describe how to create a query in Access Query Wizard equilvant to the query: SELECT first, last, department, hours FROM payroll WHERE hours>.

  List whether the index matches the given selection condition

Athabasca University has about 32,000 students between the ages of 17 to 60. Consider the AU student relation with the following schema.

  Design database for keeping information of actors

Design a database for Ray. For each director, list his or her number and name and the year he or she was born. If the director is deceased, list the year of death.

  Explain relation schema and set of functional dependencies

Consider relation schema r(A,B,C,D,E, F) and a set of functional dependencies {A BCD,BCDE,BD,DA}. Calculate canonical cover for set of functional dependencies (show each step of your derivation with an explanation).

  Data collection procedures and data analysis techniques

Specify the approach (qualitative or quantitative), research design, sampling strategy, data collection procedures, and data analysis techniques to be used.

  Demonstrate why a database was required in the first place

A narrative description of the field chosen for the application being created. This should also include a description of the problem and addressing the weaknesses to be solved by the database.

  Query evaluation and query optimization

Explain what you understand by the terms Query Evaluation and Query optimization - Discuss the ways or strategies you can apply to improve the query performance

  Explain what is the nosql movement

Using the Internet or other sources to find two dominate Cloud DBMS vendors and their latest products. Give the URLs for these DBMSs. Explain what is the NoSQL movement. Find one "DBMS" that is NoSQL. Explain what is Vertia. What are the features of..

  Find all governors general of australia

Find all Governors General of Australia who were Barons at the time and Restrict your query to Governors General who were Barons at the time of their appointment

  Create database that contains the inventory of organization

Create a database that contains the inventory of your organization's technology, as well a table including employee information. Build your database named IT_inventory, linking users to workstations, i.e., each computer (desktop or notebook) will b..

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