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.

ENGR.ECONOMIC ANALYSIS
14th Edition
ISBN:9780190931919
Author:NEWNAN
Publisher:NEWNAN
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
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
ENGR.ECONOMIC ANALYSIS
ENGR.ECONOMIC ANALYSIS
Economics
ISBN:
9780190931919
Author:
NEWNAN
Publisher:
Oxford University Press
Principles of Economics (12th Edition)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (MindTap Course List)
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Managerial Economics: A Problem Solving Approach
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
Managerial Economics & Business Strategy (Mcgraw-…
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education