Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 :
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. ie Showtime might show American Dad Monday at : PM on PBS and Tuesday at : PM on PBS
A show will have multiple actors.
An actor has a specific role in each show and can be in multiple shows ie Amanda Schull is Katrina Bennett on Suits and Dr Railly on Monkeys
Task
Your task is to study the business objectives and model the data and relationships to support these objectives. You must create an EntityRelationship Model. This should be a highlevel 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started