CHEMIST Scenario 1 chemist_id INT CHEMIST EQUIP name VARCHAR(100) но- chemist_id INT phone_number VARCHAR(1... serial_number VARCHAR(5... >+ Indexes assign_date DATE STUDENT Indexes ㅁ ☐ ☐☐ ☐ ☐☐ Scenario 20 student_id INT PARTICIPATION first_name VARCHAR(5... student_id INT last_name VARCHAR(50) activity_id INT Indexes no_years INT Indexes H EQUIPMENT serial_number VARCHAR(5... OH cost DECIMAL(10,2) Indexes ACTIVITY activity_id INT activity_name VARCHAR(10... Indexes
CHEMIST Scenario 1 chemist_id INT CHEMIST EQUIP name VARCHAR(100) но- chemist_id INT phone_number VARCHAR(1... serial_number VARCHAR(5... >+ Indexes assign_date DATE STUDENT Indexes ㅁ ☐ ☐☐ ☐ ☐☐ Scenario 20 student_id INT PARTICIPATION first_name VARCHAR(5... student_id INT last_name VARCHAR(50) activity_id INT Indexes no_years INT Indexes H EQUIPMENT serial_number VARCHAR(5... OH cost DECIMAL(10,2) Indexes ACTIVITY activity_id INT activity_name VARCHAR(10... Indexes
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
is this diagram correctly following these instructions?? Here's the instructions: 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:
A laboratory has several chemists who may use certain pieces of equipment. Each piece of
equipment may be used by several chemists, or it may be idle, that is, not in use by anyone.
Since this is a many-to-many relationship, there is an associate entity CHEMIST-EQUIP, that
connects CHEMIST and EQUIPMENT. Attributes of chemist include chemist id (PK), name and
phone number. Equipment has the attributes serial number (PK) and cost. The organization
wishes to record an Assign_Date, i.e. the particular date when a given piece of equipment was
assigned to a particular chemist. (Hint Assign_date is an attribute of the Associate Entity
CHEMIST-EQUIPMENT.)
Scenario 2:
The entity type STUDENT represents any university student. ACTIVITY represents some campus-
based activity in which the student may participate. A student may participate in zero or more
activities, and an activity may have zero or more students participating in it. PARTICIPATION is
the associative entity that represents one student participating in one particular activity.
No_years is an attribute of PARTICIPATION. Each student has a unique ID first and last name;
and an activity has a unique ID and activity name.
Put both diagrams on the same EER Diagram page
Transcribed Image Text:CHEMIST
Scenario 1
chemist_id INT
CHEMIST EQUIP
name VARCHAR(100)
но-
chemist_id INT
phone_number VARCHAR(1...
serial_number VARCHAR(5... >+
Indexes
assign_date DATE
STUDENT
Indexes
ㅁ
☐ ☐☐
☐ ☐☐
Scenario 20
student_id INT
PARTICIPATION
first_name VARCHAR(5...
student_id INT
last_name VARCHAR(50)
activity_id INT
Indexes
no_years INT
Indexes
H
EQUIPMENT
serial_number VARCHAR(5...
OH
cost DECIMAL(10,2)
Indexes
ACTIVITY
activity_id INT
activity_name VARCHAR(10...
Indexes
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