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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!