Normalize the below table of data. Use a textual representation

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
icon
Related questions
Question

Normalize the below table of data. Use a textual representation.

Attribute Name
StudentID
StudentName
CourselD
CourseName
Grade
Course Date
Sample Value
1
John Smith
2
Programming Level 1
75%
Jan 5th, 2014
Sample Value
2
Sandy Law
2
Programming Level 1
61%
Jan 5th, 2014
Sample Value
3
Sue Rogers
3
Business
81%
Jan 7th, 2014
Transcribed Image Text:Attribute Name StudentID StudentName CourselD CourseName Grade Course Date Sample Value 1 John Smith 2 Programming Level 1 75% Jan 5th, 2014 Sample Value 2 Sandy Law 2 Programming Level 1 61% Jan 5th, 2014 Sample Value 3 Sue Rogers 3 Business 81% Jan 7th, 2014
Expert Solution
Step 1

 

The table of data can be normalized by splitting it into multiple tables. Here are the normalized tables:

Table 1: Students

StudentID StudentName
1 John Smith
2 Sandy Law
3 Sue Rogers

Table 2: Courses

CourseID CourseName
2 Programming Level 1
3 Business

Table 3: Enrollments

EnrollmentID StudentID CourseID Grade CourseDate
1 1 2 75% Jan 5th, 2014
2 2 2 61% Jan 5th, 2014
3 3 3 81% Jan 7th, 2014
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Single Table
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