---
title: Database Systems Lab 3 More Questions
---
<h1 style='border: none'><center>Database Systems Lab 3</center></h1>
<h1 style='border: none'><center>Basic SQL(More Questions)</center></h1>
<h5><center>The Islamic University of Gaza<br>Engineering Faculty<br>Department of Computer Engineering</center></h5>
<h6>Authors: Usama R. Al Zayan & Rasha E. Kahil<span style="float:right">2023/02/07</span></h6>

---

### More Questions

1. Create a table: secretaries (id, name, dept_name, salary), your primary key field have to be generated and incremented automatically when a new record is inserted into the table.
Test your work by inserting data to the created table (3 rows).
On our **uni-largeSpace** schema execute quires to find the following. Include both your query and the results in your lab report.
2. Find names of all students who have not taken any Computer Science course. (Should be no duplicate names).
3. Find names of all departments that have at least one Design course, whose title starts or ends with “Design”.
4. Increase the budget of the departments that has the minimum budget by 35%.
5. Delete all students who get ‘F’ grade in all courses they have taken.
6. Find the number of distinct enrollments across “Elec. Eng.” sections, in spring semesters.
7. Find the instructor who earn the 15th highest salary.
8. Display the names of all instructors who taught for 3 consecutive years in any time period.
9. Create your own query: define what you want to do in English, then write the query in SQL. Make it as difficult as you wish, the harder the better.

## Bonus
1. Display the names of all instructors who taught for 2 consecutive semesters in any time period.
2. Insert every student, who has finished at least 130 credits with grade of ‘A+’ in more than 80% of his courses, as an instructor in the “Outstanding” department, with a salary of $14,000.

###### tags: `Database Systems` `IUG` `Computer Engineering`

<center>End Of Lab 3</center>