Create the ER Diagram and Relational Data Model for the following:

Hulu needs you to design a database application system using an ER diagram and a relational data model. The requirements collection and analysis phase has provided the following requirements for the database:

• The data stored on the shows they have include: the show ID number, title, year of release, lead actor, purchase price, and daily rental rate.
• The show ID number uniquely identifies each show.
• The Hulu's shows each fall into one of the following categories: comedy, drama, horror, musical, science fiction, children and adults only.
• A category can have zero to many shows in it, and a show must belong to one and only one category
• The catalog number uniquely identifies each of these categories.
• Data on content providers should also be stored, such as provider number, name, street, city, state, zip code, and telephone number. The content provider is the company who sold the content rights of a show to Hulu
• A content provider can provide zero or more shows to Hulu, but a certain show can only be purchased from one content provider (who owns the rights).