Name:

$5$

Scenario $4$: Chemists, Projects, and Equipment $(10$ points$)$

A laboratory employs several chemists $($identified by employee ID$)$ who work on one or more

projects $($identified by project ID$).$ Chemists may use certain kinds of equipment $($identified by

equipment ID$)$ on each project. The laboratory wishes to record the date when a particular piece of

equipment is assigned to a particular chemist working on a particular project. Each chemist must be

assigned to at least one project and one equipment item. Equipment and projects do not

necessarily have to be assigned before being recorded in the planned system. Develop a practical

ERD that can efficiently store data about the entities described in this scenario. Include primary keys

and an assignment date attribute in your ERD. Define the ASSIGNMENT as a separate entity $($as an

associate entity$)$