Problems: PROJECT_CODE 21-5Z 25-2D 25-5A 25-9T 27-40 29-2D 31-7P PROJECT MANAGER Holly B. Parker Jane D. Grant George F. Dorts Holly B. Parker George F. Dorts Holly B. Parker William K. Moor MANAGER_PHONE 904-338-3416 615-898-9909 615-227-1245 904-338-3416 615-227-1245 904-338-3416 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 Figure 1 Questions 1-3 refer to Figure 1: 1. Describe the additional data processing/transformation that would be required if you wanted to sort the data by the city name? 2. Describe the additional data processing/transformation that would be required if you wanted to sort the data by the Project Manager's Last name? 3. Consider the list of fields (Project Code, Project Manager, Manager Phone, Manager_Address, and Project_Bid_Price. Which of these fields have redundant data, and which are unique, under the current way the data is organized? (Hint: notice that, among other redundancies, the Project_Manager name "Holly B. Parker" appears more than once.) Problems: PROJECT_CODE 21-5Z 25-2D 25-5A 25-9T 27-40 29-2D 31-7P PROJECT MANAGER Holly B. Parker Jane D. Grant George F. Dorts Holly B. Parker George F. Dorts Holly B. Parker William K. Moor MANAGER_PHONE 904-338-3416 615-898-9909 615-227-1245 904-338-3416 615-227-1245 904-338-3416 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 Figure 1 Questions 1-3 refer to Figure 1: 1. Describe the additional data processing/transformation that would be required if you wanted to sort the data by the city name? 2. Describe the additional data processing/transformation that would be required if you wanted to sort the data by the Project Manager's Last name? 3. Consider the list of fields (Project Code, Project Manager, Manager Phone, Manager_Address, and Project_Bid_Price. Which of these fields have redundant data, and which are unique, under the current way the data is organized? (Hint: notice that, among other redundancies, the Project_Manager name "Holly B. Parker" appears more than once.)