1. Engineering
  2. Computer Science
  3. 04 consider the following file structure 15 points proi num...

Question: 04 consider the following file structure 15 points proi num...

Question details

04. Consider the following File Structure: (15 points PROI NUM | PROJ NAME İ EMP NUM | EMP NAME | JOB CODE | IOB CHG HR | PROJ HR Hurricane 101 ohn D. Hurricane 105 David F Schwann Anne R 60.00 Hurricane 110 ohn D June H. Anne R David F 85.00 19.8 17S 110 62.00 Satellite 105 Mary D ЕЕ 85.00 19.1 Satellite 112 Alicia M. BE 20.7 a. Re-write the above using new file structures that will help to eliminate the data redundancies currently present in the file structure. b. What changes would you make in the new file structure containing EMP NAME, such that one can sort the records alphabetically based on the employee last name.

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution