Question
1. In the table above, what is the minimum field size of Manager_Phone column? 2. What project codes relate to Holly B. Parker? 3. What
1. In the table above, what is the minimum field size of Manager_Phone column?
2. What project codes relate to Holly B. Parker?
3. What project codes relate to Russell Abratt?
4. 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 the above table, but using your new structural design. Remember in the revised table the records need to be sorted by managers last names.
5. 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 the above table, but using your new structural design. Remember that in the revised table only managers with an address in Florida is listed.
6. What data redundancies do you detect? How could those redundancies lead to anomalies?
In this assignment, you will answer the following questions based on the information presented in the file structure below. This assignment is based on the contents covered in module1. PROJECT CODE PROJECT MANAGER PHONE MANAGER ADDRESS PROJECT BID PRICE MANAGER 21-5Z Holly B Parker 3334 Lee Rd Gainesville, FL 37123 904-338-3416 16833460.00 Jane D Grant 218 Clark Blvd., Nashville, TN 36362 25-2D 615-898-9909 12500000.00 25-5A 615-227-1245 George F.Dorts 124 River Dr., Franklin, |32512420.00 TN 29185 Holly B Parker 3334 Lee Rd Gainesville, FL 37123 25-9T 904-338-3416 21563234.00 27-4Q 615-227-1245 George F.Dorts 124 River Dr., Franklin, 10314545.00 TN 29185 29-2D Holly B Parker 904-338-3416 3334 Lee Rd.,Ganesvi1le, FL 37123 25559999.00 William K. 904-445-2719 Moor 216 MortonRd., Stetson, FL 30155 31-7P 56850000.00Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started