Question

Given the file structure shown below, answer questions 1-4.

INV_NUM	CUSTOMER_NAME	CUSTOMER_ADDRESS	INV_TOTAL
104	LINO VIGIL	1201 BARNES AVENUE, Alquina, IN 47331	43.56
187	AMY CHO	1540 MARGE COURT, PAUL, MS 38920	63.98
190	MICHEAL KIRKLAND	1027 POLLOCK DRIVE, Greenback, TN 37742	269.36
217	RUBY HUDSON	1013 SNOWLINE DRIVE, Fayetteville, NC 28305	109.94
232	LINO VIGIL	1201 BARNES AVENUE, Alquina, IN 47331	71.54
297	MICHEAL KIRKLAND	1027 POLLOCK DRIVE, Greenback, TN 37742	279.15

1. How many records does the file contain? How many fields are there per record?

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

3. If you wanted to produce a listing of the file contents by first name, last name, 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?

Answer 1

No of records file contain = 4

No of fields =7*4=28

The problem faced will obtaining the list by state is that the address field is one with no sub division , asking for separate column for first line of address, city ,state ,etc

The problem can be altered by inserting a new field for address