Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the Difference Between a Primary Key and a Foreign Key.
- 1 Answers
- 1708 Views
- I also Faced
- E-Mail Answers
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
What is denormalization and why would someone consider doing so?
Which software is best for database?
What is actional flow mapping?
What is user and end user?
What is database join?
How to select a random record from a table?
What is super key in dbms?
Define truncate and delete commands?
What is instance in dbms?
What are the two major subsystems of system r?
What methods is used to commit the changes made in DataSet object?
Explain the scenarios or situations under which progress database creates new index entry for a record?
What are the various kinds of interactions catered by dbms?
Explain entity, entity type, and entity set in dbms?
What are procedures in database?
