Using the STUDENT table structure shown below, normalize the table to BCNF. ample STUDENT Records Attribute Name Sample Value Sample Value Sample Value Sample Value 199877 STU NUM 211343 200128 199876 STU_LNAME Stephanos Smith Jones Ortiz STU_MAJOR Accounting Accounting Marketing Marketing DEPT_CODE ACCT ACCT MKTG MKTG Marketing DEPT_NAME Accounting Accounting Marketing DEPT_PHONE 4356 4356 4378 4378 COLLEGE_NAME Business Admin Business Admin Business Admin Business Admin ADVISOR_LNAME Grastrand Grastrand Gentry Tillery ADVISOR_OFFICE T201 T201 T228 T356 ADVISOR_BLDG Torre Building Torre Building Torre Building Torre Building ADVISOR_PHONE 2115 2115 2123 2159 STU_GPA 3.87 2.78 2.31 3.45 STU_HOURS 75 45 117 113 STU_CLASS Junior Sophomore Senior Senior Sample Value 223456 McKulski Statistics MATH Mathematics 3420 Arts & Sciences Chen J331 Jones Building 3209 3.58 87 Junior

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
Using the STUDENT table structure shown below, normalize the table to BCNF.
Sample STUDENT Records
Attribute Name
Sample Value Sample Value
Sample Value
199876
Sample Value
199877
STU_NUM
211343
200128
STU_LNAME
Stephanos
Smith
Jones
Ortiz
STU_MAJOR
Accounting
Accounting
Marketing
Marketing
DEPT_CODE
ACCT
ACCT
MKTG
MKTG
DEPT_NAME
Accounting
Accounting
Marketing
Marketing
DEPT_PHONE
4356
4356
4378
4378
COLLEGE_NAME
Business Admin
Business Admin
Business Admin
Business Admin
ADVISOR_LNAME Grastrand
Grastrand
Gentry
Tillery
ADVISOR_OFFICE T201
T201
T228
T356
ADVISOR_BLDG
Torre Building
Torre Building
Torre Building
Torre Building
ADVISOR_PHONE
2115
2115
2123
2159
STU_GPA
3.87
2.78
2.31
3.45
STU_HOURS
75
45
117
113
STU_CLASS
Junior
Sophomore
Senior
Senior
Sample Value
223456
McKulski
Statistics
MATH
Mathematics
3420
Arts & Sciences
Chen
J331
Jones Building
3209
3.58
87
Junior
Transcribed Image Text:Using the STUDENT table structure shown below, normalize the table to BCNF. Sample STUDENT Records Attribute Name Sample Value Sample Value Sample Value 199876 Sample Value 199877 STU_NUM 211343 200128 STU_LNAME Stephanos Smith Jones Ortiz STU_MAJOR Accounting Accounting Marketing Marketing DEPT_CODE ACCT ACCT MKTG MKTG DEPT_NAME Accounting Accounting Marketing Marketing DEPT_PHONE 4356 4356 4378 4378 COLLEGE_NAME Business Admin Business Admin Business Admin Business Admin ADVISOR_LNAME Grastrand Grastrand Gentry Tillery ADVISOR_OFFICE T201 T201 T228 T356 ADVISOR_BLDG Torre Building Torre Building Torre Building Torre Building ADVISOR_PHONE 2115 2115 2123 2159 STU_GPA 3.87 2.78 2.31 3.45 STU_HOURS 75 45 117 113 STU_CLASS Junior Sophomore Senior Senior Sample Value 223456 McKulski Statistics MATH Mathematics 3420 Arts & Sciences Chen J331 Jones Building 3209 3.58 87 Junior
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY