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:
Employee ID Number
First Name
Last Name
Middle Initial
Title
Department Code
Department:
Department Code
Department Name
Mailbox Number
Phone Number
Device:
Device ID
Brand of Device
Model of Device
Registration Date of Device
Employee ID with Device
Mobile Device Database System:
Device ID
OS
OS Version
Serial Number
Screen Lock Enabled
Encryption Enabled
Desktop Device:
Device ID
Static IP Address
MAC Address
Building Name & Office Number
Server:
Server ID
Server Name
Brand
IP Address
Server Room
Virtual Server Specialization of Server:
Server ID
Physical Server ID
Service
Service ID
Service Name
Start Date
Server ID
Device Approval:
Device ID
Server ID
Approval Date
Removal Date
Employee Service Permission:
Employee ID FK
Service ID FK
Permission Date
Relationships:
Staff works in Department
Staff has Device
Device is approved for Server
Device can be a Mobile Device.
Device can be a Desktop.
Virtual Server runs on Physical Server.
Server connects to Device.
Server is located in Server Room.
Relationship Sentences:
Employee Department:
One department may employ many employees.
One employee must work for one department.
Employee Device:
One employee may have many devices.
One device must belong to one employee.
Device Server Approval:
One device may be approved for many servers.
One server may approve many devices.
Server Service:
One server may provide many services.
One service must be provided by one server.
Employee Service Permission:
One employee may be permitted to use many services.
One service may be accessed by many employees.
Physical Server Virtual Server:
One physical server may host many virtual servers.
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
