Assignment: Use the attached Assignment3.xlsx file as an example of a horrible database design. Your task is to create a list of "normalized" tables using "relational notation". You will need to break this example into as many separate tables as you feel is appropriate to remove all modification anomalies. Please submit your relational notations in an ordinary word document along with the sample data. I'm expecting to see both PK and FK notations in your submission.

Note: I'm not asking for a database... I'm asking for a list of tables in relational notation plus the sample data in rows/columns.

Purpose: To demonstrate your understanding of normalization

Part One:

Relational notation for each table/field

Show PK and FK (use Microsoft Word's underline and italics tools)

Part Two:

A "grid" with the all of the rows/column of data for each table after normalization

Note: Just to a "copy-n-paste" from Excel into Word

Assignment3- Protected View- Excel Sign in Home Insert Page Layout Formulas Data Rview View Help Team PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View nable Editing D1 Major RoomNo 3 Gray 3 Gray 3 Gray 3 Gray 201305 CIS452 110 Structured Query Language 110 Structured Query Language 110 Structured Query Language 110 System Analysis and Desi 110 System Analysis and Desi 110 System Analysis and Design 110 Database Th 110 Database Theory and Practice 110 Database Theory and Practice 120 Web Site Development and Design Online 120 Web Site Development and Design Online 120 Web Site Development and Design Online 110 Web Site Development and Desi Face2Face Face2Face Face2Face Online Online CISK401 FH207 TR CISK401 CISK401 FH207TR CISK3OO CISK30O CISK3OO 14.00 14:00 14.00 FH207 TR 4 BA 201305 CIS452 201305 CI5389 201305 CIS389 201305 CI5389 201308 CIS401 201308 CIS401 201308 CIS401 201308 CIS315 201308 CIS315 201308 CIS315 201308 CIS315 96 3 Gray and Practice Face2Face Face2Face Face2Face 3 Gray 3 Gray 19:30 19:30 19:30 CISK3OO FH407 MW 10 BA 1 CIS 12 C 13 CIS 4 CIS CISK300 FH407 MW 42 FH 318H 555-1212 42 FH 318H 555-1212 42 FH 318H 555-1212 666 FH 319A 555-1234 3 Smith 3 Smith H207 MWW 19:30 16 17 20 25 29 Stinking Pile +90% O Type here to search 11:00 AM Aa2/20/2019 Assignment3- Protected View- Excel Sign in Home Insert Page Layout Formulas Data Rview View Help Team PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View nable Editing D1 Major RoomNo 3 Gray 3 Gray 3 Gray 3 Gray 201305 CIS452 110 Structured Query Language 110 Structured Query Language 110 Structured Query Language 110 System Analysis and Desi 110 System Analysis and Desi 110 System Analysis and Design 110 Database Th 110 Database Theory and Practice 110 Database Theory and Practice 120 Web Site Development and Design Online 120 Web Site Development and Design Online 120 Web Site Development and Design Online 110 Web Site Development and Desi Face2Face Face2Face Face2Face Online Online CISK401 FH207 TR CISK401 CISK401 FH207TR CISK3OO CISK30O CISK3OO 14.00 14:00 14.00 FH207 TR 4 BA 201305 CIS452 201305 CI5389 201305 CIS389 201305 CI5389 201308 CIS401 201308 CIS401 201308 CIS401 201308 CIS315 201308 CIS315 201308 CIS315 201308 CIS315 96 3 Gray and Practice Face2Face Face2Face Face2Face 3 Gray 3 Gray 19:30 19:30 19:30 CISK3OO FH407 MW 10 BA 1 CIS 12 C 13 CIS 4 CIS CISK300 FH407 MW 42 FH 318H 555-1212 42 FH 318H 555-1212 42 FH 318H 555-1212 666 FH 319A 555-1234 3 Smith 3 Smith H207 MWW 19:30 16 17 20 25 29 Stinking Pile +90% O Type here to search 11:00 AM Aa2/20/2019