Explanation:
Both Primary Key and Candidate Key are the attributes that are used to access tuples from a table. These (Primary key and Candidate key) are also can be used to create a relationship between two tables.
- A Candidate Key can be any column or a combination of columns that can qualify as a unique key in the database. Each Candidate Key can qualify as a Primary Key.
- A Primary Key is a column or a combination of columns that uniquely identify a record. The primary key is a minimal super key, so there is one and only one primary key in any relationship.
<em> The main difference between them is that a primary key is unique but there can be many candidate keys. </em>
I hope you find this information useful and interesting! Good luck!
A fax cover sheet is the first sheet that gives all the information that is needed.
To organize your data in a list of rows and coloums. (Table, Graph)
