Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Automating Access Databases With Macros

Authors: Fish Davis

1st Edition

1797816349, 978-1797816340

More Books

Students also viewed these Databases questions

Question

What should Meddevco have done to avoid some of its problems?

Answered: 1 week ago