draw the schemas using the Crows Foot notation. Resolve any M:N relationships. E/R Diagramming

The following gives the requirements for the IMDB. These requirements should be used to design an entity-relationship diagram. Your design should include the following:

IMDB records the information about each studio, such as studio name, year established, year closed (if applicable), country, etc.

The system records overall movie information, such as movie title, tagline, genre, year made, country, website, running time, language, color, rating, showing start date, ranking, etc.

Tagline is a one-sentence description of a movie.

Values of color could be True or False for color movie or black/white movie respectively.

Rating could be G, PG, M, MA, etc.

Studios produce movies.

The genre describes the type of a movie, such as comedy, drama, biography, action, thriller, horror, romance, war, animation, adventure, etc. One movie may have more than one genre.

You may record the people involved with the movies with their titles, family names, given names, genders, websites, emails, dates of birth, cities of birth, countries of birth, and other necessary information.

A casts is actor or actress in a movie.

Crews are staff other than casts involved with a movie, such as Director.

You should record each roles name for casts. For example, Actor of leading role, Actor of supporting role, etc.

You should record each job title for crews. For example, Director, Producer, Writer, etc.

You may assume a person only performs one role in a movie.

IMDB records the name of each part in a movie, also records the job title for each crew in a movie.

There are many movie awards around the world from different organization. The organization is recorded with name and country.

Each award ceremony can only be held by one organization each year.

You should record the award and nominations with title, category, etc.

o Award titles could be classified as to two categories: for person (such as Best Actor of leading role, Best Director) or for movie Best movie, etc. o There will be many nominations for an award in a given year, but only one winner for the award in that year. o An award may been won many times, or may have never been awarded (or nominated)

Movies released will be shown in cinemas. You should record cinema name, phone number, website, number of screen, street, city, state, country, etc.

A city may have more than one cinema, and there is always one cinema that is the supervisor cinema of the city.

Note: Rating of IMDB in the USA (MPAA) includes

G - For all audiences

PG - Parental Guidance Suggested (mainly for under 10's)

PG-13 - Parental Guidance Suggested for children under 13

R - Under 17 not admitted without parent or guardian

NC-17 - Under 17 not admitted

Approved - Pre-1968 titles only (from the MPAA site) Under the Hays Code, films were simply approved or disapproved based on whether they were deemed 'moral' or 'immoral'.")