Question

Below is a summary of student course enrollment in the School of Management. Please normalize this spreadsheet into third normal form (3NF).

Course Course Name Classroom Days Time Student UMID MD Motor Major Major Major Code Email Email Phone Phone Number 248-502- 3030 ACC201 2317 M/W 4:00- 5:15 William Baxter 2934745 Accounting ACC wbax@umflint.edu Financial Accoutning Financial Accoutning ACC201 2317 MW 4:00- 5:15 Sarah Charles 7367793 Accounting ACC 248-502- 1038 scha@umflint.edu ACC201 2317 MW 4:00- 5:15 David Liman 9358862 Management MGT 248-502- 8376 dlim@umflint.edu ILUUIIII Financial Accoutning Fundamentals of Management MGT305 2325 T/U 12:30- 13:45 John Stephens 1269367 Marketing | MKT 248-502- 8368 jste@umflint.edu MGT305 Fundamentals of Management 2325 T/U 12:30- 13:45 Gavin Norvski 3764899 Management MGT 305-588- 9980 gnor@umflint.edu BUS332 Business Communications 2340 2340 F F 8:00- 11:00 Wisatmaker Sam Whittaker 3079532 Finance FIN 612-226- 0986 swhi@umflint.edu 248-502- BUS332 Business Communications 2340 8:00- 11:00 Amanda Amanda Losszacowaniem 3567768 Marketing Leung ??? aleu@umflint.edu 7259

Answer 1

In order to convert a table into 3NF from we have to take following points into consideration: 1. 2. 3. 4. Identify any dependencies between non-key attributes within table Remove them to form a new table Promote one of the attributes to be the key of the new table This becomes the Foreign Key link in the original table For the given table MajorP Code Phone Number Email Course | Course Name | Classroom Days | Time | Student | UMIDİ Major ACC201 Financial ACC201 Financial ACC201 Financial MGT305 of Management MGT305 of Management BUS332 Business BUS332 Mw 400- William 2934745 Accounting Baxter ACC 248.502 5:15 5:15 4:00 3030 2317 M 4:00- Sarah 7367793 Charles AccountingACC248.502 248-502- scha@umflint.edu David Liman 248-502-dlim@umflint.edu 2317 Mw 9358862 ManagementMGT 1269367 Marketing MKT 3764899 Management MGT 5:15 8376 2325 | TU| 13:45 | Stephens 12:30 John 248-502 8368 jste@umflint.edu Gavin 305-588- gnoraumflint. edu 12:30 2325 T/U 13:45 Sam F 8:00 FIN 612-226- 2340 nance Whittaker 3079532 0986Shiflint.edu 11:00 8:00- 11:00 248-502- aleu@umfint edu 2340 3567768 Marketing MKT Leung 7259

Here is its 3NF form TABLE 1 TABLE 2 Major Code UNIIDİ Major 2934745Accounting ACC 7367793Accounting ACC 9358862 ManagementMGT 1269367Marketing MKT 3764899ManagementMGT 3079532 Finance CourseCourse Name Classroom Days Time ACC201 Financial ACC201 Financial ACC201 Financial MGT305 of Management MGT305 of Management BUS332 Business BUS332 Business 2317MW 4:00- 5:15 2317 Mw 4:00- 4:00 2317 MW 5:15 Fundamentals TU 12:30- 13:45 12:30- 13:45 Fundamentals 2325 TUu 8:00 11:00 2340 FIN 8:00 11:00 3567768Marketin MKT Communications 2340

TABLE 3 Major Code Phone Number Student Email William248-502-wbaxQumflint.edu Baxter ACC 3030 248-502- schaumflint edu 248-502-dlim@umflint edu 8368 Jste@umflint.edu 9980 gnoraumflint.edu 0986 swhi@umflint edu Sarah Charles ACC 1038 David Liman MGT 8376 John 248-502 MKT Stephens Gavin 305-588- MGTNoxski Sam Whittaker 612-226- FIN Amanda248-502- aleu@umflintedu MKT Leung 7259 In this 3NF normal form Table 1 have course as primary key which is the foreign key in the givern table In Table 2 UMID is the primary key which is foreign key in the given table now And in the Table 3. Major Code is the primary key which is foreign key in the given table now