Your task is to break this up into a list of "normalized" tables that you describe using the text-based "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 in a "grid". 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. Part One:Use text-based relational notation to describe each table/fieldNote: I am not yet requiring you to solve the "multi-column" problemShow PK and FK (use Microsoft Word's underline and italics tools)Part Two: Create a "grid" for each table with the all of the rows/columns of data for that table after normalization (to include PKs/FKs)Make sure you don't have any duplicate rows in your "grid"Note: You can just do a "copy-n-paste" from Excel into Word StudentiD FirstName LastName PrimaryMajor Semester CourselD202001 CIS3315ProfName sectionClassType RoomNo Days StartTime Quiz1Grade Quiz2Grade Quiz3Grade ProfessoriD CreditHours Profoffice ProfPhoneFace2Face FH307Face2Face FH307PreRegDescription110 Web Site Development and Design110 web site Development and Design110 Database Theory and Practice110 Structured Query Language110 system Analysis and Design110 Structured Query Language120 Structured Query Language110 web Site Development and Design120 Web Site Development and Design130 web Site Development and Design130 Web Site Development and Design110 Database Theory and Practice110 Database Theory and Practice8888 CharlesAlbrightBallSmithSmithSmithBishopBoninSmithChaseColeCostaSmithMATHGrayMWMW779778751212121242131214:00813 FH323Q202001 CIS3315GrayGray14:003 FH323Q9999|Joe1234|John789695BACISCISCISCJCIS202001 CIS4301202001 CIS4352202006 CISS365202006 CIS4352OnlineFace2Face PHS0Blonline3 FH323Q3FH323Q3PH323R3PH318H3PH323Q3lFH323Q3FH318H3FH318H3FH318H821234 John1234 John12 HoursCI54301CI5333xMW16:30958988GraySmith80778582555-1234SmithFace2Face PH207Face2Face FH207OnlineFace2Face FH207Face2Face PH207Face2Face FH207Face2Face FH407Face2Face FH4077777 Arthur3335 william1234|JohnTRMW14:0090787293555-1212CI54301202006 CIS4352Gray14:00CI5430178737790121313131414CIS202008 CIS3315GraySmithTR5555 Richard6666 Carroll2222 Tony1234 John3456 David20200s CIS331516:30555-1212555-1212555-1212CISCISCISBA202008 CIS3315202008 CIS3315202008 CIS4301 Jones202008 CIS4301SmithMWIMW819719:3074Smith19:3019:3019:3078MWMW45707312 HoursCaгрenter828312 HoursJones69

Part One: Table Name Student Course Professor Data field Student: StudentID Firstname LastName…

Answered: Your task is to break this up into a…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Your task is to break this up into a list of "normalized" tables that you describe using the text-based "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 in a "grid". 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.

Part One:
- Use text-based relational notation to describe each table/field
- Note: I am not yet requiring you to solve the "multi-column" problem
- Show PK and FK (use Microsoft Word's underline and italics tools)
Part Two:
- Create a "grid" for each table with the all of the rows/columns of data for that table after normalization (to include PKs/FKs)
- Make sure you don't have any duplicate rows in your "grid"
- Note: You can just do a "copy-n-paste" from Excel into Word

StudentiD FirstName LastName PrimaryMajor Semester CourselD
202001 CIS3315
ProfName section
ClassType RoomNo Days StartTime Quiz1Grade Quiz2Grade Quiz3Grade ProfessoriD CreditHours Profoffice ProfPhone
Face2Face FH307
Face2Face FH307
PreReg
Description
110 Web Site Development and Design
110 web site Development and Design
110 Database Theory and Practice
110 Structured Query Language
110 system Analysis and Design
110 Structured Query Language
120 Structured Query Language
110 web Site Development and Design
120 Web Site Development and Design
130 web Site Development and Design
130 Web Site Development and Design
110 Database Theory and Practice
110 Database Theory and Practice
8888 Charles
Albright
Ball
Smith
Smith
Smith
Bishop
Bonin
Smith
Chase
Cole
Costa
Smith
MATH
Gray
MW
MW
77
97
78
75
12
12
12
12
42
13
12
14:00
81
3 FH323Q
202001 CIS3315
Gray
Gray
14:00
3 FH323Q
9999|Joe
1234|John
78
96
95
BA
CIS
CIS
CIS
CJ
CIS
202001 CIS4301
202001 CIS4352
202006 CISS365
202006 CIS4352
Online
Face2Face PHS0B
lonline
3 FH323Q
3FH323Q
3PH323R
3PH318H
3PH323Q
3lFH323Q
3FH318H
3FH318H
3FH318H
82
1234 John
1234 John
12 Hours
CI54301
CI5333x
MW
16:30
95
89
88
Gray
Smith
80
77
85
82
555-1234
Smith
Face2Face PH207
Face2Face FH207
Online
Face2Face FH207
Face2Face PH207
Face2Face FH207
Face2Face FH407
Face2Face FH407
7777 Arthur
3335 william
1234|John
TR
MW
14:00
90
78
72
93
555-1212
CI54301
202006 CIS4352
Gray
14:00
CI54301
78
73
77
90
12
13
13
13
14
14
CIS
202008 CIS3315
Gray
Smith
TR
5555 Richard
6666 Carroll
2222 Tony
1234 John
3456 David
20200s CIS3315
16:30
555-1212
555-1212
555-1212
CIS
CIS
CIS
BA
202008 CIS3315
202008 CIS3315
202008 CIS4301 Jones
202008 CIS4301
Smith
MW
IMW
81
97
19:30
74
Smith
19:30
19:30
19:30
78
MW
MW
45
70
73
12 Hours
Caгрenter
82
83
12 Hours
Jones
69

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions