Homework SoursePROJECTCODE PROJECT MANAGER MANAGERPHONE MANAGERADDRESS PROJ
PROJECT_CODE
PROJECT _MANAGER
MANAGER_PHONE
MANAGER_ADDRESS
PROJECT_BID_PRICE
21-5Z
Holly B. Parker
904-338-3416
3334 Lee Rd., Gainesville, FL 37123
16833460.00
25-2D
Jane D. Grant
615-898-9909
218 Clark Blvd., Nashville, TN 36362
12500000.00
25-5A
George F.Dorts
615-227-1245
124 River Dr., Franklin, TN 29185
32512420.00
25-9T
Holly B. Parker
904-338-3416
3334 Lee Rd., Gainesville, FL 37123
21563234.00
27-4Q
George F.Dorts
615-227-1245
124 River Dr., Franklin, TN 29185
10314545.00
29-2D
Holly B. Parker
904-338-3416
3334 Lee Rd.,Ganesvi11e, FL 37123
25559999.00
31-7P
William K. Moor
904-445-2719
216 MortonRd., Stetson, FL 30155
56850000.00
1.What is the minimum field size of Manager Phone column?
2.What project codes relate to Russell Abratt?
3.What problem would you encounter if you wanted to produce a listing of the managers by last name? How would you solve the problem by changing the file structure? Draw a table with records like Figure P1.1, but using your new structural design. Remember in the revised table the records need to be sorted by managers’ last names.
4.What problem would you encounter if you wanted to produce a listing of all managers with an address is Florida? How would you solve the problem by changing the file structure? Draw a table with records like Figure P1.1, but using your new structural design. Remember that in the revised table only managers with an address in Florida is listed.
5.What data redundancies do you detect? How could those redundancies lead to anomalies?
Please answer questions 1-5 reguarding the above table.
| PROJECT_CODE | PROJECT _MANAGER | MANAGER_PHONE | MANAGER_ADDRESS | PROJECT_BID_PRICE |
| 21-5Z | Holly B. Parker | 904-338-3416 | 3334 Lee Rd., Gainesville, FL 37123 | 16833460.00 |
| 25-2D | Jane D. Grant | 615-898-9909 | 218 Clark Blvd., Nashville, TN 36362 | 12500000.00 |
| 25-5A | George F.Dorts | 615-227-1245 | 124 River Dr., Franklin, TN 29185 | 32512420.00 |
| 25-9T | Holly B. Parker | 904-338-3416 | 3334 Lee Rd., Gainesville, FL 37123 | 21563234.00 |
| 27-4Q | George F.Dorts | 615-227-1245 | 124 River Dr., Franklin, TN 29185 | 10314545.00 |
| 29-2D | Holly B. Parker | 904-338-3416 | 3334 Lee Rd.,Ganesvi11e, FL 37123 | 25559999.00 |
| 31-7P | William K. Moor | 904-445-2719 | 216 MortonRd., Stetson, FL 30155 | 56850000.00 |
Solution
1.What is the minimum field size of Manager Phone column?
Ans. 12 , Because the Manager Phone column contains 10digits and 2 hypens ex:- 904-338-3416 so field size is 12.
2.What project codes relate to Russell Abratt?
Ans. Cannot determine from the above table. Because it doesnt contain Russell Abratt in PROJECT _MANAGER column.
3.What problem would you encounter if you wanted to produce a listing of the managers by last name? How would you solve the problem by changing the file structure? Draw a table with records like Figure P1.1, but using your new structural design. Remember in the revised table the records need to be sorted by managers’ last names.
Ans. It gives an error message, because the table contains only PROJECT_MANAGER column it doesnt contain last name.
new table with manager_lastname sorting order as follows
4.What problem would you encounter if you wanted to produce a listing of all managers with an address is Florida? How would you solve the problem by changing the file structure? Draw a table with records like Figure P1.1, but using your new structural design. Remember that in the revised table only managers with an address in Florida is listed.
Ans. It produces an error. it doesnt contain address Florida in MANAGER_ADDRESS column.
5.What data redundancies do you detect? How could those redundancies lead to anomalies?
Ans. There is a redundant data in the PROJECT_MANAGER column i.e., Holly B. Parker,George F.Dorts
| PROJECT_CODE | MANAGER_FIRSTNAME | MANAGER_LASTNAME | MANAGER_PHONE | MANAGER_ADDRESS | PROJECT_BID_PRICE |
| 21-5Z | Holly B. | Parker | 904-338-3416 | 3334 Lee Rd., Gainesville, FL 37123 | 16833460 |
| 25-5A | George F. | Dorts | 615-227-1245 | 124 River Dr., Franklin, TN 29185 | 32512420 |
| 27-4Q | George F. | Dorts | 615-227-1245 | 124 River Dr., Franklin, TN 29185 | 10314545 |
| 25-2D | Jane D. | Grant | 615-898-9909 | 218 Clark Blvd., Nashville, TN 36362 | 12500000 |
| 31-7P | William K. | Moor | 904-445-2719 | 216 MortonRd., Stetson, FL 30155 | 56850000 |
| 25-9T | Holly B. | Parker | 904-338-3416 | 3334 Lee Rd., Gainesville, FL 37123 | 21563234 |
| 29-2D | Holly B. | Parker | 904-338-3416 | 3334 Lee Rd.,Ganesvi11e, FL 37123 | 25559999 |
