Question 1: For the following case studies, draw an ER diagram to represent the data requirements as following: A. TV shows Database - Identify the main entity types. - Identify the main relationship types between the entity types. - Identify attributes and associate them with entity or relationship types. - Determine primary (or partial) key attributes for each entity type. Determine the multiplicity constraints for each relationship. - State any assumptions necessary to support your design. Suppose that you are designing a schema to record information about TV shows. Your database needs to record the following information: • For each show, its name, genre, basic_info and participants name. Any show has at least two or more participants. • For each producer, the company name, company country. A show is produced by exactly one producer. And one producer produces exactly one show. • For each channel, its name, start year, head office. A channel may broadcast multiple shows. Each show is broadcasted by exactly one channel. • For each user, his/her username, password, and age. A user may rate multiple shows, and a show may be rated by multiple users. Each rating has a score of 0 to 10.
Question 1: For the following case studies, draw an ER diagram to represent the data requirements as following: A. TV shows Database - Identify the main entity types. - Identify the main relationship types between the entity types. - Identify attributes and associate them with entity or relationship types. - Determine primary (or partial) key attributes for each entity type. Determine the multiplicity constraints for each relationship. - State any assumptions necessary to support your design. Suppose that you are designing a schema to record information about TV shows. Your database needs to record the following information: • For each show, its name, genre, basic_info and participants name. Any show has at least two or more participants. • For each producer, the company name, company country. A show is produced by exactly one producer. And one producer produces exactly one show. • For each channel, its name, start year, head office. A channel may broadcast multiple shows. Each show is broadcasted by exactly one channel. • For each user, his/her username, password, and age. A user may rate multiple shows, and a show may be rated by multiple users. Each rating has a score of 0 to 10.
Principles of Information Systems (MindTap Course List)
12th Edition
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter5: Database Systems And Applications
Section5.7: Information Systems @ Work: Brandwatch: Applying Business Intelligence To Social Media Data To Make Advertising Decisions
Problem 1CTQ
Related questions
Question
![Question 1: For the following case studies, draw an ER
diagram to represent the data requirements as following:
A. TV shows Database
- Identify the main entity types.
- Identify the main relationship types between the entity types.
- Identify attributes and associate them with entity or
relationship types.
- Determine primary (or partial) key attributes for each entity
type.
- Determine the multiplicity constraints for each relationship.
State any assumptions necessary to support your design.
Suppose that you are designing a schema to record information
about TV shows. Your database needs to record the following
information:
• For each show, its name, genre, basic_info and participants
name. Any show has at least two or more participants.
• For each producer, the company name, company country. A
show is produced by exactly one producer. And one
producer produces exactly one show.
• For each channel, its name, start year, head office. A channel
may broadcast multiple shows. Each show is broadcasted by
exactly one channel.
• For each user, his/her username, password, and age. A user
may rate multiple shows, and a show may be rated by
multiple users. Each rating has a score of 0 to 10.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fb69b72dc-c75a-4cd0-986f-4afef983d21e%2Fc2229012-c59c-4602-84c8-dac83f1900b2%2Fp5xah1n_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Question 1: For the following case studies, draw an ER
diagram to represent the data requirements as following:
A. TV shows Database
- Identify the main entity types.
- Identify the main relationship types between the entity types.
- Identify attributes and associate them with entity or
relationship types.
- Determine primary (or partial) key attributes for each entity
type.
- Determine the multiplicity constraints for each relationship.
State any assumptions necessary to support your design.
Suppose that you are designing a schema to record information
about TV shows. Your database needs to record the following
information:
• For each show, its name, genre, basic_info and participants
name. Any show has at least two or more participants.
• For each producer, the company name, company country. A
show is produced by exactly one producer. And one
producer produces exactly one show.
• For each channel, its name, start year, head office. A channel
may broadcast multiple shows. Each show is broadcasted by
exactly one channel.
• For each user, his/her username, password, and age. A user
may rate multiple shows, and a show may be rated by
multiple users. Each rating has a score of 0 to 10.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Principles of Information Systems (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781285867168/9781285867168_smallCoverImage.gif)
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
![Fundamentals of Information Systems](https://www.bartleby.com/isbn_cover_images/9781305082168/9781305082168_smallCoverImage.gif)
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![Principles of Information Systems (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781285867168/9781285867168_smallCoverImage.gif)
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
![Fundamentals of Information Systems](https://www.bartleby.com/isbn_cover_images/9781305082168/9781305082168_smallCoverImage.gif)
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning