Question: 2) Normalize the following data. i Student Name Date of Birth Teacher Name Teacher Address Fees Paid Course Name Subject 1 Subject 2 Subject 3

2) Normalize the following data. i Student Name Date of Birth Teacher Name Teacher Address Fees Paid Course Name Subject 1 Subject 2 Subject 3 Subject 4 Economics 1 (Business) Biology 1 (Science) James Peterson 44 March Way, Glebe 56100 John Smith 18-Jul-00 4-Aug-91 Economics Business Intro (Business) Address 3 Main Street, North Boston 56125 16 Leeds Road, South Boston 56128 21 Arrow Street, South Boston 56128 14 Milk Lane, South Boston 56128 Biology 1 (Science) James Peterson Maria Griffin 44 March Way, Glebe 56100 Programming 2 (IT) Computer Science 10-Sep-92 14-May-01 Susan Johnson Sarah Francis 3-Feb-01 Biology 2 (Science) 13-Jan-91 Medicine 105 Mist Road, Faulkner 56410 Shane Cobson Matt Long 29-Apr-02 25-Apr-92 Dentistry 2) Normalize the following data. i Student Name Date of Birth Teacher Name Teacher Address Fees Paid Course Name Subject 1 Subject 2 Subject 3 Subject 4 Economics 1 (Business) Biology 1 (Science) James Peterson 44 March Way, Glebe 56100 John Smith 18-Jul-00 4-Aug-91 Economics Business Intro (Business) Address 3 Main Street, North Boston 56125 16 Leeds Road, South Boston 56128 21 Arrow Street, South Boston 56128 14 Milk Lane, South Boston 56128 Biology 1 (Science) James Peterson Maria Griffin 44 March Way, Glebe 56100 Programming 2 (IT) Computer Science 10-Sep-92 14-May-01 Susan Johnson Sarah Francis 3-Feb-01 Biology 2 (Science) 13-Jan-91 Medicine 105 Mist Road, Faulkner 56410 Shane Cobson Matt Long 29-Apr-02 25-Apr-92 Dentistry
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
