ICT3612 Latest exam pack questions and answers and summarized notes for exam preparation. Updated for 2024 exams . For assistance Whats-App.0.6.7..1.7.1..1.7.3.9 . All the best on your exams!!
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
feedback@jolly.co.za.
5
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller iStudy. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $2.75. You're not tied to anything after your purchase.
