Question: Problem 1 : You have been asked to develop a data model for TV Guide. Consider the following business rules: There are many channels on

Problem 1:
You have been asked to develop a data model for TV Guide. Consider the following business rules:
There are many channels on TV
Each channel broadcasts many shows. A show may be broadcasted on different channels.
Some shows are broadcast multiple times over the course of a week. (i.e. Showtime might show American Dad Monday at 6:30 PM on PBS and Tuesday at 2:30 PM on PBS)
A show will have multiple actors.
An actor has a specific role in each show and can be in multiple shows (i.e. Amanda Schull is Katrina Bennett on Suits and Dr. Railly on 12 Monkeys).
Task
Your task is to study the business objectives and model the data and relationships to support these objectives. You must create an Entity-Relationship Model. This should be a high-level model, and you only need to specify attributes that are necessary for the purpose of the TV Guide, based on what is described or implied in the text. You do need to identify all entities, relationships, attributes and cardinalities according to the description above. These specifications might not be as clear or as formally defined as might be needed, but you are the data modeler, you can see through this, and when you can't, you write your assumptions and proceed anyway. It is important that your assumption does not violate the provided description above or the reality. And if you need to make assumptions, ensure you document them clearly at the bottom of your diagram.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!