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
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
Concepts of Database Management
Authors: Philip J. Pratt, Mary Z. Last
8th edition
1285427106, 978-1285427102
