Using MySQL Modeler, draw the ERD that represents the following scenarios. You can put the diagrams on the same page to turn in and save as a PDF. (File - Print to File - PDF format). 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.
draw this out on a piece of paper showing the relationship please:
Using MySQL Modeler, draw the ERD that represents the following scenarios. You can put the diagrams
on the same page to turn in and save as a PDF. (File – Print to File – PDF format).
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.
Step by step
Solved in 2 steps with 1 images