Are you good at Database Normalization?

I need help with this problem, the step by step is more important to me than a final answer, please brake it down into a clear simple English.

 

Transcribed Image Text:

2) Given the TECHNICIAN relation below with sample data, state the Key and Functional Dependencies. Then normalize the relation to BCNF. Be sure to proceed one normal form at a time. If it is necessary to normalize, only split the relation into two new relations at each normal form. TECHNICIAN (TechnicianID (Key), FirstName, LastName, Street, City, State, ZipCode, ShiftNumber (key), HoursPerShift) Sample Data: TechnicianID FirstName Last Name Street City State ZipCode Shift Number HoursPerShift T101 T102 Edison Fawcett Ishwarya Roberts T103 T104 Gerald Frederic Grodin Montand 8989 Smith Rd 6555 Hope Rd 512 E Grand Ave 5235 Ironwood Ln Garfield NJ 07026 AM1 8 Garfield NJ 07026 AM1 8 Cliffside Park NJ 07010 AM2 6.5 Garfield NJ 07026 PM2 8 T105 Dheeraj Alexander 666 22Nd Ave Ne Bergenfield NJ 07621 PM2 7.5 T106 Dheeraj Davis 4200 Bluejay Ave Bergenfield NJ 07621 PM2 8 T107 Faye Glenn 1522 Main St Cliffside Park NJ 07010 PM2 8 T108 Lauren T109 Larry T109 Larry Hershey Altman Altman 2360 Maxon Rd Englewood NJ 07631 AM1 7 T111 Meena T112 Charlie 1 Palisade Ave 1 Palisade Ave Alexander Po Box 2152 Buckley Englewood NJ 07631 AM2 4 Englewood NJ 07631 PM1 4 Fair Lawn NJ 07410 PM2 8 1790 Grand Blvd New Milford NJ 07646 PM1 8 T113 Mark de Funes 354 N Prince St Cliffside Park NJ 07010 AM2 4 2) Given the TECHNICIAN relation below with sample data, state the Key and Functional Dependencies. Then normalize the relation to BCNF. Be sure to proceed one normal form at a time. If it is necessary to normalize, only split the relation into two new relations at each normal form. TECHNICIAN (TechnicianID (Key), FirstName, LastName, Street, City, State, ZipCode, ShiftNumber (key), HoursPerShift) Sample Data: TechnicianID FirstName Last Name Street City State ZipCode Shift Number HoursPerShift T101 T102 Edison Fawcett Ishwarya Roberts T103 T104 Gerald Frederic Grodin Montand 8989 Smith Rd 6555 Hope Rd 512 E Grand Ave 5235 Ironwood Ln Garfield NJ 07026 AM1 8 Garfield NJ 07026 AM1 8 Cliffside Park NJ 07010 AM2 6.5 Garfield NJ 07026 PM2 8 T105 Dheeraj Alexander 666 22Nd Ave Ne Bergenfield NJ 07621 PM2 7.5 T106 Dheeraj Davis 4200 Bluejay Ave Bergenfield NJ 07621 PM2 8 T107 Faye Glenn 1522 Main St Cliffside Park NJ 07010 PM2 8 T108 Lauren T109 Larry T109 Larry Hershey Altman Altman 2360 Maxon Rd Englewood NJ 07631 AM1 7 T111 Meena T112 Charlie 1 Palisade Ave 1 Palisade Ave Alexander Po Box 2152 Buckley Englewood NJ 07631 AM2 4 Englewood NJ 07631 PM1 4 Fair Lawn NJ 07410 PM2 8 1790 Grand Blvd New Milford NJ 07646 PM1 8 T113 Mark de Funes 354 N Prince St Cliffside Park NJ 07010 AM2 4