ICT3612
EXAM PACK
FOR ASSISTANCE WITH THIS MODULE +27 67 171 1739
, ICT3612/104/1/2018
Example of an examination paper
Question 1 4 marks
Code, then use a simple function that contains one required and one default parameter.
Question 2 10 marks
2.1 Consider the following function:
<?php
function subtract($first_number, $second_number){
$result = $first_number - $second_number;
return $result;
}
?>
Define appropriate variables, and then use them with the function so that the following
sentence is printed:
The result of the calculation is -76. (6)
2.2 Consider the following function that works with a variable-length parameter list:
<?php
function dynamic_args() {
for($i = 0 ; $i < func_num_args(); $i++) {
echo "Argument $i = ".func_get_arg($i)."<br />";
}
}
?>
i. Use the function to produce the following lines:
Argument 0 = a
Argument 1 = b (2)
ii. Use the function again, but this time the following lines must be produced:
Argument 0 = a
Argument 1 = b
Argument 2 = c
Argument 3 = d
Argument 4 = e (2)
Question 3 28 marks
3.1 Create and use a simple class containing a single method that will produce the
following output:
Hello Felicia! (4)
3
, ICT3612/104/1/2018
3.2 Adapt (not extend) the class above so that it makes use of a constructor method, and
two get and set methods. Use the adapted class. The output produced must be as
follows:
Hello Felicia Ngobeni! (8)
3.3 Adapt the class from (b) by making the variables private. Extend the class with a
subclass named member. Add a function that will greet the member:
Hello member f3lng0Beni! (8)
3.4 Repeat 3.3 here above but extend the Users class with a class Administrator. When
used, the member will be greeted as follows:
Hello administrator Nthabiseng007! (8)
Question 4 21 marks
Consider the following draft facts of a database model:
The Entities required included are:
Student Information
Courses
Student Courses
Employees (Tutors)
Contact Information (Contact between the Student and the Tutor by e-mail or phone)
Contact Types (e-mail, phone)
The Entities are related as follows:
One Student can enrol on One or Many Courses
One Course can have One or Many Students enrolled on it.
One Student can have zero, one or many forms of Contact with the Course Tutor
One Employee (Tutor) can deal with many Contacts
One Contact Type (Phone, E-mail, Assessments, Projects etc.) can have zero, one or
many Contacts
On the screenshot of the model below, and next to (or above) each X: fill in the missing entities,
relationships between the entities and primary keys.
4
, ICT3612/104/1/2018
Question 5 9 marks
Consider the following SQL code that will create a table in a database:
CREATE TABLE IF NOT EXISTS `course` (
`course_id` int(11) NOT NULL,
`course_name` text NOT NULL,
`course_descr` text NOT NULL,
`course_cost` text NOT NULL,
`course_duration` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
ALTER TABLE `course` ADD PRIMARY KEY (`course_id`);
ALTER TABLE `course` MODIFY `course_id` int(11) NOT NULL
AUTO_INCREMENT;
Using question mark parameters, write a prepared statement that will select the course names,
their descriptions and cost where the course_id is 12.
Question 6 8 marks
Consider the following form:
Write code that will process the form and send all the information processed in an email to
.
5
EXAM PACK
FOR ASSISTANCE WITH THIS MODULE +27 67 171 1739
, ICT3612/104/1/2018
Example of an examination paper
Question 1 4 marks
Code, then use a simple function that contains one required and one default parameter.
Question 2 10 marks
2.1 Consider the following function:
<?php
function subtract($first_number, $second_number){
$result = $first_number - $second_number;
return $result;
}
?>
Define appropriate variables, and then use them with the function so that the following
sentence is printed:
The result of the calculation is -76. (6)
2.2 Consider the following function that works with a variable-length parameter list:
<?php
function dynamic_args() {
for($i = 0 ; $i < func_num_args(); $i++) {
echo "Argument $i = ".func_get_arg($i)."<br />";
}
}
?>
i. Use the function to produce the following lines:
Argument 0 = a
Argument 1 = b (2)
ii. Use the function again, but this time the following lines must be produced:
Argument 0 = a
Argument 1 = b
Argument 2 = c
Argument 3 = d
Argument 4 = e (2)
Question 3 28 marks
3.1 Create and use a simple class containing a single method that will produce the
following output:
Hello Felicia! (4)
3
, ICT3612/104/1/2018
3.2 Adapt (not extend) the class above so that it makes use of a constructor method, and
two get and set methods. Use the adapted class. The output produced must be as
follows:
Hello Felicia Ngobeni! (8)
3.3 Adapt the class from (b) by making the variables private. Extend the class with a
subclass named member. Add a function that will greet the member:
Hello member f3lng0Beni! (8)
3.4 Repeat 3.3 here above but extend the Users class with a class Administrator. When
used, the member will be greeted as follows:
Hello administrator Nthabiseng007! (8)
Question 4 21 marks
Consider the following draft facts of a database model:
The Entities required included are:
Student Information
Courses
Student Courses
Employees (Tutors)
Contact Information (Contact between the Student and the Tutor by e-mail or phone)
Contact Types (e-mail, phone)
The Entities are related as follows:
One Student can enrol on One or Many Courses
One Course can have One or Many Students enrolled on it.
One Student can have zero, one or many forms of Contact with the Course Tutor
One Employee (Tutor) can deal with many Contacts
One Contact Type (Phone, E-mail, Assessments, Projects etc.) can have zero, one or
many Contacts
On the screenshot of the model below, and next to (or above) each X: fill in the missing entities,
relationships between the entities and primary keys.
4
, ICT3612/104/1/2018
Question 5 9 marks
Consider the following SQL code that will create a table in a database:
CREATE TABLE IF NOT EXISTS `course` (
`course_id` int(11) NOT NULL,
`course_name` text NOT NULL,
`course_descr` text NOT NULL,
`course_cost` text NOT NULL,
`course_duration` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
ALTER TABLE `course` ADD PRIMARY KEY (`course_id`);
ALTER TABLE `course` MODIFY `course_id` int(11) NOT NULL
AUTO_INCREMENT;
Using question mark parameters, write a prepared statement that will select the course names,
their descriptions and cost where the course_id is 12.
Question 6 8 marks
Consider the following form:
Write code that will process the form and send all the information processed in an email to
.
5