Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

CIS 5500:  Database and Information Systems

Exercise 3: ER Design

In this exercise you will create an ER diagram. For the homework, you should use a drawing tool such as draw.io, Powerpoint, Word, Visio, OpenOffice Draw, OmniGrae, Google Drive  Document or any other software that you are familiar with to embed in your submission.

However, since the exercise is not turned in, feel free to draw by hand!

Consider the following scenario.

●   There are television 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 a season number, episode number, title and length.

● An actor is identified by name and birth date, and also has a nationality.

●   A writer is also identified by name and birth date, and has a talent agency that represents him or her.

● An actor can appear as a “regular” on a television series or a guest star on an episode.

● An episode has one or more writers. A writer can write zero or more episodes.

1. Draw an ER diagram that represents this scenario using the notation introduced in lecture (rectangles, diamonds, ovals). Be sure to mark the key attributes and include cardinality constraints on relationships.

3. Modify your ER diagram to capture the following: an episode can be the finale for a series where a series can have at most one finale episode. A finale is the last episode ever for a TV  Series, i.e., the last episode of the last season.  Just draw the part of the diagram that changes, and describe the effect on the relational schema. State any constraint(s) that cannot be captured by keys, foreign keys, or domain constraints.