Database management – Normalization
Given the Team relation below with sample data, state the Key and Functional Dependencies. Then normalize the relation to 3NF Team(StudentiD (Key), FirstName, LastName, Street, City, State, ZipCode, (TeamiD, TeamName)) Sample Data State ZipCode TeamID TeamName Studentid FirstName LastName Street S101 City Blue Devils Cavaliers Blue Devils Blue Coats Cavaliers Blue Coats Blue Devils Blue Coats Vanguard Vanguard Cavaliers Blue Coats Edison Fawcett 8989 Smith Rd Garfield NJ 07026 T52 T77 07026T52 07010 T43
OR
PayPal Gateway not configured
OR
PayPal Gateway not configured