You will create an Entity Relationship model for a business case.

1) Read through the following business case.

2) Create an Entity relationship model with the necessary entities, attributes, identifiers and relationships to capture the data. All relationships should be labeled with verb phrases. Use UML notation for this work. Relationship lines should be straight and should not cross.

3) Turite our two Yelationship sentences'" for each relationahip usine the format; One may be (or must be) one (or many)

Zack company is moving to allow employee computing. Employees can use desktop computers in their offices. They can also use a variety of personal mobile computing devices such as tablets, smartphones, and laptops. But this also introduces some security risks. The company wants to ensure that any devices connecting to their servers are properly registered and approved by the Information Technology department. The company tries to create a date based to satisfy business needs described below:

Every employee must work for a department. This database only tracks in which department an employee is currently employed. A newly created department may exist without any employees. The company wants to keep employee's employee number, name (first, last, and middle initial), and title. For a department, the company want to track a department code, name, mail box number, and phone number.

All employee can use several devices but only devices that are registered to an employee will be in the database. The designed database system will assign a device id to a device when this device is registered. Most employees have at least one device, but newly hired employees might not have any registered devices initially. When a device is registered in the database system, the database system will store the brand and model of a device and the date of that registration.

Employees can have both PC and mobile device. For each mobile device, system will store its operating system (OS), the version of the OS, and device serial number. IT department needs to verify whether each mobile device has a screen lock enabled and has encryption enabled for data. The system stores information on whether or not each mobile device has these capabilities enabled. For each desktop, system will record its static IP address, the MAC address, and location (building name and office number).

After a device's registration and the appropriate capabilities are enabled (if it is mobile device), this device may be approved for connections to one or more servers. But not all devices are approved at the beginning,

The system needs to store each server's name, brand, IP address, server rooms where the physical servers can be located, and its operating system. Some servers are virtual servers and some are physical servers. If a server is a virtual server, then the system should track which physical server it is running on. A single physical server can host many virtual servers, but each virtual server is hosted on only one physical server. Only physical servers can host a virtual server. In other words, one virtual server cannot host another virtual server. Not all physical servers host a virtual server.

A server can normally connect to many devices that are approved to access this server. However, a new server may not have any approved devices.