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 [email protected] Financial Accoutning Financial Accoutning ACC201 2317 MW 4:00- 5:15 Sarah Charles 7367793 Accounting ACC 248-502- 1038 [email protected] ACC201 2317 MW 4:00- 5:15 David Liman 9358862 Management MGT 248-502- 8376 [email protected] ILUUIIII Financial Accoutning Fundamentals of Management MGT305 2325 T/U 12:30- 13:45 John Stephens 1269367 Marketing | MKT 248-502- 8368 [email protected] MGT305 Fundamentals of Management 2325 T/U 12:30- 13:45 Gavin Norvski 3764899 Management MGT 305-588- 9980 [email protected] BUS332 Business Communications 2340 2340 F F 8:00- 11:00 Wisatmaker Sam Whittaker 3079532 Finance FIN 612-226- 0986 [email protected] 248-502- BUS332 Business Communications 2340 8:00- 11:00 Amanda Amanda Losszacowaniem 3567768 Marketing Leung ??? [email protected] 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- [email protected] David Liman [email protected] 2317 Mw 9358862 ManagementMGT 1269367 Marketing MKT 3764899 Management MGT 5:15 8376 2325 | TU| 13:45 | Stephens 12:30 John 248-502 8368 [email protected] 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 [email protected] 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