Question

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

  1. 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.                                                                                                    [15 Marks]

Diagram
Engineering   Computer-Science   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

A series has two attributes- name and description. Name is the Primary key as it is unique.

An episode has attributes- episode number, series name, duration, date

As episode number can be same for two series, the primary key for an episode is a composite of series name and episode number.

A comment has attributes - username, date and content.

An episode can have comments from many users. Similarly, there can be comments from a user on different episodes.

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Consider the following set of requirements for a UNIVERSITY database that is used to keep track...
Consider the following set of requirements for a UNIVERSITY database that is used to keep track of students’ transcripts. This is similar but not identical to the database shown in Figure 1.2: a. The university keeps track of each student’s name, student number, Social Security number, current address and phone number, permanent address and phone number, birth date, sex, class (freshman, sophomore, ..., graduate), major department, minor department (if any), and degree program (B.A., B.S., ..., Ph.D.). Some user applications...
Consider the following set of requirement for a BANK database. Then draw an ER diagram based...
Consider the following set of requirement for a BANK database. Then draw an ER diagram based the requirement. The database keeps track of each back’s name, routing number, address. Banks has bank branch (you could name the relationship as BRANCHES). The bank branch described as branch name, branch location and branch ID. The branch ID is unique for each bank, but not unique in general. Users open account in bank branches. The accounts described by account number, account type, account...
You are tasked to design the ER diagram for the database for the 3S clothing store....
You are tasked to design the ER diagram for the database for the 3S clothing store. Data requirements are as given below. • Information about 3S employees includes a unique employee ID, and his/her name and position. • Each customer of 3S is identified by a customer ID, and has a name. • Information about the suppliers of 3S include a unique name, and a contact phone number. • Clothes stocked by 3S are described by a product code, size,...
A loan company wants to design a database to track student loans. Each student attending school...
A loan company wants to design a database to track student loans. Each student attending school is eligible for a loan. A student may have more than one loan. A student may be registered, possibly at different times, in more than one school. Each loan should belong to only one bank. Each bank can approve as many loans as it desires. For each loan, the loan company will track: the student’s SSN, name, address, amount of loan, date of the...
Read the directions Draw an ER diagram for a bank database. The database stores information about...
Read the directions Draw an ER diagram for a bank database. The database stores information about customers and their loans. Information about a customer includes the name, address, phone, SSN, and loan(s) the customer has. Loans have loan numbers, types (e.g. mortgage, car) and amount. Do not add any attributes other than the ones describe here. Modify your design to accommodate the following constraint(s). Each constraint is independent from one another. Again, do not add any attributes other than the...
Instructions: ​You must draw the ER Model for SpaceX Bank, save the ER Model as a...
Instructions: ​You must draw the ER Model for SpaceX Bank, save the ER Model as a png or jpeg, put your name on it and submit it on Blackboard before the due date. ​You can use ​any software​ you like to create this model. No emailed homework will be accepted no exception, and No late homework will be accepted no exceptions. Create the ER Model for ​SpaceX​ ​Bank ● Showalltheentities(regularentity,associativeentityorweakentity)with their attributes(key attribute, regular attribute or multi value attribute etc..)...
MySQL data model: Netflix would like for you to build them a data model that tracks...
MySQL data model: Netflix would like for you to build them a data model that tracks the following information: Netflix would like to track the television shows that are watched by subscribers to the service. Subscribers of the service may watch more than one TV show. Shows may be watched by more than one subscriber. For television shows, they would like to track the episodes that comprise the show. Subscribers to the Netflix service watch episodes of various shows and...
You are hired to design a database for a fitness center. As the fitness center is...
You are hired to design a database for a fitness center. As the fitness center is expanding with more than one branch, they want to create a database to keep track of its customers, facilities and employees. Each branch has a unique id and address (building number, street, district, and city). A branch may have more than one facility (e.g. swimming pool, spa, etc.). Each facility must belong to only one branch, and the information for a facility is name...
. Design an ER-diagram for a bank that implements the following requirements. The database you design...
. Design an ER-diagram for a bank that implements the following requirements. The database you design should store information about customers, accounts, branches and employees • Customer: Customers are identified by their SSN. For each customer we store a name, multiple phone numbers (one or more), and an occupation. • Account: Accounts are identified by an account number and the branch they belong to. For each account we store a balance and the type of account (e.g., savings). – An...
The county animal shelter has hired you to design a database to track the animals at...
The county animal shelter has hired you to design a database to track the animals at the shelter along with the people who adopt them. You have worked with the staff at the shelter, analyzed how they perform the work now, performed user requirements gathering and you have created a DFD. Below you will find the description of the entities and attributes defined during this process. Animal: animal_id, species, breed, age, gender, size, spay/neuter, intake_date, location, cost Adopter: name, phone,...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT