Scribd
Upload
2 views4 pages

CSE Faculty and Student Data Queries

The document outlines various database queries related to the faculties and students of the CSE Department and Master of Computer Application department. It includes tasks such as finding faculty names, counting faculty members, displaying department heads, and filtering students based on specific criteria. Additionally, it addresses modifications to the faculty table and queries regarding salary ranges and department sizes.

Uploaded by

archak.nath.useless
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
2 views4 pages

CSE Faculty and Student Data Queries

The document outlines various database queries related to the faculties and students of the CSE Department and Master of Computer Application department. It includes tasks such as finding faculty names, counting faculty members, displaying department heads, and filtering students based on specific criteria. Additionally, it addresses modifications to the faculty table and queries regarding salary ranges and department sizes.

Uploaded by

archak.nath.useless
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

1. Find the names of faculties of CSE Department.

2. Find the number of faculties in the Master of Computer Application department

3. Show the names of the heads of departments with department name.


4. Find the names of 3rd year CSE students whose date of birth is earlier than 15th
August 1981.

5. Find the number of faculties who joined in August.

6. Add an extra attribute to the faculty table - Salary Number(8,2)


7. Insert values into the corresponding field Salary Number(8,2) (Enter distinct
values).

8. Find the Department having more than one faculty.

9.
9.
9.
9.
Find the name, department of the faculties who earn between 8000 and 12000.
10. Find the department having maximum number of students or faculties

11. Display the details of HOD of the department where ‘[Link]’ belongs.

You might also like