Question

An organization ABC maintains a database EMPDEPENDENT to record the following details about its
employees and their dependents.
EMPLOYEE(AadhaarNo, Name, Address, Department,
EmpID)
DEPENDENT(EmpID, DependentName, Relationship)
Use the EMP-DEPENDENT database to answer the following
SQL queries:
a) Find the names of employees with their dependent
names.
b) Find employee details working in a department, say,
‘PRODUCTION’.
c) Find employee names having no dependent
d) Find names of employees working in a department,
say, ‘SALES’ and having exactly two dependents.

Answer 1

Answer:

4111111111111111111111111111111111111111111111111111111

Explanation: