Primary key uniquely identify a record in the table. Foreign key is a field in the table that is primary key in another table. ... By default, Primary key is clustered index and data in the database table is physically organized in the sequence of clustered index.
Answers
Answered by
1
Answer:
Explanation:
A DBMS key is an attribute or set of an attribute which helps you to identify a row(tuple) in a relation(table). They allow you to find the relation between two tables. Keys help you uniquely5 identify a row in a table by a combination of one or more columns in that table.
Example:
Employee ID FirstName LastName
11 Andrew Johnson
22 Tom Wood
33 Alex Hale
In the above-given example, employee ID is a primary key because it uniquely identifies an employee record. In this table, no other employee can have the same employee ID.
kindly mark me the brainliest
Similar questions