Given the table structure shown below, answer the following questions:

Project_Manager	Project_Code	Project_Bid_Price	Manager_Address	Manager_Phone	Number of People Managed
Jen D. Smith	21-5z	1693843.00	33 Lee Rd., Gainsville, FL 37123	612-898-9909	57
Ed P. Prime	25-6T	837292.23	239 River Dr., St. Paul, MN 55234	904-227-1245	32
Sue Q. Perl	34-6R	9438373.00	874 Perl St., Dodge, WI 34976	823-772-1072	6
Jen D. Smith	32-8E	8472022.45	33 Lee Rd., Gainsville, FL 37123	612-898-9909	57
George F. Dorts	24-2Y	487592.65	216 Morton Rd., Stetson, TN 29185	305-911-3874	15
Ed P. Prime	23-9I	394854.00	239 River Dr., St. Paul, MN 55234	904-227-1245	32

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 state? How would you solve this problem by altering the table structure?

3. What data redundancies can you detect in the table above? Explain why data redundancy is undesired?

4. Give an example of update anomaly, based on the table above.

5. Give an example of delete anomaly, based on the table above.

Question 2 (2 Points): Explain the concept of physical data independence and its importance in database systems.

Question 3 (2 Points): Describe (use GOOD TABLE LAYOUT format/style from slides) at least 3 tables that might be used to store information in a Veterinary system.

Question 4 (6 Points): List three applications (other than social-networking) you have used that most likely employed a database system to store data. For each application, list:

some tables (at least 3, and use good table layout format/style) that you think were used in the application. So a total of 9 tables, 3 tables for each application.

some attributes for each table. At least 4 attributes per table, so a grand total of 36 attributes.

use the table layout format in Word.