1 . 1 . How many records does the above file contain? How many fields are there per record? 2 . 2 . What problem

$1.$ How many records does the above file contain? 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?

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

$4.$ What data redundancies do you detect? How could those redundancies lead to anomalies?

$5.$ Identify the attributes in Figure P$1\mathrm{.}1.$ What would you name this table$($the name of the entity$)?$

PROJECT CODE 31-6Y 35-4R 35-6B PROJECT MANAGER Angela T. Dunstable Edwina R. Washington Thomas Q. Farnham Angela T. Dunstable 35-8T 37-5R Thomas Q. Famham 39-2E 41-8P Angela T. Dunstable Jeffrey T. Zandman MANAGER PHONE 607-838-5567 803-626-5576 220-456-1199 607-838-5567 220-456-1199 607-838-5567 550-338-8383 MANAGER ADDRESS 6767 Sam Rd., Jacksonville, FL 37813 1763 Clark Ln., Jefferson MI, 88300 134 West St, Stanford, FL 38838 6767 Sam Rd., Jacksonville, FL 37813 134 West St, Stanford, FL 38838 6767 Sam Rd., Jacksonville, FL 37813 277 Monson Dr., Alpharetta, GA 34455 PROJECT BID PRICE 16678990.00 12467780.00 32500000.00 21566677.00 10310000.00 25667700.00 56609000.00