Global Unified Technology Sales (GUTS) is moving toward a “bring your own device” (BYOD) model for employee computing. Employees can use traditional desktop computers in their offices. They can also use a variety of personal mobile computing devices such as tablets, smartphones, and laptops. The new computing model introduces some security risks that GUTS is attempting to address. The company wants to ensure that any devices connecting to their servers are properly registered and approved by the Information Technology department. Create a complete ERD to support the business needs described below: Every employee works for a department that has a department code, name,mail box number, and phone number. The smallest department currently has5 employees, and the largest department has 40 employees. This system willonly track in which department an employee is currently employed. Veryrarely, a new department can be created within the company. At such times,the department may exist temporarily without any employees. For everyemployee, an employee number and name (first, last, and middle initial) arerecorded in the system. It is also necessary to keep each employee’s title. An employee can have many devices registered in the system. Each device isassigned an identification number when it is registered. Most employees haveat least one device, but newly hired employees might not have any devicesregistered initially. For each device, the brand and model need to be recorded.Only devices that are registered to an employee will be in the system. Whileunlikely, it is possible that a device could transfer from one employee to However, if that happens, only the employee who currently owns thedevice is tracked in the system. When a device is registered in the system, thedate of that registration needs to be recorded. Devices can be either desktop systems that reside in a company office or mobile Desktop devices are typically provided by the company and areintended to be a permanent part of the company network. As such, eachdesktop device is assigned a static IP address, and the MAC address for thecomputer hardware is kept in the system. A desktop device is kept in a staticlocation (building name and office number). This location should also be keptin the system so that, if the device becomes compromised, the IT departmentcan dispatch someone to remediate the problem. For mobile devices, it is important to also capture the device’s serial number,which operating system (OS) it is using, and the version of the OS. The ITdepartment is also verifying that each mobile device has a screen lock enabledand has encryption enabled for data. The system should support storinginformation on whether or not each mobile device has these capabilities

Global Unified Technology Sales (GUTS) is moving toward a “bring your own device” (BYOD) model for employee computing. Employees can use traditional desktop computers in their offices. They can also use a variety of personal mobile computing devices such as tablets, smartphones, and laptops. The new computing model introduces some security risks that GUTS is attempting to address. The company wants to ensure that any devices connecting to their servers are properly registered and approved by the Information Technology department.

1. Create a complete ERD to support the business needs described below:
2. Every employee works for a department that has a department code, name,mail box number, and phone number. The smallest department currently has5 employees, and the largest department has 40 employees. This system willonly track in which department an employee is currently employed. Veryrarely, a new department can be created within the company. At such times,the department may exist temporarily without any employees. For everyemployee, an employee number and name (first, last, and middle initial) arerecorded in the system. It is also necessary to keep each employee’s title.
3. An employee can have many devices registered in the system. Each device isassigned an identification number when it is registered. Most employees haveat least one device, but newly hired employees might not have any devicesregistered initially. For each device, the brand and model need to be recorded.Only devices that are registered to an employee will be in the system. Whileunlikely, it is possible that a device could transfer from one employee to However, if that happens, only the employee who currently owns thedevice is tracked in the system. When a device is registered in the system, thedate of that registration needs to be recorded.
4. Devices can be either desktop systems that reside in a company office or mobile Desktop devices are typically provided by the company and areintended to be a permanent part of the company network. As such, eachdesktop device is assigned a static IP address, and the MAC address for thecomputer hardware is kept in the system. A desktop device is kept in a staticlocation (building name and office number). This location should also be keptin the system so that, if the device becomes compromised, the IT departmentcan dispatch someone to remediate the problem.
5. For mobile devices, it is important to also capture the device’s serial number,which operating system (OS) it is using, and the version of the OS. The ITdepartment is also verifying that each mobile device has a screen lock enabledand has encryption enabled for data. The system should support storinginformation on whether or not each mobile device has these capabilities 
6. Implement the above in a DBMS specifically using MySQL. Perform some
   queries and save them in your implementation