Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
5.8k views
in Information Technology by (72.4k points)

Consider the following table:

Employee

EmpNo EmpName Designation
1 Sahil A
2 Anup B
3 Mansi A
4 Pooja B

1. Which of the above field can be selected as a primary key?

2. EmpName field also has unique values for all the records. Can it be made primary key? Give answer with reason.

1 Answer

0 votes
by (89.4k points)
selected by
 
Best answer

1. EmpNo can be selected as a primary key. 

2. EmpName is having unique values, but there is no guarantee that if more employees are included then there would not be multiple people with similar names. 

So, in future, its values may be duplicate. Thus, it cannot be made as a primary key.

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...