Consider the File Structure for the ABC Company Project Management data given be

Question

Consider the File Structure for the ABC Company Project Management data given below. Then, respond to each of the following questions related to the structure.   

ProjectNum
ProjectName
EmpNum
EmpName
JobCode
Job_Chg_Hour
Proj_Hours
Emp_Phone
1001
Thunder
121
Daisy B. Burns
AB
80.00
14.2
773-555-1216
1001
Thunder
217
Alice M. Zane
CD
65.00
15.7
773-555-1216
1002
Chicago
821
Dean P. Pence
BD
95.00
14.4
773-555-1231
1002
Chicago
219
Cecily D. Worth
CD
80.00
17.2
773-555-1217
1003
Archimedes
222
Sami A. Allen
EH
65.00
24.9
773-555-8821
1003
Archimedes
121
Cecily D. Worth
AB
95.00
37.8
773-555-1219
1003
Archimedes
516
Denny T. Li
HW
80.00
22.2
773-555-2222
1004
Emerald
355
Danny T. Li
UG
65.00
19.7
773-555-2222
1005
Diamond
217
Alice M. Zane
CD
80.00
19.5
773-555-1216
1005
Diamond
222
Sami A. Allen
BD
95.00
22.3
773-555-8821
Question (a) List and discuss two additional fields that could or should appear on the above table structure.

Question (b) Identify and discuss the serious data redundancy problems exhibited by the file structure shown in the given data sheet. Consider the File Structure for the ABC Company Project Management data given below. Then, respond to each of the following questions related to the structure.   

ProjectNum
ProjectName
EmpNum
EmpName
JobCode
Job_Chg_Hour
Proj_Hours
Emp_Phone
1001
Thunder
121
Daisy B. Burns
AB
80.00
14.2
773-555-1216
1001
Thunder
217
Alice M. Zane
CD
65.00
15.7
773-555-1216
1002
Chicago
821
Dean P. Pence
BD
95.00
14.4
773-555-1231
1002
Chicago
219
Cecily D. Worth
CD
80.00
17.2
773-555-1217
1003
Archimedes
222
Sami A. Allen
EH
65.00
24.9
773-555-8821
1003
Archimedes
121
Cecily D. Worth
AB
95.00
37.8
773-555-1219
1003
Archimedes
516
Denny T. Li
HW
80.00
22.2
773-555-2222
1004
Emerald
355
Danny T. Li
UG
65.00
19.7
773-555-2222
1005
Diamond
217
Alice M. Zane
CD
80.00
19.5
773-555-1216
1005
Diamond
222
Sami A. Allen
BD
95.00
22.3
773-555-8821
Question (a) List and discuss two additional fields that could or should appear on the above table structure.

Question (b) Identify and discuss the serious data redundancy problems exhibited by the file structure shown in the given data sheet. Consider the File Structure for the ABC Company Project Management data given below. Then, respond to each of the following questions related to the structure.   

ProjectNum
ProjectName
EmpNum
EmpName
JobCode
Job_Chg_Hour
Proj_Hours
Emp_Phone
1001
Thunder
121
Daisy B. Burns
AB
80.00
14.2
773-555-1216
1001
Thunder
217
Alice M. Zane
CD
65.00
15.7
773-555-1216
1002
Chicago
821
Dean P. Pence
BD
95.00
14.4
773-555-1231
1002
Chicago
219
Cecily D. Worth
CD
80.00
17.2
773-555-1217
1003
Archimedes
222
Sami A. Allen
EH
65.00
24.9
773-555-8821
1003
Archimedes
121
Cecily D. Worth
AB
95.00
37.8
773-555-1219
1003
Archimedes
516
Denny T. Li
HW
80.00
22.2
773-555-2222
1004
Emerald
355
Danny T. Li
UG
65.00
19.7
773-555-2222
1005
Diamond
217
Alice M. Zane
CD
80.00
19.5
773-555-1216
1005
Diamond
222
Sami A. Allen
BD
95.00
22.3
773-555-8821
Question (a) List and discuss two additional fields that could or should appear on the above table structure.

Question (b) Identify and discuss the serious data redundancy problems exhibited by the file structure shown in the given data sheet.

Explanation / Answer

Answer : two more field that can be added are :

1) Department, it helps in identifying the department to which the particular project belongs hence helps in allocating resources.

2) project manager, this is an existing employee and will be heading the project.

B) in the given structure all the data is contained in one table hence multiple entries are made for a single project for all the employees that are working on that project. If there are 100 employees working on single project than 100 entries for the project are made , this is simply the redundant data and we can get rid of it by normalising the table.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.