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.

c) What is the degree of EMPLOYEE and DEPENDENT relation​

Answer 1

Answer:

☺☺☺☺☺☺☺☺☺☺☺কদকহচরসগকতকতগর ককরককরকলকরকপকরতর করতরকরকল ককরকরকপ ক