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 thediagrams on the same page to turn in.Scenario 1:A laboratory has several chemists who may use certain pieces of equipment. Each piece ofequipment 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, thatconnects CHEMIST and EQUIPMENT. Attributes of chemist include chemist id (PK), name andphone number. Equipment has the attributes serial number (PK) and cost. The organizationwishes to record an Assign_Date, i.e. the particular date when a given piece of equipment wasassigned to a particular chemist. (Hint Assign_date is an attribute of the Associate EntityCHEMIST-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 moreactivities, and an activity may have zero or more students participating in it. PARTICIPATION isthe 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
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.
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
Step by step
Solved in 2 steps with 3 images
