Fill This Form To Receive Instant Help
Fill This Form To Receive Instant Help
Homework answers / question archive / A laboratory has several chemists who work on one or more projects
A laboratory has several chemists who work on one or more projects. 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 Project_ID (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 given equipment item was assigned to a particular chemist working on a specified project. . A chemist must be assigned to at least one project and one equipment item. . A given piece of equipment need not be assigned, and a given project need not be assigned either a chemist nor a piece of equipment.
