Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Exercise 2 (total 35 pts): Given the table below, briefly answer the following questions. PROJECT_CODE PROJECT_MANAGER MANAGER_PHONE MANAGER_ADDRESS PROJECT_BID_PRICE 21-5Z Holly B. Parker 904-338-3416 3334
Exercise 2 (total 35 pts): Given the table below, briefly answer the following questions. 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-40 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., Gainesville, FL 37123 25559999.00 31-7P William K. Moor 904-445-2719 216 Morton Rd., Stetson, FL 30155 56850000.00 1. (2 pts) How many records are in the table? How many attributes? 2. (1 pts) What would you name this table? 3. (5 pts) Are there any naming anomalies that you, see? 4. (5 pts) Given the kind of table you think it is, give two other attributes that you would add to it? 5. (2 pts) List the data redundancies you discern from the above table? 6. (5 pts) What problem would you encounter if you wanted to produce a listing by city? How would you solve this problem by altering the structure of the table? 7. (2 pts) If you wanted to produce a listing by last name, area code, city, state, or zip code, how would you alter the structure of the table? 8. (3 pts) What data redundancies do you detect in the table resulting from your answer to question 7? How could those redundancies lead to anomalies? 9. (10 pts) Give one way in which you would alter the structure of the database to minimize the redundancies and reduce data anomalies
Step 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