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

  Method to change column name

Hhow can you change column name or what is a different way to write statement in SQL so it displays the amount column as money.

  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.

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

  Convert table to equivalent collection of tables

determine the functional dependencies that exist in the following table. After determining the functional dependencies, convert this table to an equivalent collection of tables.

  Explaining valid host addresses of wan links

Start with LAN on RTA and proceed clockwise. Determine the number that how many total valid host addresses will be wasted on WAN links?

  Describe information using table

Describe the information seen, using the terms such as table, schema and key. Describe the EMPLOYEE and EMP_PHOTO tables in detail.

  Converting user form into 1nf and 2nf

Complete database exercise by converting user form located the evaluation procedures section of the syllabus into 1NF and 2NF.

  Create an e-r diagram

You have probably seen that already when you tried to create an E-R diagram. Visio uses notation and graphical shapes that are not the same as those in your text. If you look at some of the links to schemas, you will see a similar sort of thing.

  Database triggers are utilized to record logins by users

Several times, database triggers are utilized to record logins by users. Here is the example of login trigger that inserts row into table every time a user connects.

  Evaluate the success wellco and pharmacare shareholders

Evaluate the success WellCo and PharmaCARE shareholders

  Creating erd containing order and customer entity

Create ERD containing Order and Customer entity types connected by 1-M relationship from Customer to Order. Select suiatble relationship name using your common knowledge of intersection.

  Create link list in adt to maintain employee information

Create a link list in ADT c to maintain employee information like name,empid,basic salary and address.1.add employee info to the list if the empid is valid.

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