Please create an ER diagram for its database according to the following requirements: • company database will keep track of employees, facilities, and devices. • For each employee, it will keep track of a unique employee identifier as well as his or her name. • For each facility, it will keep track of a unique facility identifier as well as the facility type, and the date opened. • For each device, it will keep track of a unique device identifier as well as the device type.
Please create an ER diagram for its
• company database will keep track of employees, facilities, and devices.
• For each employee, it will keep track of a unique employee identifier as well as his or her name.
• For each facility, it will keep track of a unique facility identifier as well as the facility type, and the date opened.
• For each device, it will keep track of a unique device identifier as well as the device type.
• Each employee can access one or more facilities. Each facility can be accessed by one or more employees. Assume that each facility can be accessed by at least one employee, and that each employee can access at least one facility.
• Each device is issued to exactly one employee. Each employee can have zero or many devices issued to him or her. You can assume that each device is issued to an employee.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
