Question 1 - Past Year - 1 Mark Questions - Chapter 8 - Database Concepts

Last updated at April 16, 2024 by Teachoo

What is primary key?

Answer:

Primary key is a set of one or more attributes which can uniquely identify each tuple of a relation.

Example:

Employee_id	Employee_name	Department
101	Ravi Kumar	Sales
102	Tarun A	IT
103	Jennifer Davis	HR
104	Martin Woods	HR
105	Ron Romy	IT

In the Employee table, the Employee_id of all employees are different . So it can be used to uniquely identify each employee and hence, we set Employee_id as the primary key.

Additional points:

A relation can have only 1 primary key.
A primary key can consist of single or multiple columns.
Primary keys must contain unique values.
Primary keys cannot contain NULL values.

Next: Question 2 Important → Go Ad-free

Transcript

What is primary key? Answer: Primary key is a set of one or more attributes which can uniquely identify each tuple of a relation. Example: Employee_id Employee_name Department 101 Ravi Kumar Sales 102 Tarun A IT 103 Jennifer Davis HR 104 Martin Woods HR 105 Ron Romy IT In the Employee table, the Employee_id of all employees are different. So it can be used to uniquely identify each employee and hence, we set Employee_id as the primary key. Additional points: A relation can have only 1 primary key. A primary key can consist of single or multiple columns. Primary keys must contain unique values. Primary keys cannot contain NULL values.

Made by

Davneet Singh

Davneet Singh has done his B.Tech from Indian Institute of Technology, Kanpur. He has been teaching from the past 14 years. He provides courses for Maths, Science and Computer Science at Teachoo

Class 6

Class 7

Class 8

Class 9

Class 10

Class 11

Class 12

Courses

Interesting

Popular