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?

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

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.

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 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?

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions