4) To normalize a table, functional dependencies must be identified. Identify the primary key and any functional dependencies in...

 

Transcribed Image Text:

4) To normalize a table, functional dependencies must be identified. Identify the primary key and any functional dependencies in the following relation. Your answer goes here... An Example Database CustomerID 123 123 124 125 125 127 127 Name Mr. Smith Mr. Smith Mrs. Jones Mr. Axe Mr. Axe Mr. & Mrs. Builder Mr. & Mrs. Builder Street 123 Lexington 123 Lexington 12 Davis Ave. 443 Grinder Ln. 443 Grinder Ln. 661 Parker Rd. 661 Parker Rd. City State Account Number Balance Smithville KY 9987 Smithville KY 9980 Smithville KY 8811 Broadville GA 4422 Broadville GA 4433 Streetville GA Streetville GA 3322 1122 4000 2000 1000 6000 9000 500 800

Answer rating: 100% (QA)