User Account

All Pages

Ray henry is considering expanding the inventory at his

Assignment Help Database Management System
Reference no: EM13366247

Ray Henry is considering expanding the inventory at his book stores to include movies. He has some special ideas for how he wants to implement this change, and he needs you to help with database design activities. In each excercise, represent your answer in DBDL and with a diagram. You may use any of the styles presented in this chapter for the diagram.

1. Design a database for Ray. He is interested in movies and wants to keep information on movies, actors, and directors in a database. The only user is Ray, and he needs to produce the following reports:

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

b. For each movie, list its number, its title, the year the movie was made, and its type (for example, Comedy, Drama, or Science Fiction).

c. For each movie, list its number, its title, the number and name of its director, the critics' rating, the MPAA rating (G, PG, PG-13, or R), the number of awards for which the movie was nominated, and the number of awards the movie won. (The critics rate the movie with a number of "stars." Four stars is the top rating possible. Zero stars is the worst possible rating.)

d. For each lead actor starring in each movie, list his or her number, name and birthplace and the year he or she was born. If the actor is deceased, list the year of death.

e. For each movie, list its number and title, along with the number and name of the actors who appeared in it.

f. For each lead actor starring in each movie, list his or her number and name, along with the number and name of the other movies in which the actor starred.

Reference no: EM13366247

Questions Cloud

Managing political riskcan political risk be managed if so : managing political riskcan political risk be managed? if so what methods can be used to manage such risk and how
International human rights issuesexplain what do you think : international human rights issuesexplain what do you think should be the role of mncs toward human rights issues in
Brief textual discussion of pertshow in detail the program : brief textual discussion of pertshow in detail the program evaluation and review technique pert including an
Description of global managementthe attached article shows : description of global managementthe attached article shows how global corporations have to think differently in how
Ray henry is considering expanding the inventory at his : ray henry is considering expanding the inventory at his book stores to include movies. he has some special ideas for
Global management sample questionliving here in america we : global management sample questionliving here in america we hear a lot about the multinational activity of many american
Question about international managementgive an example of : question about international managementgive an example of how a company pick any company has chosen to compete
How do you analyze special considerations in global pay : how do you analyze special considerations in global pay systems?can you please describe how the following compensation
Global venture in australia bausch amp lomb sun glasses1 : global venture in australia bausch amp lomb sun glasses1. examine operational feedback and commandcontrol mechanisms

Reviews

Write a Review

Database Management System Questions & Answers

  Develop a complete system

The assignment will be chosen by the individual student with my approval. An ideal assignment will be one which involves at least four entity sets, but not too many since there will be critical time pressure to complete the assignment.

  Write an application that creates a database named phonebook

Write an application that creates a database named PhoneBook. The database should have a table named Entries, with columns for a person's name and phone number. Next, write an application that lets the user add rows to the Entries table,

  Write names-e-mail addresses for customers by foreign key

Illustrate all data in each of the four tables. Don't show foreign key columns. Write down the names and e-mail addresses for all customers who have had stove repair which cost more than $50.

  Various kinds of keys to form or define relationships

Relational database is based on fact that data in one table can be tied, or related to data in another table. To do this, database utilizes various types of keys to form or define these relationships.

  Explain fragmentation and replication

Define association rules, and explain how to induct association rules by using frequent itemsets, a Priori Property, and support and confidence measures.

  Create three use case diagrams for the new billing

Using the Hillside School Case Study and your stage 1, 2, and 3 projects, develop a decision paper that serves as a system "sign-over" document for system deployment and transfer of responsibility for the newly designed and implemented system to t..

  Create a state machine diagram

In addition, you will also need to create a state machine diagram for the RegistrationRecord class (the class that maintains the registration of a student in a class).

  Write three items contained in fat database

What does CHS stand for? List three items contained in the FAT database. List two features NTFS provides that FAT does not.

  What is the key value of the 4th index

What is the key value of the 4th index record on the top level, assuming each index record points to the record with the highest key value in a block of the next level down?

  Create query that spans both tables

Create a query that spans both tables. Eliminate redundant fields. Modify the Query to select only those Customers that had service dates in October and November 2006.

  Create the relational model

Create the relational model corresponding to the described application. Basically, list the CREATE TABLE statements with the attribute names, and appropriate data types.

  Role of metadata in data acquisition process

You are a vice president of marketing for a nation-wide appliance manufacturer with three production plants. Explain different ways you would tend to analyze your sales. What are the business dimensions for your analysis?

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