Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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.

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.

Database System Concepts
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
icon
Related questions
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
Transcribed Image Text: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

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
SQL Query
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS