, day of the week. Provider: In the same way the channel is hosted by provider. They have provider_name, provider_id, provider_desc, provider_hostingcost. Customer: Similarly, cust_id, cust_lastname, cust_firstname, cust_phonenumbers, cust_address. Customers can have multiple phone numbers. Relationships: A television channel must be hosted by exactly one provider, while a provider can host one or can host many television channels. A provider must host at least one channel. A customer can watch no television channels or watch many television channels. Many channels are watched by ma
Draw an er diagram by following these constraints:
Entities and attributes:
Television_Channel: A television _channel has channel_id, channel_name,channel_desc.It stores all the information related to the television channel.
Show: Every show that is hosted by the channel will have the show_id,show_name. show_descripition, show_profits, show_comments, timings, day of the week.
Provider: In the same way the channel is hosted by provider. They have provider_name, provider_id, provider_desc, provider_hostingcost.
Customer: Similarly, cust_id, cust_lastname, cust_firstname, cust_phonenumbers, cust_address.
Customers can have multiple phone numbers.
Relationships:
A television channel must be hosted by exactly one provider, while a provider can host one or can host many television channels. A provider must host at least one channel. A customer can watch no television channels or watch many television channels. Many channels are watched by many customers and some channels are watched by no customers.
A customer watches no shows or many shows in a television channel. But a show must be watched by at least one customer.
A television channel hosts at least one or many shows. A show is only hosted by only one television channel. A show must be hosted by a channel.
Notes:
- Please identify the primary and foreign keys in the entities.
- Relationships must be drawn clearly with a white background.
- Show associative entities where applicable.
- For all addresses, in this assignment and future assignments, use the following format unless specifically indicated otherwise:
address_line_1
address_line_2
city
state_or_region
postal_code
country
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 10 images
