Ray henry is considering expanding the activities

Assignment Help Basic Computer Science

Reference no: EM13667033

1. Ray Henry is considering expanding the activities at his book stores to include movies. He has some ideas for how he wants to do this and he needs you to help with database design activities to address these ideas. In particular, he would like you to design a database for him. He is interested in movies and wants to store information about movies, stars, and directors in a database. He needs to be able to satisfy the following requirements:

a. For each director, list his or her number, name, the year he or she was born, and the year of death if he or she is deceased.
b. For each movie, list its number, title, the year the movie was made, and its type.
c. For each movie, list its number, title, the number and name of its director, the critics' rating, the MPAA rating, the number of awards for which the movie was nominated, and the number of awards the movie won.
d. For each movie star, list his or her number, name, birthplace, the year he or she was born, and the year of death if he or she is deceased.
e. For each movie, list its number and title, along with the number and name of all the stars who appear in it.
f. For each movie star, list his or her number and name, along with the number and name of all the movies in which he or she stars.
List the tables, columns, and relationships. In addition, represent your design with an E-R diagram.
2. Determine the functional dependencies that exist in the following table, and then convert this table to an equivalent collection of tables that are in third normal form.
                BOOK (BOOK_CODE, TITLE, TYPE, PRICE (AUTHOR_NUM,
                                  AUTHOR_LAST, AUTHOR_FIRST))

3. Determine the functional dependencies that exist in the following table, and then convert this table to an equivalent collection of tables that are in third normal form.
                BOOK (BOOK_CODE, TITLE, TYPE, PRICE, PUB_CODE,
                                  PUBLISHER_NAME, CITY)

Reference no: EM13667033

Questions Cloud

Find its maximum height and the time taken in getting there : A ball is thrown vertically up with a speed of 30 m/s. Find its maximum height and the time taken in getting there

A store gives a discount for senior citizens : A store gives a discount for senior citizens

Discuss measures that can be to proactively reduce risk : Discuss measures that can be taken to proactively reduce risk.

Describe the available materials and services : Describe the available materials and services

Ray henry is considering expanding the activities : 1. Ray Henry is considering expanding the activities at his book stores to include movies. He has some ideas for how he wants to do this and he needs you to help with database design activities to address these ideas. In particular, he would l..

Currency exchange rates : Currency Exchange Rates

Compute the demand for the product : Compute the demand for the product.

Describe five characteristics of effective business messages : Describe five characteristics of effective business messages.

Company organizational structure : Write a 1-2 page paper analyzing your company's Organizational Structure. How have they achieved coordination? Centralized vs. Decentralized? What changes would you make to the organizational structure and why?

User Account

All Pages