Purchase Solution

Ray Henry Case Study: Database Design Specifications

Not what you're looking for?

Ask Custom Question

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.)

Purchase this Solution
Solution Summary

This response provides guidelines on creating a database for a newly opened businesses in order to keep its customers and members on file.

Solution Preview

What you need is to create database tables to store the details of each aspects of the ...

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.

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.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

View More Free Quizzes
Related BrainMass Solutions

  • Case Study: Dr. Martin Luther King

    596481 Case Study: Dr. Martin Luther King Research the murder of Dr. Martin Luther King. 1. In a narrative format, discuss the key facts and critical issues presented in the case. Minimum word count is 500 words. 2.

  • field specifications

    * Field specifications constitute the "data dictionary" of the database. Each field specification stores data on the characteristics of a particular field within the database.

  • A systems life cycle chart

    Design • The design and development team commence building the new system by modelling, determining data, hardware, network infrastructure, user interface, database design, and other relevant requirements.

  • Project Management Scope

    -Project stakeholders - The core stakeholders (as in the case study example) are users of the database (staff employees, management, product developers) and end users (consumers using the product that can directly be impacted either negatively or positively

  • Study Bias for Case-Control Study

    144205 Study Bias for Case-Control Study In a case-control study of the relationship of radiation exposure and thyroid cancer, 50 cases admitted for thyroid cancer and 100 "controls" admitted during the same period for treatment of hernias were studied

  • Huffman Trucking Virtual Organization

    Regards, Jasbir This solution helps design a database model for the Huffman Trucking Virtual Organization. It contains logical ERDs and metadata specifications based on a relational database model.

  • E-Commerce costs, proposals and breakdowns - The Sharper Image

    Design: This phase covers activities directed towards the architecture of the system and function flow diagrams including detailed specifications of the system. ? Database: Build and integrate database. ?

  • Qualitative Article Review: Critical Narrative Analysis

    Design & Problem Statement The design of their study is based on a reflexive application of critical narrative analysis.

  • Using case study on CBT and REBT therapy

    334798 CBT and REBT Theory Application Need assistance with either applying CBT or REBT to the case of Henry (see the case study narrative, The Case of Henry).

View More Related Solutions