FIGURE P1.1 THE FILE STRUCTURE FOR PROBLEMS 1-4 PROJECT_CODE PROJECT MANAGER MANAGER_PHONE 21-5Z Holly B. Parker 25-20 Jane D. Grant 25-5A George F. Dorts 25-9T Holly B. Parker 27-4Q George F. Dorts 904-338-3416 615-898-9909 615-227-1245 904-338-3416 615-227-1245 29-20 Holly B. Parker 904-338-3416 31-7P William K. Moor 904-445-2719 MANAGER_ADDRESS 3334 Lee Rd., Gainesville, FL 37123 218 Clark Blvd., Nashville, TN 36362 124 River Dr., Franklin, TN 29185 3334 Lee Rd., Gainesville, FL 37123 124 River Dr., Franklin, TN 29185 3334 Lee Rd., Gainesville, FL 37123 216 Morton Rd., Stetson, FL 30155 PROJECT_BID_PRICE 16833460.00 12500000.00 32512420.00 21563234.00 10314545.00 25559999.00 56850000.00 Given the file structure shown in Figure P1.1, answer Problems 1-4. 1. How many records does the file contain? How many fields are there per record? 2. What problem would you encounter if you wanted to produce a listing by city? How would you solve this problem by altering the file structure? 3. 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? 4. What data redundancies do you detect? How could those redundancies lead to anomalies?