Task 2. Please Draw a relational model for the following ERD. In the ERD below, a rectangle with dotted-line borders represents a weak entity, an attribute with solid underline represents the primary key of an entity (please note, the primary key of an entity and the primary key of the table are not always the same. The primary of an entity is the primary key or a part of the primary key of the table, and the primary key of the table can a composite key that includes the primary key of the entity and some other keys.), and an attribute with a dotted underline represents a partial key.

You don't need to develop a graphical version of the relational model. Please just list the tables, attributes, primary keys and foreign keys. For example, a table can be represented as

Course (CourseCode, name, Dept_name(FK)) - in this example, Table name is Course. The attributes are enclosed in (). An attribute with an underline represents the primary key (Please note the primary key of a table can include multiple attributes), and you can use (FK) to represent the foreign. Please note a table can contain multiple foreign keys, and an attribute can be both a primary key and a foreign key.

Brief description of the ERD: A TV Series have multiple seasons. Each season has a SeasonCode (such as S1) and includes a number of episodes. Each Episode has an EpisodeNumber (such as E1). Each Episode can have multiple writers, and a writer can write multiple episodes. In one episode, an actor can play only one character, but in one episode, one character can be played by more than one actors (not common but possible). An actor and a character can appear in different episodes. A TV series can have multiple characters, and a character can appear in multiple TV series.

Hint: You probably want to finish the task in the following steps:

1.Develop tables for the strong entities (TVSeries, Actor, and Character)

2.Deal with the weak entity Season. This weak entity relies on the strong entity TVSeries. Identify the primary key of the weak entity. After specifying the primary key of Season, you can now consider it a strong entity.

3.Deal with the week entity Episode. This week entity replies on Season. Identify the primary key of Episode, and then you can consider it a strong entity.

4.Deal with the m:m binary relationship between Writer and Episode.

5.Deal with the ternary relationship among Episode, Actor and Character.

6.Deal with the m:m binary relationship between TVSeries and Actor.

\f