ERD Homework #1 Using MySQL Modeler, draw the ERD that represents the following scenarios. You can put the diagrams on the same page to turn in. Scenario 1: Production companies make one or more movies. Movies have a title, duration, Director name, and Rating. The Production company has a name, the year it was established, and the city and state where its headquarters are located. A movie is made by exactly one production company. Not null attributes: Production company name, movie title, director name, and rating. Scenario 2: A company has a number of employees. Each employee has an employee ID, first and last name, address (street address, city, state, and zip) and birthdate. The company has one or more projects. The attributes of a project include project ID, project name, start date, end date, and budget. Each employee may be assigned to one project, or may not be assigned to any project. A project must have at least one employee assigned, and may have any number of employees assigned to work on it. Projects also need Resources, such as supplies, equipment etc. A Resource will have a resource number, name, and unit cost. Projects have one or more resource and a resource may be assigned to zero or one project. Not null attributes: Resource name, project name and budget, Employee first name, last name, and DOB (MUST USE SQL WORKBENCH)