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