Design an entity relationship diagram

Assignment Help Database Management System

Reference no: EM132823217

Design an Entity Relationship Diagram for the following scenario:

There are televisions series, which have names, networks and production companies. and are identified by the name and network.

A television series has one or more episodes, identified by episode number. Episodes also have a title and a length. No episode can exist without a corresponding television series.

There are also movies. A movie is identified by its name and the year it was released.

An actor has unique number, name. birth date, and nationality.
A writer is also identified by unique number, name and birth date.
An actor can appear as a "regular" on a television series, a guest star on an episode. and a performer in a movie.
Each episode has many writers, and each writer has many episodes.
A movie has a writer, and each writer write many movies

Reference no: EM132823217

Questions Cloud

What is the development plan : What is the development plan you need to hire a chef in a new restuarant?

Describe a us environmental law : An essay describing a U.S. environmental law and international. Describe a U.S. environmental law. Explain an international agreement regarding the environment.

Develop a graphic rating scale for the jobs : Develop a graphic rating scale for the following jobs: human resource manager, professor, janitor, teller and accountant.

Hr mini-case-hiring the best : In his book, Good to Great, management author Jim Collins discusses what makes a company become successful and sustains this level of success:

Design an entity relationship diagram : Design an Entity Relationship Diagram - television series has one or more episodes, identified by episode number. Episodes also have a title and a length

What elements contribute to the overall culture : How can the culture of an organization contribute to overall employee satisfaction? What elements contribute to the overall culture of an organization?

How were received by environmental : How were received by environmental and environmental-opposition interests, and top appointees as EPA administrator and Interior Secretary.

Describe the founding of the environmental justice movement : The environmental justice movement emerged in 1982 in North Carolina. In essay form, describe the founding of the environmental justice movement

What hope to gain in opposing the environmental movement : Comment on the role and prevailing ideology of "extractive industries" in supporting the the environmental opposition movement

User Account

All Pages