DBMS Assignment 1 SEM 5 NEP Syllabus

 TABLE 1 :

DEPARTMENT (DID PRIMARY KEY ,DNAME, DLOC)

TABLE 2 :

EMPLOYEE  (EID PRIMARY KEY , ENAME,  ADDRESS, SALARY ,DID)

QUERY:

1. Find the name of all Employees.

2. Find the name of all department.

3.  Find the name of all department located in New Delhi.

4. Find the name of all department located in New Delhi or Mumbai.

5. Find the DID  of IT department.

6. Find the EID  of employees.

7. Find the salary of  'Akash'.

8. Find name,address and salary of  Riya. 

9. Find name,address and salary of employee who are from Vizag. 

10. Find the depertment name of Tuhin.

11. Find the department location of Hiya.

12. Find the name of the employee working in Finance department.