Scribd
Upload
5 views1 page

Chemist Project Equipment ERD and Dependencies

bai tap ne

Uploaded by

ngoclth23404a
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
5 views1 page

Chemist Project Equipment ERD and Dependencies

bai tap ne

Uploaded by

ngoclth23404a
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

1. A laboratory has several chemists who work on one or more projects.

Chemists also may 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 wishes 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 equipment item need not be assigned, and a given project need not
be assigned either a chemist or an equipment item. Provide good definitions for all of the
relationships in this situation

2.
 Employee has unique number. EmployeeName, are the same for each employee
 Branch has different departments. Department is identified by its number and assigned
for unique branch
 Performance of employees who work for a department is calculated by rating. Employees
can work for different department in different time.
 Assume the primary key for all the attributes above is EmployeeNo, DepartmentNo and
Time.
Identify the functional dependencies represented by the attributes shown in the form
Draw ERD for the 3NF of the database

You might also like