MIDDLESEX COUNTY COLLEGE BUSINESS & COMPUTER SCIENCE DEPARTMENT DATABASE SYSTEMS Spring 201 SC239-01 Database Systems Test #1 Page 2 C Based on the following file structure, answer the questions below. (2 points each -1 g file structure, answer the questions below. (2 points each = 12 points) PRO 904-338-3416 3334 Lee Rd, Gainesville, FL 37123$16,833,460 00 $32,512,420.00 $21,9%,23400 10,314,545.00 FL 37123 $25,559,999 00 $58,850,00000 Holly B Parker Jane D. Gerart 218 Clark Blvd, Nashvile, TN 36362 $12,500,000.00 124 River Dr. Froniin, TN 29185 25-20 615-898-9909 25-5A 25-9T 27-40 29-20 31-7P George F. Dorts 615-227-1245 Holly B.Parker George F. Dorts Holly B.Parker , Gainesvile, FL 37123 904-338-3416 3334 Lee Rd 615-227-1245 904-338-3416 3334 Lee Rd, Gainesvile, 904-445-2719 216 Morton Rid, Stetson, FL 30155 124 River Dr.,Frankin, TN 29185 K. Moor 1. How many records does the file contain, and 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? If you wanted to produce a listing of the file contents by last name, area code, city, state, or ZIPCODE, how would you alter the file structure? 3. What data redundancies do you detect, and how could these redundancies lead to anomalies