Discussion:
Q: What new files should you create to help eliminate the data redundancies found in the file shown below:
|
PROJ NUM I
|
PROJ NAME
|
EMP NUM
|
EMP NAME
|
JOB CODE
|
JOB CHG HOUR'
|
PROJ HOURS
|
|
|
Hurricane
|
101
|
John D. Newson
|
EE $85.00
|
13.3
|
|
1
|
Hurricane
|
105
|
David F. Schwann
|
CT
|
$60.00
|
16.2
|
|
1
|
Hurricane
|
110
|
Anne R. Remoras
|
CT
|
$60.00 14.3
|
|
2
|
Coast
|
101
|
John D. Newson
|
EE
|
$85.00 19.8
|
|
2
|
Coast
|
108
|
June H. Sattlemeir
|
EE
|
$85.00 17.5
|
|
3
|
Satellite
|
110
|
Anne R. Ramoras
|
CT
|
$62.00 11.6
|
|
3
|
Satellite
|
105
|
David F. Schwann
|
CT
|
$26.00 23.4
|
|
3
|
Satelite
|
123
|
Mary D. Chen
|
EE
|
$85.00 19.1
|
|
3
|
Satellite
|
112
|
Allecia R. Smith
|
BE
|
$85.00 20.7
|