Font Paragraph Most of the features of Word have been disabled. Reactivate if you need to make a quick edit before renewing your subscription, learn more about the Office Web Apps. Learn IVY TECH COMMUNITY COLLEGE DBMS110 - MO1 Lab Assignment (7 questions; 40 points total) There are seven questions listed below. Based on the content in the MO1, answer each question. After completing, submit this assignment to the MO1 Lab Assignment link on Ivylearn. 1. (5 points) Use Figure 1.2 (below) to answer the following questions. a. In the table, how many records does the file contain? b. How many fields are there per record? List the name of each field? c. What problem would you encounter if you wanted to produce a listing by city? d. How would you solve this problem by altering the file structure? e. What is an additional field that can be added to this table? PROTECT GOCE PROJECT MANAGER MANAGER PHONE Holy B. Parker 904-338-3418 25-2D Jane D. Grant 615-89-9009 25-SA George F Dorts 25-31 615-2271245 Hoy Parker 904-338-3415 27-40 George F. Dorts 615-227-1245 904-338-3416 31-7P Wiek Moor 004-445-2719 MANAGER ADORESS 3334 Lee Rd, neve, FL 37123 218 Car Blvd, TN 38352 124 River Dr. Franklin, TN 29185 3334 Le Rd, O v , FL 37123 126 River Dr. Fran, TN 29165 3334 Le Rd, nevie, FL 37123 216 Morton Rd, Shton, FL 30155 PROJECT BO PROCE 316,833,460 00 312.500,000.00 $32.512,420.00 $21,563,234.00 310,314 54500 325 550,990 00 35.950,000.00 Figure 1.2. Table for exercise #5, by A. Watt