Question

The following describes the Universe of Discourse for the assignment: With the current popularity of video streaming services like ‘Netflix’ and ‘Amazon Prime’, you have been tasked with creating a database for a new up-and-coming streaming service called ‘Home Cinema’. Each product on the site is classified as either a movie or TV show. For each product, the site stores it’s title, a unique code, a brief synopsis and a collection of tags related to it (Action, Adventure, Romance, etc.). Additionally, the audio language options and subtitle language options are recorded. For movies, the runtime and date of release is stored. If the movie has a sequel then that information is also visible in the system. In the case of a TV show, each episode of the show can be identified via a season number and episode number in conjunction with the code of the show. Each episode also records the runtime and date of release. Cast members of products are also recorded on the site, which stores their unique ID, name and nationality. One actor has only one name and one nationality. If a cast member acts in a product then the name of their role is recorded. It is possible for a cast member to have multiple roles on the same product. Accounts on ‘Home Cinema’ are required in order to use the service. When a user registers for an account, the system stores their name, username, email, birthdate and registration date, along with their subscription tier (either ‘Free’ or ‘Premium’). The username or email identifies the account. When an account (of either tier) watches a movie or TV show episode the information is stored in the system. If they stop 2 watching partway through a movie or episode, the timestamp of where they stopped at is stored. ‘Premium’ accounts have some additional functionality ‘Standard’ accounts do not have access to. Such accounts may become friends with other ‘Premium’ accounts. They may also create multiple playlists containing any product on ‘Home Cinema’. The name of each playlist must be unique within that account. Based on the above UoD, you are required to undertake the following design tasks and then document them in the provided template. Create an ER diagram using the notation taught in lectures to represent the conceptual schema described by the Universe of Discourse. Depending on your design choices, you may need to use the extended ER diagram. Please follow the naming conventions taught in this course. State clearly any assumptions you make regarding your design approach on your ER Diagram. Please note that you cannot make assumptions to simplify or compromise the completeness of the Universe of Discourse.

Answer 1

Hi,

Here I'm attaching the image of the ER diagram

PFA.