Be sure to show all of your work when completing these questions This is an individual assignment. 1) Consider the relation R, with key and functional dependencies shown below I. What Normal form is R in right now? Why? II. What actions would you take to normalize R to the next higher normal form? II. Follow those steps to normalize R to the next higher normal form. Be sure to show all work. IV. Once you have normalized R, what normal forms are each the two new relations in? Why? V. If any of the remaining relations are not in 3NF, normalize them to 3NF. Be sure to show all wor Ke FD1: i,j ->k, I, m, n, o FD2: ik, l 2) Given the Team relation below with sample data, state the Key and Functional Dependencies. Then normalize the relation to 3NF Team(StudentlD (Key), FirstName, LastName, Street, City, State, ZipCode, TeamID (Key), TeamName) Sample Data Studentld FirstName LastName Street S101 S101 S102 S103 S104 S105 S106 S107 S108 S109 S110 S110 City Garfield State ZipCode TeamID TeamName 07026 07026 07026 07010 07026 07621 11413 07410 07081 Fawcett 8989 Smith Rd Fawcett 8989 Smith Rd Ishwarya Roberts 8989 Smith Rd 512 Grand Ave 235 Ironwood Blue Devils Cavaliers Blue Devils Blue Coats Cavaliers Blue Coats Blue Devils Blue Coats Vanguard Vanguard Cavaliers Blue Coats ison T52 Garfield cliffside Garfield Bergenfield NJ T52 Joseph oseph Dheeraj Alexander 667 22Nd Ave Dheeraj Davis Meena Smith T43 Smith T43 T52 T43 T68 12590 T68 4200 Bluejay Ave SpringfieldNY Alexander Po Box 2152 Fair Lawn NJ s 9435 Washington Springfield NJ Irene Prem Prem Laughton 6 Master St Walken Walken 512 Grand Ave 512 Grand Ave Wappinger NY Wappinger NY Wappinger NY 12590 12590 T43 3) Given the CustomerRep relation below with sample data, state the Key and Functional Dependencies Then normalize the relation to 3NF CustomerNum 126 502 713 893 260 386 665 824 334 440 586 796 CustomerName Balance CreditLimit RepNum LastName FirstName Rafael Toys Galore Cards and More Cress Store All Season Gifts Brookings Direct Johnson's Department Store Cricket Gift Shop Kline's The Everything Shop 1,210.25 $7,500.00 15 5,025.75 $5,000.00 15 4,234.60 $10,000.00 15 935.75$7,500.00 15 $575.00 $10,000.00 30 $879.257,500.00 30 S678.90 7,500.00 30 2,475.99 $15,000.00 30 $2,345.75 $7,500.00 45 Grove Historical Museum Store $345.00 $5,000.00 45 3,456.75 $15,000.00 45 124.75 $7,500.00 45 Campos Campos Rafael Campos Campos Grade Gradey Gradey Gradey Tian Tian Tian Tian Rafael Rafael Megan Megan Megan Megan Hui Hui Hui Hui Almondton General Store Unique Gifts