Question: Draw an entity relationship model with the necessary entities, attributes, identifiers and relationships to capture the data below Entities: Employees: 1 ) Employee ID Number

Draw an entity relationship model with the necessary entities, attributes, identifiers and relationships to capture the data below
Entities:
Employees:
1) Employee ID Number
2) First Name
3) Last Name
4) Middle Initial
5) Title
6) Department Code
Department:
1) Department Code
2) Department Name
3) Mailbox Number
4) Phone Number
Device:
1) Device ID
2) Brand of Device
3) Model of Device
4) Registration Date of Device
5) Employee ID with Device
Mobile Device Database System:
1) Device ID
2) OS
3) OS Version
4) Serial Number
5) Screen Lock Enabled
6) Encryption Enabled
Desktop Device:
1) Device ID
2) Static IP Address
3) MAC Address
4) Building Name & Office Number
Server:
1) Server ID
2) Server Name
3) Brand
4) IP Address
5) Server Room
Virtual Server (Specialization of Server):
1) Server ID
2) Physical Server ID
Service
1) Service ID
2) Service Name
3) Start Date
4) Server ID
Device Approval:
1) Device ID
2) Server ID
3) Approval Date
4) Removal Date
Employee Service Permission:
1) Employee ID (FK)
2) Service ID (FK)
3) Permission Date
Relationships:
1) Staff works in Department
2) Staff has Device
3) Device is approved for Server
4) Device can be a Mobile Device.
5) Device can be a Desktop.
6) Virtual Server runs on Physical Server.
7) Server connects to Device.
8) Server is located in Server Room.
Relationship Sentences:
Employee Department:
1) One department may employ many employees.
2) One employee must work for one department.
Employee Device:
1) One employee may have many devices.
2) One device must belong to one employee.
Device - Server (Approval):
1) One device may be approved for many servers.
2) One server may approve many devices.
Server Service:
1) One server may provide many services.
2) One service must be provided by one server.
Employee - Service (Permission):
1) One employee may be permitted to use many services.
2) One service may be accessed by many employees.
Physical Server - Virtual Server:
1) One physical server may host many virtual servers.
2) One virtual server must be hosted by one physical server.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!