Show all work when completing these questions.

use the image below as a guide: (recommended format)

Relation V ( a, c ) Key: a FD1: a -> c

V is 1NF, 2NF and 3NF

Final Set of relations: T, U and V

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 work. Key: ,j FDI: i, j k, l, m, n, o FD2: i-> k, l FD3: m, no 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: City Garfield Garfield Garfield Cliffside Garfield State Studentld FirstName LastNameStreet S101 S101 S102 S103 S104 S105 S106 S107 S108 S109 S110 S110 Edison Edison Ishwarya Roberts 8989 Smith Rd oseph Joseph Dheeraj Alexander |667 22Nd Ave Dheeraj Davi Meena NJ NJ NJ NJ NJ BergenfieldNJ 4200 Bluejay Ave Springfield NY Fair Lawn NJ Collins 9435 Washington Springfield NJ Wappinger NY Wappinger NY Wappinger NY ZipCode TeamIDTeamName 07026 07026 07026 07010 07026 07621 11413 07410 07081 12590 12590 12590 T52 T77 T52 T43 T77 T43 T52 T43 T68 T68 T77 T43 Fawcett 8989 Smith Rd Fawcett 8989 Smith Rd Blue Devils Cavaliers Blue Devils Blue Coats Cavaliers Blue Coats Blue Devils Blue Coats Vanguard Vanguard Cavaliers Blue Coats Smith 512 Grand Ave Smith 5235 Ironwood Alexander Po Box 2152 ar rene Prem Prem Laughton 6 Master St Walken Walken 512 Grand Ave 512 Grand Ave 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 Last Name FirstName 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.0015 $5,025.75 $5,000.00 15 $4,234.60 $10,000.00 15 S935.75 $7,500.00 15 S575.00 $10,000.00 30 $879.25$7,500.00 30 $678.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 Campos Campos Gradey Gradey Grade Gradey Tian Tian Tian Tian Rafael Rafael Rafael Rafael Megan Megan Megan Megan Hui Hui Hui Hui Almondton General Store Unique Gifts R (a, b, c, d, e) Key: a, b FD1: a, b -> c, d, e FD2: a -> c, d, e FD3: c-> d, e 1NF: Because meets definition of a relation 2NF: No because FD2 is a partial key dependency (stop here and solve this problem!) Solution: Split R into two new relations (named S and T) Remove c, d, e from R Copy a Result: S(a, c, d, e ) Key: a T(a, b) Key: a, b T(a, b) Key: a, b 1NF: Because it is a relation with a key 2NF: Because it is "all key" 3NF: Because it is "all key" S( a, c, d, e) Key: a FD1: a -> c, d, e FD2: c-> d, e 1NF: Because it is a relation with a key 2NF: No partial key dependencies (key is a single attribute) 3NF: Not in 3NF because a->c and c->d,e which is a transitive dependency Solution: Split relation S into two new relations (named U and V) Remove d, e and Copy c Relation U (c, d, e) Key: c FD1: c-> d, e U is 1NF, 2NF and 3NF