Provide the relation (relational notation) that represents the user view for the school advising system. b. Transform the user view into the third normal form. Show the intermediate steps in the normalization process, i.e. 1NF, 2NF, 3N
Provide the relation (relational notation) that represents the user view for the school advising system. b. Transform the user view into the third normal form. Show the intermediate steps in the normalization process, i.e. 1NF, 2NF, 3N
Principles of Information Systems (MindTap Course List)
12th Edition
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter11: Knowledge Management And Specialized Information Systems
Section: Chapter Questions
Problem 18SAT
Related questions
Question
a. Provide the relation (relational notation) that represents the user view for the school advising system.
b. Transform the user view into the third normal form. Show the intermediate steps in the normalization process, i.e. 1NF, 2NF, 3NF.
![STUDENT
STUDENT-
NUMBER
ADVISOR-
NUM-
CREDITS GRADE
STUDENT-
TOTAL-
ADVISOR-
NAME
COURSE-
NAME
CREDITS
GPA
NUMBER
NUMBER
COURSE-DESC
Computer Science I
Marketing Management
English Composition
General Chemistry I
1035
Linda
47
3.647
49
Smith
CSC151
4
MKT212
ENG101
3
CHM112
BUS105
4
Introduction to Business
2
English Composition
Marketing Management
Computer Science I
3397
Sam
29
3.000
49
Smith
ENG101
A
3
3
МКT212
CSC151
Computer Science I
General Chemistry I
English Composition
Introduction to Business
4070
Kelly
14
2.214
23
Jones
CSC151
4
CHM112
4
ENG101
BUS105
3
2
BABAA
BCCC](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F0a466f0b-57d3-4c1a-aee6-8a6511628705%2Fa5df4600-0b0a-4dbb-8de4-041801e72624%2Feghorvb_processed.png&w=3840&q=75)
Transcribed Image Text:STUDENT
STUDENT-
NUMBER
ADVISOR-
NUM-
CREDITS GRADE
STUDENT-
TOTAL-
ADVISOR-
NAME
COURSE-
NAME
CREDITS
GPA
NUMBER
NUMBER
COURSE-DESC
Computer Science I
Marketing Management
English Composition
General Chemistry I
1035
Linda
47
3.647
49
Smith
CSC151
4
MKT212
ENG101
3
CHM112
BUS105
4
Introduction to Business
2
English Composition
Marketing Management
Computer Science I
3397
Sam
29
3.000
49
Smith
ENG101
A
3
3
МКT212
CSC151
Computer Science I
General Chemistry I
English Composition
Introduction to Business
4070
Kelly
14
2.214
23
Jones
CSC151
4
CHM112
4
ENG101
BUS105
3
2
BABAA
BCCC
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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.Recommended textbooks for you
![Principles of Information Systems (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781285867168/9781285867168_smallCoverImage.gif)
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
![Fundamentals of Information Systems](https://www.bartleby.com/isbn_cover_images/9781305082168/9781305082168_smallCoverImage.gif)
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
![Principles of Information Systems (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781305971776/9781305971776_smallCoverImage.gif)
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
![Principles of Information Systems (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781285867168/9781285867168_smallCoverImage.gif)
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
![Fundamentals of Information Systems](https://www.bartleby.com/isbn_cover_images/9781305082168/9781305082168_smallCoverImage.gif)
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
![Principles of Information Systems (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781305971776/9781305971776_smallCoverImage.gif)
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)