EWD621S - ENTERPRISE WEB APPLICATION DEVELOPMENT - 2ND OPP SUPL - JAN 2023


EWD621S - ENTERPRISE WEB APPLICATION DEVELOPMENT - 2ND OPP SUPL - JAN 2023



1 Pages 1-10

▲back to top


1.1 Page 1

▲back to top


nAm I BIA un IVERSITY
OF SCIEn CE Ano TECHn OLOGY
FACULTY OF COMPUTING AND INFORMATICS
DEPARTMENT OF INFORMATICS, JOURNALISM AND MEDIA TECHNOLOGY
QUALIFICATION: BACHELOR OF INFORMATICS
QUALIFICATION CODE: 07BAIF
COURSE: ENTERPRISEWEB APPLICATION DEVELOPMENT
DATE: JANUARY 2023
DURATION: 2 hrs : 00 min
LEVEL: 7
COURSE CODE: EWD621S
PAPER: THEORY
MARKS: 50
SECOND OPPORTUNITY/SUPPLEMENTARY EXAMINATION QUESTION PAPER
EXAMINER(S):
MODERATOR:
MR ELIAZERMBAEVA
MR TENGOVANDU KANDETU
THIS QUESTION PAPER CONSISTS OF 9 PAGES
(Including this front page)
1

1.2 Page 2

▲back to top


1.3 Page 3

▲back to top


INSTRUCTIONS TO STUDENTS:
1. Read all the questions, passages( scenarios, etc., carefully before answering.
2. Answer all the questions.
3. Number each answer clearly and correctly.
4. Write neatly and legibly.
5. Making use of any crib notes may lead to disqualification and disciplinary action.
6. Use the allocated marks as a guideline when answering questions.
7. Looking at other students' work is strictly prohibited.
8. This paper consists of SIX (9) pages including the cover page.
2

1.4 Page 4

▲back to top


1.5 Page 5

▲back to top


SECTION A: Multiple Choice Questions [10 Marks]
• The section consists of 2 questions. Answer all the questions in the
provided blank lines and open spaces where necessary.
Select one option from the list of possible answers to the questions below.
1. Which of The Fallowing Is An Internet Protocol.
a. FTP
b. TCP/IP
c. EFT
d. EDI
2. Which of the following terms best represent Web Databases:
a. File System Api
b. Offline Web Applications
c. Online Web Applications
3. Which of the following statements represent href.
a. Is A Tag Of A Tag
b. Is A Value Of A Tag
c. Is An Attribute Of A Tag
d. Stands For Hyperlink Repeat Electronic Filling
(1 Mark)
{1 Mark)
{1 Mark)
4. Which Tag is used to include a separately defined Style Sheet in Web Pages? {1 Mark)
a. <style>
b. <link>
C. <body>
d. <import>
5. In which loop does the condition comes after the body of the loop?
a. While Loop
b. For Loop
c. Do-while Loop
d. Nested Loop
(1 Mark)
6. PHP stands for?
a. Hypertext Preprocessor
b. Pretext Hypertext Preprocessor
c. Personal Home Processor
d. None of the above
(1 Mark)
3

1.6 Page 6

▲back to top


1.7 Page 7

▲back to top


7. Which of the following is used to display the output in PHP?
a. Echo
b. Write
c. Print
d. Both (a) and (c)
8. Which of the following is the use of strlen() function in PHP?
a. The strlen() function returns the type of string
b. The strlen() function returns the length of string
c. The strlen() function returns the value of string
d. The strlen() function returns both value and type of string
9. Which of the following is used for concatenation in PHP?
a. + (plus)
b. * (Asterisk)
c. . (dot)
d. append()
10. Which ofthe following is the correct way to create a function in PHP?
a. Create myFunction()
b. New_function myFunction()
c. function myFunction()
d. None of the above
(1 Mark)
(1 Mark)
(1 Mark)
(1 Mark)
4

1.8 Page 8

▲back to top


1.9 Page 9

▲back to top


SECTION B: Descriptive Questions [20 Marks]
• The section consists of 5 questions. Answer all the questions.
11Weset upatelephonceonnectiobnetweenUSandtheGUYSatSR.I..,"
"WetypedtheLandweaskedonthe phone,
- Doyouseethe L?
-Yesw, eseethe L,camethe response.
Wetypedthe0, andweasked:
- Doyouseethe0.
-Yesw, eseethe0.
henwetypedtheG1 and...the systemcrashed...Yeta revolutiohnadbegun".
Figure 1: "Said someone".
1. Given the context above, explain what was happening and state scientist responsible or
credited for that significant development.
(3 Marks)
2. Given the following abbreviations, provide words representing each of the letters in abbr.
(5 Marks)
a. HTTP:
b. HTML:
C. URLs
d. URls
e. MVC
3. What is the purpose of HTML in Web Applications development?
(2 Marks)
4. Define modelling and its significance for enterprise applications development. Give a simple
example of a model to support your definitions.
(3 Marks)
5

1.10 Page 10

▲back to top


2 Pages 11-20

▲back to top


2.1 Page 11

▲back to top


5. Analyse and define the scenario depicted in the diagram below:
(5 Marks)
Me tac/asses
Classes
~lr-.mP.nT
- assigned -ro
~-~k
1•e-fine
Figure 2: Modelling classes and metac/asses
6

2.2 Page 12

▲back to top


2.3 Page 13

▲back to top


SECTION C: Practical Questions [14 Marks)
1. Discussthe purpose of the code below; reference can be made to specific lines of code. The
length of your discussion should be guided by the amount of marks allocated to this question.
{6 Marks)
l <?php
2 $servername = "localhost";
3 ~username = "usernametl;
4 $password = "password";
5 $dbname = "myD3";
6
7 $conn= mysqli_connect($servername,
$username, $password,
5
9 1-Jif (!$conn) {
10 die("Conn'=c.:ic,n :ailed: " . mysqli_connect_error());
ll
12 $sql :;;;;"SELECT id, firstname, last:na:rte FP.O:-:--1yu~sts";
13 $result= mysqli_query($conn, $sql);
$dbname);
15 l~if (mysqli_num_rows($result)
le
> 0) {
17 -] while($row = mysqli fetch assoc($result))
18
echo "ici: " . $row["ici"]. " - Na:n,;;: " . $row["£irsL
19
20
else {
21
echo "O resul;:s";
22 -)
23 mysqli_close($conn);
24 ?>
Figure 3: The script
am<;"]. " " . $row["lastn2m="l.
"<br>";
7

2.4 Page 14

▲back to top


2.5 Page 15

▲back to top


2. Identify the errors in the code snippet below .
.l <?php
session_scarc();
3
$d.b_server
= 'local~osc';
Sdb_usernarce
= 'root';
5
Sdb_pa.ssword
= • ';
6
$db_narr.e = 'flowershop';
Scon = mysq1i_con.:-iecc(
Sdb server
:: :,
if ( Zco:l!l = false
)
.l .l
{
12
.13
$db_:usernarr.e
die();
•7
/'e-se{
.!. 9
I I ec!'lo • dacabase
co:i._-iecced
succe.s.sfu __ ~, •;
2(1
; "/
:i
f•~~ccion gecSessionid()
{
if ( ! .is.set($ _SESSION ( • sessio:-i_id'
] })
25
recurn $_s==ssION 'ses.s.ion_id'];
(4 Marks)
$db _passr,rord
Figure 4: Error Analysis
3. Produce an HTML code that will design an HTML Form given below. (10 Marks)
Simple Product Purchase
Full ~ame:
Email Address:
\\Yebsite lJRL: ::=========================:
Comment:
~Iy Products: D Product 1 _-s100D Product
I I Submit Details
l\\S250
Figure 5: HTML Form
Use the following empty page for your code.
8

2.6 Page 16

▲back to top


2.7 Page 17

▲back to top


************ End of the Paper***************
9

2.8 Page 18

▲back to top