Consider the following information to design a database for a catalogue of an online video service...

Consider the following information to design a database for a catalogue of an online video service that offers access to popular TV series.

The following is the description of the application:

Each series has a name and a description.
Each series has many episodes. Each episode of a series has an episode number, the date it was first aired, and the length of the episode in minutes. The episode number uniquely identifies an episode with respect to the series, but two different series can have the same episode number.
Viewers can comment on any episode. For each comment, we want to record its post date, content and the first name/last name of the viewer who commented.
In this database:
- The name of each series is unique.
- A user can comment on one or more episodes of any series.
- You may add extra columns if you need for primary keys.
- You can model the user as a separate entity but registering the username with each comment is also acceptable.

Based on the above scenario, draw an ER or UML diagram. You can draw the diagram using https://app.diagrams.net/ or manually. Please mention if you make any assumptions.

Solutions

Expert Solution

venereology answered 11 months ago

Next > < Previous

Related Solutions

Database design of cothing Online Shopping System. Schema represents minimal information required to store information of...

Database design of cothing Online Shopping System. Schema represents minimal information required to store information of a shop and products to sell. Cart information can be stored in session or if wish-list / watchlist is needed, the schema can be simply extended. Enjoy. SQL and methodology.

Choose a clinical topic and design a search strategy for searching an online database such as...

Choose a clinical topic and design a search strategy for searching an online database such as CINAHL or MEDLINE. Reflect on your search strategy, for example, what search terms did you initially use, what new terms did you discover as you searched, how did you limit/refine your search?

Database ____ which is the logical design of the database, and the database _ which is...

Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time. a) Instance, Schema b) Relation, Schema c) Relation, Domain d) Schema, Instance

True or False: Logical database design is the process of modifying the physical database design to...

True or False: Logical database design is the process of modifying the physical database design to improve performance. The two major logical database design techniques are conversion of E-R diagrams to relational tables and data normalization. Multivalued attributes are not permitted in unnormalized data. A many-to-many binary relationship in an E-R diagram requires the creation of a total of three tables in a relational database. A one-to-one unary relationship in an E-R diagram requires the creation of a total of...

Database Design and SQL The following relations keep track of airline flight information: Flights (flno: integer,...

Database Design and SQL The following relations keep track of airline flight information: Flights (flno: integer, from : string, to: string, distance: integer, departs: time, arrive: time, price: integer) Aircraft (aid: integer, aname : string, cruisingrange: integer) Certified (eid: integer, aid: integer) Employees (eid: integer, ename : string, salary: integer) The Employees relation describe pilots and other kinds of employees as well. Every pilot is certified for some aircraft and only pilots are certified to fly. Based on the schemas,...

Creating a Database Design Lab 1: Creating a Database Design (Wk 3) - OR - Draw...

Creating a Database Design Lab 1: Creating a Database Design (Wk 3) - OR - Draw with pencil and paper diagram (take photo of it and submit) along with a summary of the diagram you prepared in a Word document. Use the scenario from Assignment 1: Business Rules and Data Models to complete the lab: Suppose a local college has tasked you to develop a database that will keep track of students and the courses that they have taken. In...

The Advanced Tech Company has a project to design an integrated information database for a major...

The Advanced Tech Company has a project to design an integrated information database for a major bank. Data for the project are given in the Table. Indirect project costs amount to $300 per day. The company will incur a $150 per day penalty for each day the project lasts beyond day 14. What would be the least cost to achieve this desired result? Activity Normal Time (days) Normal Cost ($) Crash Time (days) Crash Cost ($) Immediate Predecessor(s) A 6...

"Acquisitions" Please respond to the following: Use the Internet or Strayer online database to research a...

"Acquisitions" Please respond to the following: Use the Internet or Strayer online database to research a publically traded company that recently acquired another company. Analyze the performance of the combined company, and ascertain at least two (2) benefits that the combined companies gained from the acquisition.

What is important aspect about REA modeling for Accounting Information Systems database design?

Database Design Design a database and show the relationship between each tables. I need multiple tables....

Database Design Design a database and show the relationship between each tables. I need multiple tables. *Must meet the requirements for Third Normal Form. These are the information for employee DB. Employee Number, First Name, Last Name, Date of birth, Address, city, state, zip, department, job title, supervisor, health insurance number, health insurance provider, dental insurance number, dental insurance provider, spouse/partner, children, children's ages.

Subjects