CS101-Assignment 3 Solution Spring 2021 Due date 02-Aug-2021
Question No
1
Part a
Solution
System Documentation
Part b
Solution
Technical Documents
Part c
Solution
User Documentation
Question No 2
Requirement 1 1.
Write a query to select the
departmentswith5vacanciesfromtheDepartmenttable.
Solution
SELECT *FROM Departments WHERE Vacancies =5;
Requirement 2 2.
WriteaquerytoselectthecandidateswithadegreeofBSITfromtheCandidates
table.
Solution
SELECT *FROM Candidates WHERE Candidates.[Degree]="BS
IT";
Requirement 3 3.
Writethequerytoshowallthecandidateswithnoexperiencefromtable
Candidates.
Solution
SELECT *FROM
Candidates WHERE Candidates.[ experience]=0;
Requirement 4 4.
Write the query to
identify all the posts offered in Lahore from column Location in the Department
table.
Solution
SELECT *FROM
Departments WHERE Departments. [Location]="Lahore";
Requirement 5 5.
Write a query to
display all the information under department name and job title from the
Department'stable.
Solution
SELECT Departments.
[DeptName], Departments. [JobTitle] FROM Departments;
Requirement 6 6.
Write a query to
display all the information under department name and vacancies from the
Department'stable.
Solution
SELECT Departments.
[DeptName], Departments. [Vacancies] FROM Departments;