50.1K

Verified Solution

Link Copied!

Chapter 9 Homework #2 Below is a summary of student course enrollment in the School of Management. Please normalize this spreadsheet into third normal form (3NF). Note that, UMID is unique for each student, but there is possibility that some students in the other colleges of UM-Flint may have the same name as students listed below. In other words, you need to be very careful when choosing the primary key for student information table. For your convenience, an Excel file (named "Chapter 9 Homework #2 Spreadsheet") containing the following table is also available on Blackboard. You can submit your answer in an Excel file for this homework. Course Course Name Classroom Days Time Student UMID Major Major Code Phone Number Email ACC201 Financial Accounting 2317 M/W 4:00-5:15 William Baxter 2934745 Accounting ACC 248-502-3030 [email protected] ACC201 Financial Accounting 2317 M/W 4:00-5:15 Sarah Charles 7367793 Accounting ACC 248-502-1038 [email protected] ACC201 Financial Accounting 2317 M/W 4:00-5:15 David Liman 9358862 Management MGT 248-502-8376 [email protected] MGT305 Fundamentals of Management 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 F 8:00-11:00 Sam Whittaker 3079532 Finance FIN 612-226-0986

Answer & Explanation Solved by verified expert

See Answer