Given the file structure shown in the following figure. PROJ_NUM PROJ_NAME EMP_NUM Hurricane 1 Hurricane 1...

 

Transcribed Image Text:

Given the file structure shown in the following figure. PROJ_NUM PROJ_NAME EMP_NUM Hurricane 1 Hurricane 1 Hurricane 2 Coast 2 Coast EMP_NAME 101 John D. Newson 105 David F. Schwann 110 Anne R. Ramoras 101 John D. Newson 108 June H. Sattlemeir 110 Anne R. Ramoras 105 David F. Schwann JOB CODE JOB CHG HOUR PROJ HOURS EMP PHONE 13.3 653-234-3245 $85.00 $60.00 16.2 653-234-1123 $60.00 14.3 615-233-5568 $85.00 $85.00 #555588 EE CT CT EE EE CT CT 3 Satelite 3 Satelite 3 Satelte 123 Mary D. Chen 3 Satelite 112 Allecia R. Smith a) Identify and discuss the serious data redundancy problems b) Looking at the storage format of the EMP_NAME and EMP_PHONE columns, what change(s) would you recommend? c) Identify the different data themes or topics in the file d) Given your answer to question c), what new files should you create to help eliminate the data redundancies found in the file shown in the figure? EE BE 19.8 653-234-3254 17.5 905-554-7812 $62.00 $26.00 $85.00 $85.00 11.6 615-233-5568 23.4 653-234-1123 19.1 615-233-5432 20.7 615-678-6879 Given the file structure shown in the following figure. PROJ_NUM PROJ_NAME EMP_NUM Hurricane 1 Hurricane 1 Hurricane 2 Coast 2 Coast EMP_NAME 101 John D. Newson 105 David F. Schwann 110 Anne R. Ramoras 101 John D. Newson 108 June H. Sattlemeir 110 Anne R. Ramoras 105 David F. Schwann JOB CODE JOB CHG HOUR PROJ HOURS EMP PHONE 13.3 653-234-3245 $85.00 $60.00 16.2 653-234-1123 $60.00 14.3 615-233-5568 $85.00 $85.00 #555588 EE CT CT EE EE CT CT 3 Satelite 3 Satelite 3 Satelte 123 Mary D. Chen 3 Satelite 112 Allecia R. Smith a) Identify and discuss the serious data redundancy problems b) Looking at the storage format of the EMP_NAME and EMP_PHONE columns, what change(s) would you recommend? c) Identify the different data themes or topics in the file d) Given your answer to question c), what new files should you create to help eliminate the data redundancies found in the file shown in the figure? EE BE 19.8 653-234-3254 17.5 905-554-7812 $62.00 $26.00 $85.00 $85.00 11.6 615-233-5568 23.4 653-234-1123 19.1 615-233-5432 20.7 615-678-6879