Introduction to Computing (CS101) Assignment # 03 Spring
 2021

Question No. 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.

Part (A) System Documentation
 

Problem Statement:

Using Clips clear command actually does more than just remove facts. Besides removing all the facts, (clear) also remove all the rules.

Solution:

CLIPS> (Facts)

f-0 (initial-facts)

f-1 (duck)

f-2 (quack)

For a total of 3 facts.

CLIPS> (clear)

CLIPS>

-          CLIPS> (clear)

-          CLIPS> (assert (a)(b)(c))

System Documentation

Class Diagram (taken from “The Unified Modelling Language User Guide” Brooch - 2E)

 

 

 

Part (B)

A software system should be installed and serviced.

A software system should be installed and serviced.

SAP Server-based Installation (taken from Official Website SAP.com)

 

 

 

Part (C)

It is intended to be read by the user of the software and is therefore expressed in the terminology of the application.

 

Question No: 1

Ans:

A

System Documentation

B

Technical Documentation

C

User Documentation

 

Question No.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.

Analyse the given tables showing the information of different candidates and departments. You are required to write the queries for given statements.

 

 

the new vacancies in their various departments

 

1.    Write a query to select the department with 5 vacancies from the department table.

Ans:

Select DeptName from departments where Vacancies = 5;

2.    Write a query to select the candidates with a degree of BSIT from the Candidates table.

Ans:

Select FirstName from Candidates where Degree = ‘BSIT’;

3.    Write the query to show all the candidates with no experience from table candidates.

Ans:

Select FirstName From Candidates where experience = 0

4. Write the query to identify all the posts offered in Lahore from column Location in the Department table.

Ans:

Select JobTittle From Departments where Location = ‘Lahore’;

 

5.    Write a query to display all the information under department name and job title from the Department's table.

Ans:

Select DeptName, JobTittle From Departments;

 

6.    Write a query to display all the information under department name and vacancies from the Department's table.

Ans:

Select DeptName, Vacancies From Departments;