You are contracted by BitStream to develop a management system for the TV streaming services the
company provides. Your first task is to design a database structure for this System. Specifically, the
database would need to be able to record the following things:
● Customer information and account details: this includes the customer's subscription details and
payment details. The customer’s address needs to be recorded as well. (Hint: you need more
than 2 tables)
● Movies: information about every movie available for streaming must be recorded. A Movie has
many actors and may have more than one director. A movie may have more than one genre, for
example, it may be categorised as both Drama and Adventure genres. Movie information that
must be displayed in the system includes: Title, Description, Release year, Language, Genre,
Classification, Main Actors, Director, and Reviews (hint: Reviews should be a separate entity).
Record the Source information if the movie is based on a real story or a book.
● TV Series: information about every series available for streaming must be recorded. A Series has
many episodes and may have more than one season. A TV series has many actors and may have
more than one director; information that must be displayed in the system includes: Title,
Description, Release year, Language, Genre, Classification, Main Actors, Director, No. of seasons
and Reviews (hint: Reviews should be a separate entity). Record the Source information if the
movie is based on a real story or a book.
● TV Series Season: information about the series seasons; this table should be related to TV series
and episodes tables.
● Episode: Details about each episode for each season.
● Actors: information about the actors, each actor may have acted in Movies or TV series or both.
Information about the actor that needs to be displayed in the system includes First name, Last
name, Gender, DOB, AKA name (if any) description, Awards.
● Director: information about the Director, each director may have directed more than one Movie
or TV series. Information about the director that needs to be displayed in the system includes
First name, Last name, Gender, DOB, AKA name (if any) description, Awards.
● Awards: Information about Awards categories.
Note: Nominations for awards should also be recorded for actors, directors, movies and TV Series.