Please answer the following questions in reference to the table above.

1. How many records does the file contain and are there any problems with

2. What problem would you encounter if you wanted to produce a listing by you solve this problem by altering the file structure?

3. If you wanted to produce a report of the file by last name, area code, city, state, or zip code, how would you alter the file structure?

4. What data redundancies to you detect and how could these redundancies lead to anomalies?

PROB_1 01 PROJECT CODE PROJECT MANAGER MANAGER PHONE MANAGER ADDRESS 21-5Z 25-2D 25-5A 25-9T Holly B. Parke 904-338-3416 3334 Lee Rd., Gainesville, FL 37123 Jane D. Grant George F. Dorts 615-227-1245 124 River Dr. Franklin, TN 29185 Holly B. Parker 904-338-3416 3334 Lee Rd., Gainesville, FL 37123 George F.Dorts 615-227-1245 1 Holly B. Parker PROJECT BID PRICE 6833460.00 12500000.00 2512420.00 21563234.00 10314545.00 25559999.00 56850000.00 615-898-9909 218 Clark Blvd., Nashville, TN 36362 7-40 29-2D 31-7P 24 River Dr., Franklin, TN 29185 3334 Lee Rd., Gainesville, FL 37123 216 Morton Rd., Stetson, FL 30155 904-338-3416 William K. Moor 904-445-2715