Question: Given the table structure shown below, answer the following questions: project_code project_manager manager_phone manager_address project_bid manager_pay PC001 Holly B. Parker 904-338-3416 3334 Lee Rd., Gainsville,
Given the table structure shown below, answer the following questions:
| project_code | project_manager | manager_phone | manager_address | project_bid | manager_pay |
| PC001 | Holly B. Parker | 904-338-3416 | 3334 Lee Rd., Gainsville, FL 37123 | 1683346.00 | 85000.00 |
| PC002 | Jane D. Grant | 615-898-9909 | 218 Clark Blvd., Nashville, TN 36362 | 1250000.00 | 88000.00 |
| PC003 | George F. Dorts | 615-227-1245 | 124 River Dr., Franklin, TN 29185 | 3251242.00 | 87000.00 |
| PC004 | Holly B. Parker | 904-338-3416 | 3334 Lee Rd., Gainsville, FL 37123 | 2156323.00 | 85000.00 |
| PC005 | George F. Dorts | 615-227-1245 | 124 River Dr., Franklin, TN 29185 | 1031454.00 | 87000.00 |
| PC006 | Holly B. Parker | 904-338-3416 | 3334 Lee Rd., Gainsville, FL 37123 | 2555999.00 | 85000.00 |
| PC007 | William K. Moor | 904-445-2719 | 216 Morton Rd., Stetson, FL 30155 | 5685000.00 | 99000.00 |
| PC008 | William K. Moor | 904-445-2719 | 216 Morton Rd., Stetson, FL 30155 | 3458769.00 | 89000.00 |
How many tuples does the table contain? How many attributes are there per tuple?
What data redundancies can you detect in the table?
Give an example of update anomaly
Give an example of delete anomaly
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help