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)