CIS 360 - Business Database Concepts – DB Design spreadsheet is a sample that is currently being used to track company data. However, re been complaining about the amount of maintenance needed to sustain the data. PROJ_NAME EMP_NUM Hurricane Hurricane Hurricane Coast Coast Satellite Satellite Satelite Satellite EMP_NAME JOB_CODE JOB_CHG_HOUR PROJ_HOURS EMP_PHONE 101 John D. Newson EE 85.00 13.3 653-234-3245 105 David F. Schwann CT 60.00 16.2 653-234-1123 110 Anne R. Ramoras CT 60.00 14.3 615-233-5568 101 John D. Newson EE 85.00 19.8 653-234-3254 108 June H. Sattlemeir EE 85.00 17.5 905-554-7812 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 112 Allecia R. Smith BE 85.00 20.7 615-678-6879 es that will arise by using this as a way to store and maintain company data. Use the actual xamples in your explanation. w design that addresses the issues listed above. Use Excel as a tool to show your design. work.

Principles of Economics 2e
2nd Edition
ISBN:9781947172364
Author:Steven A. Greenlaw; David Shapiro
Publisher:Steven A. Greenlaw; David Shapiro
Chapter7: Production, Costs, And Industry Structure
Section: Chapter Questions
Problem 22RQ: What are diminishing marginal returns as they relate to costs?
icon
Related questions
Question
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.
Transcribed Image 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.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Economics 2e
Principles of Economics 2e
Economics
ISBN:
9781947172364
Author:
Steven A. Greenlaw; David Shapiro
Publisher:
OpenStax