Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 51 of 91

Relational Database and SQL — Question 12

Back to all questions
12
Question

Question 9

An organization wants to create two tables EMP & DEPENDENT to maintain the following details about its employees and their dependents.

EMPLOYEE(AadhaarNumber, Name, Address, Department, EmployeeID)
DEPENDENT(EmployeeID, DependentName, Relationship)

(a) Name the attributes of EMPLOYEE, which can be used as candidate keys.

(b) The company wants to retrieve details of dependents of a particular employee. Name the tables and the key which are required to retrieve these detail.

(c) What is the degree of EMPLOYEE and DEPENDENT relation?

Answer

(a) In the EMPLOYEE table, the attributes AadharNumber and EmployeeID can be used as candidate keys. This means that either AadharNumber or EmployeeID can uniquely identify each record in the EMPLOYEE table.

(b) The EMPLOYEE and DEPENDENT tables are linked using the EmployeeID key, which is utilized to retrieve details of dependents associated with a specific employee.

(c) In the EMPLOYEE relation, there are five attributes, resulting in a degree of 5. Similarly, the DEPENDENT relation has three attributes, making its degree 3.