Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Explain the Difference Between a Primary Key and a Foreign Key.

Answer Posted / hr@tgksolutions.com

Each record in a table is uniquely identified by its primary key, which also guarantees data integrity. There can only be one primary key per table, which guarantees that every record is distinct.
Conversely, a foreign key refers to the primary key in the associated table to establish a connection between two tables. By guaranteeing the validity of the link between the tables and the consistency of the data, this relationship aids in preserving referential integrity between them.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

explain about the critical recovery scenario you had experienced

2188


What is the sql 'in' clause?

929


What is query in rdbms?

917


What does clipper stand for?

979


Define dml compiler.

1008


How to prevent firebird.log file from filling up the disk partition?

909


What are the steps to follow when preparing to create a table?

874


Can I use google sheets as a database?

947


What is database join?

872


What do you understand by cursor?

924


What is maintaining database?

881


What is database host?

905


Explain environment of openedge?

920


What is 3 level architecture dbms?

962


What are the database skills?

941