Using Code listing XXXXXXXXXXas a guide, implement two versions of the Module table – one with the single code column to hold a structured code and one with structured code implemented as four...

Using Code listing 10.3.4.1 as a guide, implement two versions of the Module table – one with the single code column to hold a structured code and one with structured code implemented as four separate columns (its constituent parts).

(a) Write SQL select statements for both tables that list all ‘F’ (Foundation) level modules, all modules offered by the computing department (code is ‘C’) and all modules offered by the information systems subject area (subject area code ‘I’).

(b) For each table, write a PHP script that allows end users to search for modules by department, subject area and level.

(c) For each table, write a PHP script that allows end users to add a new module or modify an existing one, including modifying the module code.

(d) Which table is easiest to use? Why?