In this assignment, you will complete several different tasks related to database design. The following is a description and instructions for carrying out each task.

Creating Tables and Entity Relationship Diagram (ERD), Scenario 2.You have been hired to create a database for Razz Photographic Services (RPS) who is home to 3 professional photographers who do commissioned photography for various clients. When a client contracts with RPS for a job, exactly one photographer will be assigned to the job. A photographer can be assigned to several different clients at a time or no clients. They are growing and need to get a handle on who is working for what clients. The following are the business rules and assumptions you need to know as you design the database: A CLIENT may contract many COMMISSIONS and must commission at least one to be considered a client. A given COMMISSION is contracted by only one client A COMMISSION is assigned to only one PHOTOGRAPHER, but a photographer can be assigned to many commissions but isnt required to be assigned to any. Create the tables needed for this database using the instructions outlined in #1 of this assignment. Then create an ERD clearly indicating cardinality and whether a relationship is optional or required.