Question: Given the file structure shown below, answer questions 1-4. INV_NUM CUSTOMER NAME INV_TOTAL 104 LINO VIGIL 43.56 187 AMY CHO 63.98 190 MICHEAL KIRKLAND CUSTOMER

Given the file structure shown below, answer

Given the file structure shown below, answer questions 1-4. INV_NUM CUSTOMER NAME INV_TOTAL 104 LINO VIGIL 43.56 187 AMY CHO 63.98 190 MICHEAL KIRKLAND CUSTOMER ADDRESS 1201 BARNES AVENUE, Alquina, IN 47331 1540 MARGE COURT, Paul, MS 38920 1027 POLLOCK DRIVE, Greenback, TN 37742 1013 SNOWLINE DRIVE, Fayetteville, NC 28305 1201 BARNES AVENUE, Alquina, IN 47331 1027 POLLOCK DRIVE, Greenback, TN 37742 269.36 217 109.94 232 RUBY HUDSON LINO VIGIL MICHEAL KIRKLAND 71.54 297 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!