What is difference b/w composit key n primary key and
forigion key?

Answer Posted / reem

A primary key is a column which uniquely identifies the
records in a table.

A foreign key is a column (the child collumn) in a table
which has a corresponding relationship and a dependency on
another collumn (the parent collumn) that is usually in a
different table.

comosit key is more than one attribute can used as aprimary
key

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the password of mysql?

475


What you can use regular expression for in mysql? Support your answer with an example?

487


How do I declare a variable in mysql?

480


Explain the different types of constraints?

522


Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?

4213






What is mysql cursor?

508


Why we use mongodb instead of mysql?

488


What is difference between Sql server and MySql database? It may be silly question but i really dont know.

1556


How do I disconnect mysql workbench?

540


How do I create a database in mysql workbench?

447


Is number a datatype in mysql?

490


What is a mysql server?

521


What is the phantom problem?

501


How many threads can mysql handle?

506


How many primary keys can be there in a table?

537