Relationship of the student you have to normalized. Do fast neeed in 15 min Please

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

Relationship of the student you have to normalized. Do fast neeed in 15 min

Please

The following table depicts the set of attributes found in a database: An un-normalized relation of
Student_in_Society is given below:
Student ID -> STID
Student Name -> StdName
Society ID -> SocID
Society Name -> SocName
Supervisor ID -> SupID
STID StdName SocID
Masood 001
003
Khalida 001
002
005
008
SupID
1
2
1
1
3
4
SocName
Supervisor
Mr. Waseem
Position
123
Urdu
Chairman
Maths
Ms.Chauhdry
Member
132
Urdu
Mr. Waseem
Member
142
Javed
English
Physics
Biology
Mr.
Member
Waseem
Chairman
Mr. Liaqat
Member
Miss Yasmeen
Normalize the above relation of student_in_society upto 3rd NF.
Transcribed Image Text:The following table depicts the set of attributes found in a database: An un-normalized relation of Student_in_Society is given below: Student ID -> STID Student Name -> StdName Society ID -> SocID Society Name -> SocName Supervisor ID -> SupID STID StdName SocID Masood 001 003 Khalida 001 002 005 008 SupID 1 2 1 1 3 4 SocName Supervisor Mr. Waseem Position 123 Urdu Chairman Maths Ms.Chauhdry Member 132 Urdu Mr. Waseem Member 142 Javed English Physics Biology Mr. Member Waseem Chairman Mr. Liaqat Member Miss Yasmeen Normalize the above relation of student_in_society upto 3rd NF.
Expert Solution
steps

Step by step

Solved in 3 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