Question 1 Given the table structure shown below, answer the following questions: 32 Project Manager Project Code Project Bid Price Manager Address Manager Phone Salary In herif Papel meget Purjet Det Jen Smith 21-52 1693843.00 33 Lee Rd., 612-898- 53000 57 3/11/18 Gainsville, FL 9909 37123 Ted J. Prime 25-6T 837292.23 239 River Dr., 904-227- 54000 5/05/18 St. Paul, MN 1245 55234 Hobbs 34-6R 9438373.00 982 W. Pitway. 651-782- 61890 11 10/11/19 Smythe St. Paul, MN 3645 55308 Jen D. 32-8E 8472022.45 32 Bent Rd., 612-891- 44500 52 8/21/19 Smother Tampa, FL 8909 37126 Hobbs 33-11 270230.11 982 W. Pitway. 651-782- 61890 | 11 5/03/06 Smythe St. Paul, MN 3645 55308 Sue Q. Perl 23-91 394854.00 874 Perl St., 823-772- 72500 6 11/23/19 Dodge, WI 1072 34976 Ted J. Prime 89-2W 3459.23 239 River Dr., 904-227- 54000 32 06/15/19 St. Paul, MN 1245 55234 Poppy Korn 12-7K 235872.90 297 Paddle St, 612-679- 67200 25 11/12/19 Rochester, MN 2374 87934 1. How many tuples does the table contain? How many attributes are there per tuple? 2. What problem would you encounter if you wanted to produce a listing by last name? How would you solve this problem by altering the table structure? 3. What would be a better way to store the Address attribute, so you can get a listing by Zip Code? 4. What data redundancies can you detect in the table above? Explain why data redundancy is undesired? 5. Give an example of delete anomaly, based on the table above. 6. Give an example of update anomaly, based on the table above