Question $1(3\mathrm{.}3$ points$)$: ERD

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

Read through the following business case.

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 or other notations for this work.

Relationship lines should be straight and should not cross.

Write out two "relationship sentences" for each relationship using the format:

One may be $($or must be$)$ one $($or many$)$

Baruch College is moving to allow staff computing. Staff 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 staff must work for a department. This designed 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 staff's staff 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 staff can use several devices but only devices that are registered to a staff will be in

the database. A device id will be assigned to a device when this device is registered.

Most staffs have at least one device, but newly hired staffs might not have any registered

devices initially. When a device is registered in the database system, the created database

system will store the brand and model of a device and the date of that registration.

Staffs 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. 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, this device may be approved for connections to one or more

servers. But not all devices are approved at the beginning.

The designed database 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.