Consider the File Structure for the XYZ Company Project Management data given below. Then, respond to each of the following questions related to the structure. ProjectCode ProjectManager MgrTelephone MgrLocation ProjBidPrice 31-205A Sami A. Allen 773-555-1216 2900 S. Federal St. Chicago, IL 60616 $46,000 37-403B Cecily D. Worth 773-555-1217 27 Beckley Rd. Battle Creek, MI 49015 $1,342,000 33-906T Daisy B. Burns 773-555-8821 2543 W. Foster Ave. Chicago, IL 60625 $847,320 29-107D Alice M. Zane 773-555-1219 7202 Harrison Ave. Rockford, IL 61112 $1,449,000 21-929A Dean P. Pence 773-555-2222 6302 N. Northwest Hwy. Chicago, IL 60631 $903,117 41-386C Cecily D. Worth 773-555-1217 27 Beckley Rd. Battle Creek, MI 49015 $1,805,000 26-903C Sami A. Allen 773-555-1216 123 Lane St. Chicago, IL 60616 $78,081 29-227A Cecily D. Worth 773-555-1217 27 Beckley Rd. Battle Creek, MI 49015 $2,550,273 (a) If the XYZ Company wishes to display a listing of the Project Codes alphabetically by the right - most character, what problem(s), if any, would you encounter? Would it make any sense to solve this problem by altering the file structure? (b) What problem would you encounter if you desire to produce a listing by state? How would you solve this problem by altering the file structure? (c) 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?
Consider the File Structure for the XYZ Company Project Management data given below. Then, respond to each of the following questions related to the structure.
ProjectCode |
ProjectManager |
MgrTelephone |
MgrLocation |
ProjBidPrice |
|
|
|
|
|
31-205A |
Sami A. Allen |
773-555-1216 |
2900 S. Federal St. Chicago, IL 60616 |
$46,000 |
37-403B |
Cecily D. Worth |
773-555-1217 |
27 Beckley Rd. Battle Creek, MI 49015 |
$1,342,000 |
33-906T |
Daisy B. Burns |
773-555-8821 |
2543 W. Foster Ave. Chicago, IL 60625 |
$847,320 |
29-107D |
Alice M. Zane |
773-555-1219 |
7202 Harrison Ave. Rockford, IL 61112 |
$1,449,000 |
21-929A |
Dean P. Pence |
773-555-2222 |
6302 N. Northwest Hwy. Chicago, IL 60631 |
$903,117 |
41-386C |
Cecily D. Worth |
773-555-1217 |
27 Beckley Rd. Battle Creek, MI 49015 |
$1,805,000 |
26-903C |
Sami A. Allen |
773-555-1216 |
123 Lane St. Chicago, IL 60616 |
$78,081 |
29-227A |
Cecily D. Worth |
773-555-1217 |
27 Beckley Rd. Battle Creek, MI 49015 |
$2,550,273 |
(a) If the XYZ Company wishes to display a listing of the Project Codes alphabetically by the right - most character, what problem(s), if any, would you encounter?
Would it make any sense to solve this problem by altering the file structure?
|
(b) What problem would you encounter if you desire to produce a listing by state? How would you solve this problem by altering the file structure?
|
(c) 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?
|
(d) What data redundancies do you detect? How could those redundancies lead to anomalies?
|
(e) The ProjBidPrice column, in the given table, appears to have a wide range
of values. An XYZ Company
|
Trending now
This is a popular solution!
Step by step
Solved in 4 steps