Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 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.

Course

Course Name

Classroom

Days

Time

Student

UMID

Major

Major Code

Phone Number

Email

ACC201

Financial Accoutning

2317

M/W

4:00-5:15

William Baxter

2934745

Accounting

ACC

248-502-3030

wbax@umflint.edu

ACC201

Financial Accoutning

2317

M/W

4:00-5:15

Sarah Charles

7367793

Accounting

ACC

248-502-1038

scha@umflint.edu

ACC201

Financial Accoutning

2317

M/W

4:00-5:15

David Liman

9358862

Management

MGT

248-502-8376

dlim@umflint.edu

MGT305

Fundamentals

of Management

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

F

8:00-11:00

Sam Whittaker

3079532

Finance

FIN

612-226-0986

swhi@umflint.edu

BUS332

Business Communications

2340

F

8:00-11:00

Amanda Leung

3567768

Marketing

MKT

248-502-7259

aleu@umflint.edu

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

SQL Server T-SQL Recipes

Authors: David Dye, Jason Brimhall

4th Edition

1484200616, 9781484200612

More Books

Students also viewed these Databases questions

Question

7. It is advisable to do favors for people whenever possible.

Answered: 1 week ago

Question

9. Power and politics can be destructive forces in organizations.

Answered: 1 week ago