1. Engineering
  2. Computer Science
  3. please draw a erd with relationship between entities...

Question: please draw a erd with relationship between entities...

Question details

A laboratory has several chemists who work on one or more projects. A project may involve one to many chemists. Chemists may also use certain kinds of equipment on each project. Attributes of CHEMIST include Employee_ID (identifier), Name, and Phone_no. Attributes of PROJECT include ProjectID identifier) and Start_Date. Attributes of EQUIPMENT include Serial_no. and Cost. The organization wants to record Assign_Date that is, the date when a chemist is assigned to a specified project. Thoe organization also wants to record which cquipment a particular chemist is using for a specified assignment. An assignment requires one equipment. An equipment may be assigned to zero, one or many assignments.

Please draw a ERD with relationship between entities

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution