TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
ramesh rammi
NA
86
14k
Is it any row uniquely identify is superkey
Sep 2 2017 8:07 AM
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.
Reply
Answers (
1
)
Interview Question in SQL Queries
Self join on three columns with conditions