CS101 ASSIGNMENT 3 SOLUTION SPRING 2021
Provide by VU Answer
Download Assignment Solution PDF File Below
Question 1:
As you know, documentation helps in understanding the software systems in a better way and due to its’ importance, it is considered a key topic in Software Engineering.
Following are some scenarios (screenshots) of Software Systems related to various document types. You are required to identify the exact documentation type as per the given scenarios. (Just name it, no explanation required)
Solution:
Part A.
System Documentation.
Part B.
Technical Documentation.
Part C.
User Documentation.
Question 2:
XYZ force has announced the new vacancies in their various departments. Many candidates have applied for vacant posts in different departments. Candidates will be selected based on their age, degree, and experience.
Analyze the given tables showing the information of different candidates and departments. You are required to write the queries for given statements.
Part 1.
Write a query to select the departments with 5 vacancies from the Department table.
Solution:
SELECT *FROM Departments WHERE Vacancies = 5;
Part 2.
Write a query to select the candidates with a degree of BSIT from the Candidates table.
Solution:
SELECT *FROM Candidates WHERE Candidates.
[Degree]=”BSIT” ;
Part 3.
Write the query to show all the candidates with no experience from table Candidates.
Solution:
SELECT *FROM Candidates WHERE Candidates.
[Experience]=0;
Part 4.
Write the query to identify all the posts offered in Lahore from column Location in the Department table.
Solution:
SELECT *FROM Department WHERE Departments.
[Location]=”Lahore”;
Part 5.
Write a query to display all the information under department name and job title from the Department's table.
Solution:
SELECT Departments.
[DeptName], Departments.
[JobTitle] FROM Departments;
Part 6.
Write a query to display all the information under department name and vacancies from the Department's table.
Solution:
SELECT Department.
[DeptName], Departments.
[Vacancies] FROM Departments;
PLEASE NOTE:
Don't copy-paste the same answer.
Make sure you can make some changes to your solution file before submitting copy-paste solution will be marked zero.
If you found any mistake then correct yourself and inform me.
Before submitting an assignment check your assignment requirement file.
If you need some help and question about file and solutions.
0 Comments