CS101 - Introduction To Computing Solution Assignment No 3 Spring 2021

 

Dear Students, Here you can read or download CS101 - Introduction To Computing Assignment No 3 Solution Spring 2021. Previously we shared SOC101 Assignment No 2 Solution Spring 2021. You can also see the File of CS101 Assignment No 3 Solution 2021 provided by Raise For Success. Click on button to Download File and Must Follow our Website and Subscribe our YouTube Channel for latest updates. 

Requirement:

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 (Raise For Success) 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.

Task 1:

Part A

Part B

Part C

Task 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 (Raise For Success) 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.

• Write a query to select the departments with 5 vacancies from the Department table?
• Write a query to select the candidates with a degree of BSIT from the Candidates table?
• Write the query to show all the candidates with no experience from table Candidates?
• Write the query to identify all the posts offered in Lahore from column Location in the Department table?
• Write a query to display all the information under department name and job title from the Department's table?

We can also recommend you to read:

SOC101 Assignment No 2 Solution Spring 2021

MGT101 Assignment No 1 Solution Spring 2021

ENG501 Assignment No 2 Solution Spring 2021

Answer:

Task A:

Part 1: System (Raise For Success) Documentation

Part 2: Technical Documents

Part 3: User (Raise For Success) Documentation

Task B:

• SELECT *FROM Departments WHERE Vacancies =5;
• SELECT *FROM Candidates WHERE Candidates.[Degree]="BS IT";
• SELECT *FROM (Raise For Success) Candidates WHERE Candidates.[ experience]=0;
• SELECT *FROM Departments WHERE Departments. [Location]="Lahore";
• SELECT Departments. [DeptName], Departments. [JobTitle] FROM Departments;
• SELECT Departments. [DeptName], Departments. [Vacancies] FROM Departments;

Download CS101 Assignment No 3 Solution Spring 2021

Click Here