Please prove detailly answer for all the questions blew, thank you so much.

(1) ( File Structures )

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

ProjectCode	ProjectManager	MgrTelephone	MgrLocation	ProjBidPrice
31-205A	Sami A. Allen	773-555-1216	2900 S. Federal St. Chicago, IL 60616	$46,000
37-403B	Cecily D. Worth	773-555-1217	27 Beckley Rd. Battle Creek, MI 49015	$1,342,000
33-906T	Daisy B. Burns	773-555-8821	2543 W. Foster Ave. Chicago, IL 60625	$847,320
29-107D	Alice M. Zane	773-555-1219	7202 Harrison Ave. Rockford, IL 61112	$1,449,000
21-929A	Dean P. Pence	773-555-2222	6302 N. Northwest Hwy. Chicago, IL 60631	$903,117
41-386C	Cecily D. Worth	773-555-1217	27 Beckley Rd. Battle Creek, MI 49015	$1,805,000
26-903C	Sami A. Allen	773-555-1216	123 Lane St. Chicago, IL 60616	$78,081
29-227A	Cecily D. Worth	773-555-1217	27 Beckley Rd. Battle Creek, MI 49015	$2,550,273

(a) If the XYZ Company wishes to display a listing of the Project Codes alphabetically by the right - most character, what problem(s), if any, would you encounter?

Would it make any sense to solve this problem by altering the file structure?

(b) What problem would you encounter if you desire to produce a listing by state? How would you solve this problem by altering the file structure?

(c) If you wanted to produce a listing of the file contents by last name, area code, city, state or zip code, how would you alter the file structure?

(d) What data redundancies do you detect? How could those redundancies lead to anomalies?

(e) The ProjBidPrice column, in the given table, appears to have a wide range of values. An XYZ Company database clerk suggests splitting the Project Management data into two file structures, as this may make it easier to search for values in this column. What issues, if any, could be resolved by proceeding with the clerks suggestions? What issues, if any, could be resolved by proceeding with the clerks suggestions?

(2) ( Database File Structures: Data Redundancy )

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

(a) List and discuss two additional fields that could or should appear on the above table structure.

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