Suppose that you are developing ERD about reality shows on TV. For each reality show, its name, genre, basic_info and participants name. Any reality show has at least two or more participants. Reality show may run for multiple days during the week. For each producer, the company name, company country is stored. A show is produced by exactly one producer. And one producer produces exactly one show. For each television, its name, start year, head office is stored. A television may broadcast multiple shows. Each show is broadcasted by exactly one television. For each user, his/her username, password, and age is stored. A user may rate multiple shows, and a show may be rated by multiple users. Each rating has a score of 0 to 10. Every show comes with Advertisement. Advertisement may belong to Single or more shows. Every advertisement will have customer who will pay for different packages for advertisements. Advertisements may vary from Reality show. Task to do: i. Identify Entities with atleast 10 attributes per Entities. ii. Identify all relationship from the given Scenario iii. Generate Entity Relationship Diagram
Scenario – 2
Suppose that you are developing ERD about reality shows on TV. For each reality show, its
name, genre, basic_info and participants name. Any reality show has at least two or more
participants. Reality show may run for multiple days during the week. For each producer, the
company name, company country is stored. A show is produced by exactly one producer. And
one producer produces exactly one show. For each television, its name, start year, head office
is stored. A television may broadcast multiple shows. Each show is broadcasted by exactly one
television. For each user, his/her username, password, and age is stored. A user may rate
multiple shows, and a show may be rated by multiple users. Each rating has a score of 0 to 10.
Every show comes with Advertisement. Advertisement may belong to Single or more shows.
Every advertisement will have customer who will pay for different packages for advertisements.
Advertisements may vary from Reality show.
Task to do:
i. Identify Entities with atleast 10 attributes per Entities.
ii. Identify all relationship from the given Scenario
iii. Generate Entity Relationship Diagram
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
