Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / You are contracted by BitStream to develop a management system for the TV streaming services the company provides

You are contracted by BitStream to develop a management system for the TV streaming services the company provides

Computer Science

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:

? Customers information and account details. This includes customer's

subscription full details and payment details. 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 can have Drama and

Adventure Genres. Movie information needed to 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

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

needed to 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 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 needed 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 Movies or TV series. Information about the director that needed 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: Nomination for awards should also be recorded for actors, directors, movies and

TV Series.

Task

Your task is to develop an entity-relationship diagram, relational model, and data

dictionary for the scenario. Specifically, you must follow these rules:

ER Diagram:

? Create an entity-relationship diagram using any drawing software of your choice.

? Your ERD must include all entities mentioned in the scenario. You are free to add

more if you wish.

? Each entity must have at least 3 attributes excluding keys and the ones explicitly

mentioned in the scenario.

? Note: remember to convert any many to many (M:N) relationships into

composite entities.

? Note: remember to add in your primary and composite keys for all entities in

your diagram.

Relational Model

? Convert your completed ERD to relational model using Excel or LibreOffice Calc.

? Make sure your relational model is in 3rd normal form. Note: you don't need all

the previous forms evident, just 3rd normal form.

? Include a minimum of 5 tuples of data in each table.

? Note: remember to add in all your foreign keys at this stage. Hint: The foreign key

is added to the table that sits on the Many to the One side. So many something

should relate (foreign key) to the one thing.

Data Dictionary

? Create a data dictionary for all your attributes using Microsoft Excel or

LibreOffice Calc.

? Your data dictionary must include the following:

o Field name, type, and source table (table the attribute is from)

o Description

o Minimum and maximum length

o Format

o Range

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE