subject

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.

• Some shows are broadcast multiple times over the course of a week. (i. e. Showtime might show The Tudors Sundays at 10:00 PM and Tuesday at 9:00 PM)

• A show will have multiple actors

• An actor has a specific role in each show and can be in multiple shows (i. e. Chris Noth is Mike on Law & Order and Mr. Big on Sex and the City)

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, meaning, unless necessary for understanding, you do not need to specify additional attributes for your entities and relationships other than ones described or implied above. 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. Again, if you need to make assumptions, ensure you document them at the bottom of your diagram.

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 14:30
Complete the sentence based on your knowledge of the professional difficulties faced by music artists. digital technology allows audiences to see free live telecasts of music or dance performances through
Answers: 1
question
Computers and Technology, 22.06.2019 15:20
The north and south regions had very diferent economies in the 1800s.
Answers: 1
question
Computers and Technology, 22.06.2019 19:20
Amedian in the road will be marked with a white sign that has a black arrow going to the left of the median. true false
Answers: 1
question
Computers and Technology, 23.06.2019 16:30
How to do this programming flowchart?
Answers: 3
You know the right answer?
You have been asked to develop a data model for TV Guide. Consider the following business rules: •...
Questions
Questions on the website: 13722367