CS101 Assignment 3 Solution
Open Date: 26 July 2021 Close Date: 02 Aug 2021
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)
Part (A)
Class Diagram (taken from“The UnifiedModelling Language User Guide” Booch- 2E)
Answer: System Documentation
Part (B)
SAP Server-based Installation (taken from Official Website SAP.com)
Answer: Technical Documents
Part (C)
Microsoft Windows 10 Help
Answer: User Documentation
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.
Write a query to select the departments with 5 vacancies from the Department table.
SELECT *FROM Departments WHERE Vacancies =5;
Write a query to select the candidates with a degree of BSIT from the Candidates table.
SELECT *FROM Candidates WHERE Candidates.[Degree]="BS IT";
Write the query to show all the candidates with no experience from table Candidates.
SELECT *FROM Candidates WHERE Candidates.[ experience]=0;
Write the query to identify all the posts offered in Lahore from column Location
in the Department table.
SELECT *FROM Departments WHERE Departments. [Location]="Lahore";
Write a query to display all the information under department name and job title from the Department's table.
SELECT Departments. [DeptName], Departments. [JobTitle] FROM Departments;
Write a query to display all the information under department name and vacancies from the Department's table.
SELECT Departments. [DeptName], Departments. [Vacancies] FROM Departments;
The following time I learn a weblog, I hope that it doesnt disappoint me as a lot as this one. I imply, I do know it was my option to learn, however I really thought youd have one thing fascinating to say. All I hear is a bunch of whining about something that you can fix when you werent too busy on the lookout for attention. Best assignment provider in India
ReplyDeleteI wanted to thank you for this excellent read!! I definitely loved every little bit of it. I have you bookmarked your site to check out the new stuff you post. ç•™å¦ç”Ÿä»£å†™
ReplyDeleteit was a wonderful chance to visit this kind of site and I am happy to know. thank you so much for giving us a chance to have this opportunity.. ç•™å¦ç”Ÿä»£å†™
ReplyDeleteBelow you will understand what is important, the idea provides one of the links with an exciting site: Pay someone to do my GIS assignment
ReplyDeletehttps://www.floraindia.com/flower-delivery/delhi.html It's very trendy these days to complain about games getting simpler and easier. The "hardcore" gaming crowd is crying out for more challenges in games. But I personally love the "casual friendly" games of today and there's a good reason for their success...
ReplyDeletehttps://www.visualaidscentre.com/lasik-surgery-in-gurgaon/ Safety is everybody's main concern when trying new things. And a LASIK eye surgery done is not an exception. Even if in the most advanced state for eye surgeries like Texas, a lot of people are still worried about the procedure.
ReplyDelete