Entity Relationship Diagram Assignment

Please make complete ER solutions for the following problems. You may and draw (neatly) and scan them, or use the computer to do the diagrams. If you use the computer I suggest MySQL Workbench.

1. You are to design a database that maintains information for producing a weekly television guidefor a given region (such as Ohio). The data should include information abouttelevision shows, television networks, cities, channels, show times, etc. For starters, you maymake the following assumptions:

A given channel in a given city is associated with one network.

A given show is either owned by a network (and shown on a channel associated with that network) or is a local show and may be shown on any channel.

Not all shows are shown in all cities, and the days and times for a given show may differ from city to city.

You may ignore cable channels, which generally are not city-dependent.

Please feel free to make additional assumptions about the real world in your design, as long as the assumptions are reasonably realistic and are stated clearly as part of your solution.

Specify a list of entities for your database. In for each specify a list of attributes and relationships, don't forget to define keys.

Specify an entity-relationship diagram for your database. Don't forget to underline key attributes and include arrowheads indicating the multiplicity of relationships. Note that this question is fairly open-ended and there is no single right answer, but some designs are better than others.