Having trouble with intro to database.

please keep it simple and easy to comprehend.

Thank you!

PROB_1_01 PROJECT_CODE PROJECT_MANAGER MANAGER_PHONE Holly B. Parker Jane D. Grant George F. Dorts Holly B. Parker George F. Dorts Holly B. Parker William K. Moor PROJECT_BID_PRICE 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 21-5Z 25-2D 25-5A 904-338-3416 16833460.00 615-898-9909 12500000.00 615-227-1245 32512420.00 25-9T 904-338-3416 21563234.00 27-4Q 615-227-1245 10314545.00 29-2D 904-338-3416 25559999.00 904-445-2719 31-7P 56850000.00 Please answer the following questions in reference to the table above. How many records does the file contain and are there any problems with these records? 1. What problem would you encounter if you wanted to produce a listing by the city? How would you solve this problem by altering the file structure? If you wanted to produce a report of the file by last name, area code, city, state, or zip code, 2. 3. how would you alter the file structure? 4. What data redundancies to you detect and how could these redundancies lead to anomalies?12