Question: 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

 The following spreadsheet is a sample that is currently being used

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. PROJ_NUM PROJ_NAME EMP_NUM EMP_NAME JOB_CODE JOB_CHG_HOUR PROJ_HOURS EMP_PHONE 1 Hurricane 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 110 Anne R. Ramoras CT 62.00 11.6 615-233-5568 3 Satellite 105 David F. Schwann CT 26.00 23.4 653-234-1123 3 Satelite 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!