I am new to Access and need to normalize then create tables using the data below. There is redundancy and I am not sure how to break the information down into effective tables. Any help you can provide is appreciated.
Table 1
MIS340; Management Information Systems I; 2009; Summer; Sec A; P.Gold; D-2790; M-W-F 8-10am
MIS350; Management Information Systems II; 2009; Summer; Sec A; P.Gold; D-2790; T-T 4-6pm
MIS340; Management Information Systems I; 2010; Spring; Sec A; C.Ferran; D-2770; M-W 4-6pm
MIS340; Management Information Systems I; 2010; Spring; Sec B; D.Walton; D-2770; T-T 8-10pm
MIS350; Management Information Systems II; 2010; Spring; Sec A; C.Ferran; D-2770; T-T 5-7pm
MIS340; Management Information Systems I; 2010; Fall; Sec A; R.Stevens; D-2770; M-W-F 9-10am
MIS350; Management Information Systems II; 2010; Fall; Sec A; C.Ferran; D-2770; T-T 5-7pm
ACT302; Managerial Accounting I; 2010; Spring; Sec A; W.Smith; B-2010; M 6-9pm
ACT302; Managerial Accounting I; 2010; Summer; Sec A; W.Smith; B-2010; W 6-9pm
ACT302; Managerial Accounting I; 2010; Fall; Sec A; W.Smith; B-2010; M 6-9pm
ACT303; Managerial Accounting II; 2010; Spring; Sec A; W.Smith; B-2065; F 6-9pm
ACT303; Managerial Accounting II; 2010; Summer; Sec A; W.Smith; B-2065; F 6-9pm
ACT303; Managerial Accounting II; 2010; Fall; Sec A; T.Thomas; B-2060; F 6-9pm
ACT303; Managerial Accounting II; 2010; Fall; Sec B; N.Snow; B-2065; N-W 1-3pm
MIS340; Management Information Systems I; 2009; Spring; Sec A; R.Stevens; D-2770; T-T 9-11am
MIS350; Management Information Systems II; 2009; Spring; Sec A; R.Stevens; D-2770; M-W 9-11am
Table 2
S101002; Claire Jones; MIS340; 2009; Summer; Sec A; A-
S101002; Claire Jones; MIS350; 2010; Spring ; Sec A; B+
S101002; Claire Jones; ACT302; 2010; Summer; Sec A; A-
S101002; Claire Jones; ACT303; 2010; Fall; Sec A+
S101008; Michael Smith; FIN101; 2009; Spring; Sec B; B-
S101008; Michael Smith; OPT201; 2009; Spring; Sec A; B+
S101008; Michael Smith; MIS340; 2009; Summer; Sec A; A
S101008; Michael Smith; ACT302; 2010; Summer; Sec A; B-
S101008; Michael Smith; ACT303; 2010; Fall; Sec A+
S107802; Robert Ball; MIS340; 2009; Summer; Sec A; B-
S107802; Robert Ball; MIS350; 2010; Spring ; Sec A; A
S107802; Robert Ball; ACT302; 2010; Summer; Sec A; B+
S107802; Robert Ball; ACT303; 2010; Fall; Sec A
S101077; Mary McQueen; FIN101; 2009; Spring; Sec B; B+
S101077; Mary McQueen; OPT201; 2009; Spring; Sec A; B
S101077; Mary McQueen; MIS340; 2009; Summer; Sec A; A+
S101077; Mary McQueen; MIS350; 2010; Spring ; Sec A; A
S101077; Mary McQueen; ACT302; 2010; Summer; Sec A; A+
S101077; Mary McQueen; ACT303; 2010; Fall; Sec A
S101099; Doris Martin; ACT610; 2008; Spring; Sec A; B
S101099; Doris Martin; OB101; 2008; Fall; Sec A; B
S101099; Doris Martin; MIS340; 2008; Spring; Sec A; B
S101099; Doris Martin; MIS350; 2008; Fall; Sec A; B
TABLE 3
F0345; Carlos Ferran; MIS/Accounting; Associate professor; G-373; x2818; Boston University
F0104; Walter Smith; MIS/Accounting; Associate professor; G-656; x3515; Boston University
F0345; Naim Snow; MIS/Accounting; Associate Professor; G-434- x8978; Penn State
F0978; Margaret Doyle; Operations Management; Assistant professor; G-272; x1929; UCLA
F0876; Nathan Love; Finance; Professor; G-101; x2636; Indiana University
F0023; Mildred Ramirez; Marketing; Professor; G-171; x1878; University of Michigan
TABLE 4
MIS340; Management Information Systems; MIS340 is a basic course in Management Information Systems where the students will primarily learn how to use the basic computer tools (MS-Office suite). The course has both a lecture and a lab component.
ACT302; Managerial Accounting II; Focuses on analysis of managerial accounting information needed for planning and control. Investigates the manner in which accounting can provide this information. Emphasizes accounting as a management information tool.