Given the file structure shown in Figure P1.1, answer Questions 4 and 5 FIGURE P1.1 PROJECT CODE PROJECT MANAGER MANAGER PHONE 21-5Z 25-2D 25-5A 25-9T 27-4Q 29-2D 31-7P MANAGER ADDRESS 3334 Lee Rd., Gainesville, FL 37123 218 Clark Blvd., Nashville, TN 36362 PROJECT BID PRICE Holly B. Parker Jane D. Grant George F. Dorts Holly B. Parker George F. Dorts Holly B. Parker 904-338-3416 615-898-9909 615-227-1245 124River Dr, Franklin, TN 29185 904-338-3416 615-227-1245 124River Dr, Franklin, TN 29185 904-338-3416 904-445-2719 16833460.00 12500000.00 32512420.00 21563234.00 10314545.00 25559999.00 56850000.00 3334 Lee Rd., Gainesville, FL 37123 3334 Lee Rd., Gainesvlle, FL 37123 216 Morton Rd., Stetson, FL 30155 liam K. Moor 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? What data redundancies do you detect? How could those redundancies lead to anomalies? 4. 5