Can you draw this out with the relationships?? 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.