Reference no: EM133150683

Use MS PowerPoint (recommended but not limited) to draw the ER model of the database.

• Identify all entities from the below description (30%)
• Include all attributes (at least three or more) of each entity (30%)
• Draw the relationship between each entity, including cardinality and constraints (30%)
• In each entity, indicate which attribute can be used as the primary key (10%).

Description:

Rowan TV plans to design their own database to store information about their TV series as well as the TV series from other TV Companies. Information includes the actors who play in the series, and directors who direct the episodes of the series. Actors and directors are employed by a given TV company. A TV series are divided into episodes. An actor is hired to participate in a series but may participate in many series. Each episode of a series is directed by one of the directors, but different episodes may be directed by different directors.