An organization wants to create a database EMPDEPENDENT to maintain following details about its employees and their dependent.
EMPLOYEE (AadharNumber, Name, Address, Department, EmployeeID)
DEPENDENT (EmployeeID, DependentName, Relationship)

/ CS Class 12 Tutorial, Database Concept, IP Class 12 Tutorial, IP Practicals, IT 802 Class 12 Tutorial, NCERT Solutions, RDBMS, SQL Tutorials / By

a) Name the attributes of EMPLOYEE, which can be used as candidate keys.
b) The company wants to retrieve details of dependent of a particular employee. Name the tables and the key which are required to retrieve this detail.
c) What is the degree of EMPLOYEE and DEPENDENT relation?

Ans:
(a) AadharNumber, EmployeeID

(b) To retrieve the details of dependent of a particular employee we need both the tables EMPLOYEE and DEPENDENT and EmployeeID as key.

(c) The degree of EMPLOYEE and DEPENDENT relation is 8.

error: Content is protected !!