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 "text-based relational notation" plus the sample data in rows/columns. This technique was demonstrated in lecture Note: I picked a topic that you should already be familiar with... So, it'd be a good idea to look at how the University Catalog and Semester Schedules uses data. You can't just look at the sample data... you'll also need to know things like "is a course always taught by the same professor, in the same room, at the same time?" Purpose: To demonstrate your understanding of normalization and splitting tables Requirements: 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 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 Did you use "text-based relational notation" (10%) Did you normalize the tables with minimal column duplication (20%) Did you create at least 5 (or 6) tables (5%) Did you assign columns to the correct tables (and have no left over columns) (10%) Did you pick the correct columns for the PK and compound PK (15%) Did you pick the correct columns for the FK and compound FK (15%) Did you address the N:M issue and create an intersection table (10%) Did you include a "grid" for each table with the supplied data (10%) Did you remove the duplicate rows from the grids (5%)

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 "text-based relational notation" plus the sample data in rows/columns. This technique was demonstrated in lecture Note: I picked a topic that you should already be familiar with... So, it'd be a good idea to look at how the University Catalog and Semester Schedules uses data. You can't just look at the sample data... you'll also need to know things like "is a course always taught by the same professor, in the same room, at the same time?" Purpose: To demonstrate your understanding of normalization and splitting tables Requirements: 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 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 Did you use "text-based relational notation" (10%) Did you normalize the tables with minimal column duplication (20%) Did you create at least 5 (or 6) tables (5%) Did you assign columns to the correct tables (and have no left over columns) (10%) Did you pick the correct columns for the PK and compound PK (15%) Did you pick the correct columns for the FK and compound FK (15%) Did you address the N:M issue and create an intersection table (10%) Did you include a "grid" for each table with the supplied data (10%) Did you remove the duplicate rows from the grids (5%)

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

Note: I'm not asking for a database... I'm asking for a list of tables in "text-based relational notation" plus the sample data in rows/columns. This technique was demonstrated in lecture

Note: I picked a topic that you should already be familiar with... So, it'd be a good idea to look at how the University Catalog and Semester Schedules uses data. You can't just look at the sample data... you'll also need to know things like "is a course always taught by the same professor, in the same room, at the same time?"

Purpose: To demonstrate your understanding of normalization and splitting tables

Requirements:

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

Did you use "text-based relational notation" (10%)
Did you normalize the tables with minimal column duplication (20%)
Did you create at least 5 (or 6) tables (5%)
Did you assign columns to the correct tables (and have no left over columns) (10%)
Did you pick the correct columns for the PK and compound PK (15%)
Did you pick the correct columns for the FK and compound FK (15%)
Did you address the N:M issue and create an intersection table (10%)
Did you include a "grid" for each table with the supplied data (10%)
Did you remove the duplicate rows from the grids (5%)

PrimaryMajor
StudentID FirstName LastName PrimaryMajor
8888 Charles
9999 Joe
1234 John
1234 John
1234 John
7777 Arthur
3333 William
1234 John
5555 Richard
6666 Carroll
2222 Tony
1234 John
3456 David
Albright
Ball
Smith
Smith
Smith
Bishop
Bonin
Smith
Chase
Cole
Costa
Smith
Carpenter
BIOL
BA
CIS
CIS
CIS
CJ
CIS
CIS
CJ
CIS
CIS
CIS
BA
Semester CourselD ProfName Section
202001 CIS3315 Gray
202001 CIS3315
202001 CIS4301
202001 CIS4352
202006 CIS3365
202006 CIS4352
202006 CIS4352
202008 CIS3315
202008 CIS3315
202008 CIS3315
202008 CIS3315
202008 CIS4301
202008 CIS4301
Gray
Gray
Gray
Smith
Smith
Gray
Gray
Smith
Smith
Smith
Jones
Jones
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
3 FH323Q
3 FH323Q
3 FH323Q
3 FH323Q
3 FH323A
3 FH318H
ClassType Room No Days StartTime Quiz1Grade Quiz2Grade Quiz3Grade ProfessorID CreditHours ProfOffice ProfPhone
Face2Face FH307 MW
Face2Face FH307
MW
Online
Face2Face FH308
Online
Face2Face FH207
Face2Face FH207
Online
Face2Face FH207 TR
Face2Face FH207 MW
Face2Face FH207 MW
Face2Face FH407 MW
Face2Face FH407 MW
3 FH323Q
3 FH323Q
3 FH318H
MW
TR
MW
14:00
14:00
16:30
14:00
11:00
16:30
19:30
19:30
19:30
19:30
77
78
82
95
89
90
78
72
81
97
45
69
81
96
95
88
82
93
78
73
78
70
82
97
78
75
80
77
85
77
90
74
73
83
12
12
12
12
42
13
12
12
13
13
13
14
14
3 FH318H
BFH318H
3
3
PreReq
12 Hours
CIS4301
555-1234 CIS333x
555-1212 CIS4301
CIS4301
555-1212
555-1212
555-1212
12 Hours
12 Hours

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.