1. Netflix needs you to design a database application system using 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 Netflixs 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 Netflix.
• A content provider can provide zero or more shows to Netflix, but a certain show can only be purchased from one content provider (who owns the rights).