Given the file structure shown in Figure P1.1, answer Questions 4 and 5. FIGURE P1.1 21-5Z...

 

Transcribed Image Text:

Given the file structure shown in Figure P1.1, answer Questions 4 and 5. FIGURE P1.1 21-5Z Holly B. Parker 25-2D Jane D. Grant 25-5A George F. Dorts 25-9T Holly B. Parker 27-4Q George F. Dorts 29-2D 31-7P Holly B. Parker William K. Moor 904-338-3416 615-898-9909 615-227-1245 904-338-3416 615-227-1245 904-338-3416 904-445-2719 PROJECT CODE PROJECT MANAGER MANAGER_PHONE MANAGER ADDRESS 3334 Lee Rd., Gainesville, FL 37123 218 Clark Blvd., Nashville, TN 36362 124 River Dr., Franklin, TN 29185 3334 Lee Rd., Gainesville, FL 37123 PROJECT BID_PRICE 16833460.00 12500000.00 32512420.00 21563234.00 124 River Dr., Franklin, TN 29185 10314545.00 3334 Lee Rd., Gainesville, FL 37123 25559999.00 216 Morton Rd., Stetson, FL 30155 56850000.00 4. 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? 5. What data redundancies do you detect? How could those redundancies lead to anomalies? Given the file structure shown in Figure P1.1, answer Questions 4 and 5. FIGURE P1.1 21-5Z Holly B. Parker 25-2D Jane D. Grant 25-5A George F. Dorts 25-9T Holly B. Parker 27-4Q George F. Dorts 29-2D 31-7P Holly B. Parker William K. Moor 904-338-3416 615-898-9909 615-227-1245 904-338-3416 615-227-1245 904-338-3416 904-445-2719 PROJECT CODE PROJECT MANAGER MANAGER_PHONE MANAGER ADDRESS 3334 Lee Rd., Gainesville, FL 37123 218 Clark Blvd., Nashville, TN 36362 124 River Dr., Franklin, TN 29185 3334 Lee Rd., Gainesville, FL 37123 PROJECT BID_PRICE 16833460.00 12500000.00 32512420.00 21563234.00 124 River Dr., Franklin, TN 29185 10314545.00 3334 Lee Rd., Gainesville, FL 37123 25559999.00 216 Morton Rd., Stetson, FL 30155 56850000.00 4. 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? 5. What data redundancies do you detect? How could those redundancies lead to anomalies?