Consider the File Structure for the XYZ Company Project Management data given below. Then, respond to each
Question:
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.
Project Code | Project Manager | Mgr Telephone | Mgr Location | Proj Bid Price |
| | | | |
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 database clerk suggests splitting the Project Management data into two file structures, as this may make it easier to search for values in this column. What issues, if any, could be resolved by proceeding with the clerk’s suggestions? What issues, if any, could be resolved by proceeding with the clerk’s suggestions?
Business Statistics a decision making approach
ISBN: 978-0133021844
9th edition
Authors: David F. Groebner, Patrick W. Shannon, Phillip C. Fry