what is primary key,unique key, foreign key? can u teach me
in simple language?
- 44 Answers
- 174606 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sandeep beniwal (master)
Primary key:- Primary key means main key. A primary key is
one which uniquely identifies of a table. Prrimay key does
not allow null values and duplicate values.
e.g:
empno empname status
10 dipender active
20 nisha inactive
30 vikas active
40 naveen active
Pimary key not like this:
10 dipender active
20 nisha inactive
30 vikas active
naveen active ........ (duplicate value)
Unique key:-A unique is one which uniquely identifies a row
of a table, but there is a difference like it will allow
only one duplicate values (In sql).
Both will function in a similar way but a slight difference
will be there. So, decalaring it as a primary key is the
best one.
foreign key:- a foreign key is one which will refer to a
primary key of another table and helps making link
e.g
employee_table user_table
empID empname status userID userID empname
10 dipender active 1 1 dipender
20 nisha inactive 2 2 nisha
30 vikas active 3 3 vikas
40 naveen active 4 4 naveen
In the above relation, userID is there in employee_table
which
is a primary key of user_table. that means, userID is
refering the user_table.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is the function of cluster index?
Can you tell any two advantages of stored procedures?
What are the types of indexes that are present inside a database?
What are different types of resources?
Is data lake a database?
Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?
i applied prompt on country when i run report it shows list of all countries but want it to show only four countries name
can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?
Which database is best to store images?
What is the purpose of firebase?
Explain database partitioning. What is its importance?
Explain storage manager?
define primary key index, bitmap index, hash index,virtual indwx
A design problem was given in which I was supposed to make a design for the data base for a given problem.
I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage
