(Solved) : Given Table Structure Shown Answer Following Questions Teamcde Teamleadname Teamleadphone Q26249253 . . .
Given the table structure shown below, answer the followingquestions:
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 attributesare there per tuple?
2. What problem would you encounter if you wanted to produce alisting by team_lead last name, team_lead state they live in? Howwould you solve this problem by altering the table structure?
3. What data redundancies can you detect in the table? Explainwhy 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 ofphysical data independence and its importance in databasesystems.
Question 3 (2 Points): Describe (use good tablelayout format/style like those used in the lecture slides, i.e.Word table format) at least 3 tables (with some attributes) thatmight 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 likelyemployed a database system to store data. For each application,list:
some tables (at least 3, and use good table layout format/stylelike those used in the lecture slides) that you think were used inthe application.
some attributes for each table. Remember to apply what you havelearned so far in this class.
Expert Answer
Answer to Given Table Structure Shown Answer Following Questions Teamcde Teamleadname Teamleadphone Q26249253 . . .
OR