User Account

All Pages

Create database to keep information of movies

Assignment Help Database Management System
Reference no: EM1356374

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: EM1356374

Questions Cloud

Journal entries of woodside company : Write journal entries for the following transactions that occurred at Woodside Company during the month of May and explain how each would be disclosed in Woodside's financial statements.
What is the astronauts tangential acceleration : How various g's of acceleration does the astronaut experience when the device is rotating at top speed? Each 9.80 m/s^2 of acceleration is 1 g.
What is the magnitude of n at the lowest point : How does the magnitude of electrical force between a pair of charged objects change while the objects are moved twice as far apart? Three times as far apart.
Description of global management : Expalin what specific steps can a CEO, take to create the kind of culture and organization within their company that fosters this type of out of the box globalized strategic thinking?
Create database to keep information of movies : Create 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 reports.
Journalize the transactions : Garza Corporation had the following transactions during the current period. Garza issued 5,000 shares of $1 par value common stock to attorneys in payment of a bill for $30,000 for services provided in helping the company to incorporate.
Global management - sample question : Are we intrinsically isolationist because of our culture, our geography, our overwhelming economic power?
What is the expected number of transmission attempts needed : A large population of aloha users manage to create 50 request/sec,including both originals and retransmissions.time is slotted in units 40msec.
Question about international management : Show at least one management problem that arose and how it was solved.

Reviews

Write a Review

Database Management System Questions & Answers

  Create the following documents for the proposed system

MGMT321 Group Project: Create the following documents for the proposed system and deliver each SDLC documents by the end of each designated module, as shown below

  Evaluate maximum rate at which data can be read from disk

What is the maximum rate at which data can be read from disk, assuming that we can only read data from one surface at a time? What is the average rotational latency?

  Sales transaction in retail clothing

Examine different sales transactions. Design a context diagram and a level-0 diagram that represent the selling system at the store.

  Ensure the security of organizations distributed database

How can you make your database more hacker proof? How do you ensure the security of an organizations distributed database?

  Create a database from scratch

Create a database from scratch that contains, at a minimum, the elements listed below

  Choose a data storage problem of storing data in database

You should choose a data storage problem of your interest and identify the different pieces of data that should be stored in database.

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Determining the matrix form of game

Assume a game with two players, A and B, who raise one or both hands concurrently. A wins if total number of hands raised is odd, and B wins in other way.Write down the matrix form of the game. Is there a pure strategy solution? Explain your answer..

  Explain primary problem in credit card records

You have a file which contains credit card records. Each record contains field for the card number, expiration date, and name of card holder. Explain what primary problem you try to solve is.

  Information-gathering techniques for the project

Explain the information-gathering techniques and design methods you would suggest to use for project. Recognize the key factors that help ensure the information required for the project.

  Explain the datawarehouse and data mining concepts

There are six major types of information systems which organisations use in their operations. Discuss how these information systems support managers in their decision making role Explain the datawarehouse and data mining concepts using appropria..

  Study and modify the postgresql source code

Write a Assignment to study and modify the PostgreSQL source code, with a focus on one of the core modules - the buffer manager

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