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

team_cde	team_lead_name	team_lead_phone	team_lead_address	team_income	team_lead_pay	hire_date
21-5Z	Alley C. Smith	904-338-3416	3334 Lee Rd., Gainsville, FL 37123	16833460.00	75000.00	01062015
25-2D	Jane D. Grant	615-898-9909	218 Clark Blvd., Nashville, TN 36362	12500000.00	78000.00	03012010
25-5A	George F. Dorts	615-227-1245	124 River Dr., Franklin, TN 29185	32512420.00	77000.00	12252012
25-9T	Alley C. Smith	904-338-3416	3334 Lee Rd., Gainsville, FL 37123	21563234.00	75000.00	01062015
27-4Q	George F. Dorts	615-227-1245	124 River Dr., Franklin, TN 29185	10314545.00	77000.00	12252012
29-2D	Alley C. Smith	904-338-3416	3334 Lee Rd., Gainsville, FL 37123	25559999.00	75000.00	01062015
31-7P	William K. Moor	904-445-2719	216 Morton Rd., Stetson, FL 30155	56850000.00	79000.00	11212014

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 team_lead last name, team_lead state they live in? How would you solve this problem by altering the table structure?

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

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

5. Give an example of delete anomaly, based on 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 like those used in the lecture slides, i.e. Word table format) at least 3 tables (with some attributes) that might be used to store information in a Car Dealership 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 like those used in the lecture slides) that you think were used in the application.

some attributes for each table. Remember to apply what you have learned so far in this class.