I was wondering if someone could tell me what my tables and fields will be in this project? More specifically I need to know the schema so I can properly go about this project.
I have an idea but im not entirely sure.
Below is the project:
In this project, you are supposed to design and implement a movie database.
1. Main background
a. This database is used to manage information about movies
produced since 1960.
b. Movie fans can check reviews written by registered reviewers.
A reviewer is free to write review for any movie, but can only
write one review at most for a movie.
c. A movie must have one director and variable number of
actors/actresses.
d. Each actor/actress asks for the same money for any movie they
played.
2. Requirements on the database
The database should be able to support:
a. Generating reports about the total income of a specific actor
(say Tom Hanks) in a specific year (say 1998).
b. Finding out the average review score for each movie.
c. Generating reports on total box revenue and profits of movies
made by a specific producer in each year.
d. Can track contact information for producer, director , actor, and
actress, and reviewer. Detailed contact information includes
phone numbe, fax number, and Emaill .
Note that the above requirements are used to assist you identify
tables and fields in the tables. You are not supposed to implement
the queries and reports in this project.
This post was edited by CamelFinger on Oct 14 2013 05:35pm