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:

I don't know

so sorry

actually I didn't understand the question

Answer 2

Answer:

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