1.The tables below shows the desired output reports with sample data , as a junior database designer you have been tasked to normalized the relations below using 1s^st,2^nd and 3^nd normalized forms.(show clearly the normalization steps/process).

Student report: ID Name 4567 Helen Wheels 4973 Barry Bookworm 6758 Carla Coed 510-555-2859 510-555-9403 510-555-DORM 678okwormeHayward CA 9454Hme Phore P.O. Box 45 Oakland CA 94601 South Hall #23 Berkeley CA 94623 Course report: ID X100 X301 X302 X422 X40 Title Concepts of Data Proc COBOLI COBOL II Systems Analysis Concepts of DBMS 4 4 6 6 6 none X100 301 301 301. X422 This course blah, blah Continuation of... Introduction to... more blah, blah, Instructor report: ID Name 756 Werdna Leppo 12 Main St. Home Phone Office Phone Coses 510-976-CLAS %.7463 X408, X422 Alameda CA 94501 x301 302 793 Cora Coder 32767 Binay Way 510-535-1010 5382 Abend CA 21304 123 Forms Rd Paperwork CA 95684 801 Tillie Talker 10-555-BLAB x-3547 X100 Student report: ID Name 4567 Helen Wheels 4973 Barry Bookworm 6758 Carla Coed 510-555-2859 510-555-9403 510-555-DORM 678okwormeHayward CA 9454Hme Phore P.O. Box 45 Oakland CA 94601 South Hall #23 Berkeley CA 94623 Course report: ID X100 X301 X302 X422 X40 Title Concepts of Data Proc COBOLI COBOL II Systems Analysis Concepts of DBMS 4 4 6 6 6 none X100 301 301 301. X422 This course blah, blah Continuation of... Introduction to... more blah, blah, Instructor report: ID Name 756 Werdna Leppo 12 Main St. Home Phone Office Phone Coses 510-976-CLAS %.7463 X408, X422 Alameda CA 94501 x301 302 793 Cora Coder 32767 Binay Way 510-535-1010 5382 Abend CA 21304 123 Forms Rd Paperwork CA 95684 801 Tillie Talker 10-555-BLAB x-3547 X100