Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
Is it any row uniquely identify is superkey
ramesh rammi
Sep 2 2017 8:07 AM
203
Reply
I have doubt on superkey that is any combination of fields is uniquely identify the
each row or any row
in table.
must be each row uniquely identify or any row uniquely identify is superkey
Have a look at
Superkey - Wikipedia
[
^
]
Monarch Name
Monarch Number
Royal House
Edward
II
Plantagenet
Edward
III
Plantagenet
Richard
III
Plantagenet
Henry
IV
Lancaster
superkeys:
• {}
• {Monarch Name}
• {Monarch Number}
• {Royal House}
• {Monarch Name, Monarch Number}
• {Monarch Name, Royal House}
• {Monarch Number, Royal House}
• {Monarch Name, Monarch Number, Royal House}
according to above example i have doubt on uniquely identify each row or any row is super key.
this example contain in wikipedia site. once check it please
please help me.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
Interview Question in SQL Queries
Self join on three columns with conditions