Answered step by step
Verified Expert Solution
Link Copied!

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 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

9. Someone who would like to write a book

Answered: 1 week ago

Question

Is SHRD compatible with individual career aspirations

Answered: 1 week ago