Question
For figure P1.5 what are the data redundancy problems and which ones are they? PROB_1_05 PROJ_NUM PROJ_NAME EMP_NUM EMP_NAME JOB_CODE JOB_CHG_HOUR PROJ_HOURS EMP_PHONE 1 Hurricane
For figure P1.5 what are the data redundancy problems and which ones are they?
PROB_1_05 | |||||||
---|---|---|---|---|---|---|---|
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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started