Question

An organisation 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)
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.​

Answer 1

Explanation:

dGBCfgSsTDyBN-DKF9DTkX:APA91bHI5fbQhGGnRbWGaeWstEJZsMLTaRX34m9VKtQalqTiOSWQVKfhtJk58ZPK84lrT75Szhyeu4u4u4u47474u383u3hwhhehe8qyZ8tODyxZ18yCVuNW3_E_J3i0c9I11GTAchI3OUyT0-VPQzCihOvPVdFw3j76-CK8