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.
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.
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
Can you just draw this out on a piece of paper with the relationships??
Transcribed Image Text: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.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education