Course Code: M275

Course Code: M275
Course Title: Web Development Using PHP and MySQL

Tutor Marked Assignment - First Semester 2014/2015
Question 1 [2.5 marks]

What is the difference between echo and print commands? [2.5 marks]

Question 2 [5 marks]
An integer n is said to be a factor of a certain integer N, if multiplying n with some integer m produces N, that is, N = n*m.
Write a PHP function that (1) stores all factors of a given number N in an array and (2)
computes their sum. [5 marks]


Question 3 [7.5 marks]

1) Using your eLibrary, describe how the algorithm “quick sort” works. [2.5 marks]

2) Implement a PHP function that sorts an array of numeric values using the “quick sort”
algorithm. The array is passed to the function as an input parameter. Show by example
that the algorithm works. [5 marks]


Question 4 [5 marks]

1) Explain succinctly how the use of primary and foreign keys in relational databases
facilitates linking related data. [2.5 marks]


2) What are the general principles a database designer should think of prior to working out
the required database? [2.5 marks]