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
Get step-by-step solutions from verified subject matter experts
