CIS 360 - Business Database Concepts – DB Design The following spreadsheet is a sample that is currently being used to track company data. However, employees have been complaining about the amount of...

Extracted text: CIS 360 - Business Database Concepts – DB Design The following spreadsheet is a sample that is currently being used to track company data. However, employees have been complaining about the amount of maintenance needed to sustain the data. EMP_NAME PROJ_NUM PROJ_NAME EMP_NUM 1 Hurricane JOB_CODE JOB_CHG_HOUR PROJ_HOURS EMP_PHONE 101 John D. Newson EE 85.00 13.3 653-234-3245 1 Hurricane 105 David F. Schwann CT 60.00 16.2 653-234-1123 1 Hurricane 110 Anne R. Ramoras CT 60.00 14.3 615-233-5568 2 Coast 101 John D. Newson EE 85.00 19.8 653-234-3254 2 Coast 108 June H. Sattlemeir EE 85.00 17.5 905-554-7812 3 Satellite 3 Satellite 3 Satelite 110 Anne R. Ramoras CT 62.00 11.6 615-233-5568 105 David F. Schwann CT 26.00 23.4 653-234-1123 123 Mary D. Chen EE 85.00 19.1 615-233-5432 3 Satellite 112 Allecia R. Smith BE 85.00 20.7 615-678-6879 1. List the issues that will arise by using this as a way to store and maintain company data. Use the actual data as examples in your explanation. 2. Create a new design that addresses the issues listed above. Use Excel as a tool to show your design. 3. Check your work.