$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$)?$