[go: up one dir, main page]
Scribd
Upload
2 views5 pages

Case Study 1

The document outlines the National Exam for Higher National Diploma in 2025, focusing on the Specialty/Option of Software Engineering. It consists of four sections: Algorithm and Programming, Database, Web Design, and Networking, with various questions covering topics like data structures, SQL syntax, and communication models. Each section has specific marks allocated, and all questions are compulsory.

Uploaded by

crllandry20005
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views5 pages

Case Study 1

The document outlines the National Exam for Higher National Diploma in 2025, focusing on the Specialty/Option of Software Engineering. It consists of four sections: Algorithm and Programming, Database, Web Design, and Networking, with various questions covering topics like data structures, SQL syntax, and communication models. Each section has specific marks allocated, and all questions are compulsory.

Uploaded by

crllandry20005
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 5

NATIONAL EXAM OF HIGHER NATIONAL DIPLOMA – 2025 Session

Specialty/Option: SWE
Duration: 6 hours
Paper: Case Study
Coef: 12

Instructions:
This paper contains four (04) sections. All sections are compulsory. Answer all questions neatly
and clearly, label your work.

SECTION A: ALGORITHM AND PROGRAMMING (50marks)

I. DATA STRUCTURES AND ALGORITHMS (10 MARKS)

1. Data structure and algorithms are very important in computer technology and systems.
Define each of the above-mentioned term. (3marks)
2. Draw a simple flow chart to look for the largest number amongst 3 integers. (5mark)
3. Differentiate between divide and conquer and dynamic programming (2marks)
II. EVENT PROGRAMMING (10 MARKS)
1. What is the significance of console.readkey() function in visual basics? (1mark)
2. What is the difference between console.writeline() and console.write() in visual basics? (2
marks)
3. List and define 3 errors that can occur during writing a software? (3marks)
4. List 5 key words used in visual basics (2marks)
5. List two good programming practice to follow when writing codes (2mark)

III. STRUCTURED PROGRAMMING (15 MARKS)


1. What is variable initialization in programming and why is it important? (2marks)
2. If you have a certain number of US dollars and wish to convert them to Canadian dollars, you
could use the Canadian dollar to US dollar exchange rate (for example: 1 Canadian dollar = 0.81
US dollar). Write a complete C program that prompts its user for the current Canadian dollar to
US dollar exchange rate (e.g. 0.81) and a value in US dollars, and then prints the value in Canadian
dollars. (3marks)
3. Give the output of the following C++ program (5 marks)
#include <iostream>
using namespace std;
int main()
{
unsigned int a = 90;
unsigned int b = 18;
int c = 0;
c = a & b;
cout << "Line 1 - Value of c is : " << c << endl ;
Douala, Ange-Raphael Page 1|5
(+237) 679318844
scolarite@vtib-eportal.net (+237) 650857613
www.vtib-eportal.net (+237) 695593749
c = a | b;
cout << "Line 2 - Value of c is: " << c << endl ;
c = a ^ b ;
cout << "Line 3 - Value of c is: " << c << endl ;
c = ~a;
cout << "Line 4 - Value of c is: " << c << endl ;
c = a << 2;
cout << "Line 5 - Value of c is: " << c << endl ;
c = a >> 2;
cout << "Line 6 - Value of c is: " << c << endl ;
return 0;
}
4. What Color is that Square? (5 marks)
Positions on a chessboard are identified by a letter and a number. The letter identifies the column,
while the number identifies the row, as shown below:

Write a C++/C program that reads a position from the user. For example, if the user enters a1 then
your program should report that the square is black. If the user enters d5 then your program should
report that the square is white. Your program may assume that a valid position will always be entered.
It does not need to perform any error checking.

IV. OBJECT ORIENTED PROGRAMMING (15 MARKS)

1. A C++ program is given as shown below:

1. #include <iostream>
2. using namespace std;
Douala, Ange-Raphael Page 2|5
(+237) 679318844
scolarite@vtib-eportal.net (+237) 650857613
www.vtib-eportal.net (+237) 695593749
3.
4. class Person
5. {
6. public:
7. string profession;
8. int age;
9.
10. Person(): profession("unemployed"), age(16) { }
11. void display()
12. {
13. cout << "My profession is: " << profession << endl;
14. cout << "My age is: " << age << endl;
15. walk();
16. talk();
17. }
18. void walk() { cout << "I can walk." << endl; }
19. void talk() { cout << "I can talk." << endl; }
20. };
21.
22. // MathsTeacher class is derived from base class Person.
23. class MathsTeacher : public Person
24. {
25. public:
26. void teachMaths() { cout << "I can teach Maths." << endl; }
27. };
28.
29. // Footballer class is derived from base class Person.
30. class Footballer : public Person
31. {
32. public:
33. void playFootball() { cout << "I can play Football." << endl; }
34. };
35.
36. int main()
37. {
38. MathsTeacher teacher;
39. teacher.profession = "Teacher";
40. teacher.age = 23;
41. teacher.display();
42. teacher.teachMaths();
43.
44. Footballer footballer;
45. footballer.profession = "Footballer";
46. footballer.age = 19;
47. footballer.display();
48. footballer.playFootball();
49.
50. return 0;
51. }

a. Which Object Oriented Concepts are implemented in this program ? (2 marks)


b. Analyse line by line and give the output of the program above. (4 marks)
2. Define the following terms or expressions related to object oriented programming : Inheritance,
Modularity (2marks)
3. Differentiate between a class and an object. (2marks)

Douala, Ange-Raphael Page 3|5


(+237) 679318844
scolarite@vtib-eportal.net (+237) 650857613
www.vtib-eportal.net (+237) 695593749
4. From what does an abstract class differs from a concrete class? (2marks)
5. Name the various existing types of inheritance. (2marks)
6. What is a dot (.) operator in C++? (1 mark)

SECTION B: DATABASE (20marks)

1. Write SQL syntax for the following


a) To create a database, table and user (2marks)
b) To fill data into a relation (1mark)
c) To display specific tuples in a relation (1mark)
d) To display the records for all student in a class with age above 20 (2marks)
2. What is meant by normalization in database? State and explain the different norm form
(5marks)
3. Give examples of DDL and DML as used in SQL (2marks)
4. Study the figure below on ER-Modeling and answer the questions that follow

a) List all the entities and their corresponding attributes (3marks)


b) List all the relationships and primary keys (2marks)
c) Convert the E-R model to a relational model schema (2marks)

SECTION B: WEB DESIGN (15marks)

1. Explain with the help of a block diagram, the functioning of a proxy server 5marks
2. What is a URL? State two components of a URL. 3 marks

Douala, Ange-Raphael Page 4|5


(+237) 679318844
scolarite@vtib-eportal.net (+237) 650857613
www.vtib-eportal.net (+237) 695593749
3. State two advantages of client-side execution over server-side 2marks
4. Write the code of an html login form that collects a user’s name and the password. The form
submits to a script called ProcessMe.php 5marks
SECTION D: NETWORKING (15marks)

1. As an IT technician, you entered a company and tried to understand the IP scheme of the
company. On investigating the scheme, you saw a subnetted network having a network id of
192.168.1.0/26.
a. What name is given to the IP notation above? (1mark)
b. What type of Subnetting was used for such IP scheme? (1marks)
c. What is the default mask of the above IP? (1marks)
d. How many subnets were form using such addressing? (1marks)
e. How many subnet bits were borrowed? (1marks)
f. How many usable host are there per subnet? (1marks)
2. In a communication system, there are two things to take note of, the model in which the system
uses for communication and the information that is being shared from one point to another.
a. Define communication model and data communication. (2marks)
b. What are the components of each of the above mentioned terms? (4marks)
c. What are the different modes in which data can be transmitted from one point to another?
List and define each. (3marks)

Douala, Ange-Raphael Page 5|5


(+237) 679318844
scolarite@vtib-eportal.net (+237) 650857613
www.vtib-eportal.net (+237) 695593749

You might also like