need an erd diagram and relational mode (just 3nf) and data dictionary for the following: You are

need an erd diagram and relational mode (just 3nf) and data dictionary for the following:

Transcribed Image Text:

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. 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. 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.