Interested to Buy Any Domain ? << Click Here >> for more details...
what is primary key,unique key, foreign key? can u teach me
in simple language?
- 44 Answers
- 189128 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
Answer Posted / teju
PRIMARY KEY :
IN THE TABLE we can find only one record as
uniqely & also it is not null.
unique key:
uk is to search any record as uniquely& when it
is declared it should be only one null values.
Fk:
fk is to maintain the relations bet two tables
as an duplicate values.means to not null.
e.g
1> stud(stud_id,stud_name);
2> stud_det(stud_id,addr);
In this table stud_id is an pk & In the stud_det as
stud_id is used as an duplicate.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
i have windows-xp processor with P4 system. whenever I tried to download foxpro for windows 2.6 on windows XP, my operating system failed to install foxpro for windows 2.6.please. how could i download , install & run foxpro for windows 2.6 easily on windows XP ?
Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.
Why merge statement is used inside the database?
how can you perform lookup range in lookup stage expalin in detail?
How default key is different from primary key?
WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?
Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?
What is ole db source in ssis?
Explain phantom deadlock?
What is odm database?
WHAT IS CARDINALITIES OF JOIN?
Can a database table exist without a primary key?
What are indexes in oracle?
During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
hai if any one having any project sample table structure please froward to my mail id tauseefwst@yahoo.com
