Final Marked Assignment $($FMA$)$

Introduction

The FMA, which carries $75\%$ of the total marks for this module, requires you to use your

knowledge of PHP procedural and object orientated style programming, the PDO database

extension, form and file processing and session and cookie control.

You are required to create a prototype web site, which will facilitate authenticated user login

for two different types of users: $$academic$$ and $$admin$.$ Both type of users will, after

successful login$,$ be allowed access to view summary statistics of module results stored in a

MySQL database. In addition, $$admin$$ type users will also, after successful login$,$ have

access to user administration functions to Create, Read, Update and Delete existing user

records via an administration view. Module results and user data must be stored in a MySQL

relational database. You have been provided with a HTML mock$-$up which illustrates how the

Home Page content and associated style should:

Completing the FMA

You should begin work on your FMA as early as possible, as the FMA is a substantial task

that requires much planning and effort to complete satisfactorily. You should begin by reading

carefully the functional, data and technical specifications and begin to prepare the required

design documentation, which you are also required to submit along with you source code.

Getting support

You may email your tutor up to $2$ weeks before the FMA deadline with any queries you may

have on your FMA and you can also request feedback on a draft of your work by email. You

only have one opportunity for feedback.

Getting feedback

Feedback on the marked FMA can be downloaded from Moodle and will normally be available

once second marking and external examiners have approved the module marking.

Backing up files

Always keep a back$-$up copy of all work submitted for assessment in case of unforeseen

submission problems.

Page $2$ of $7$

FMA Specification

Functional Requirements

$1.$ Data Initialisation. Upon loading the website for the first time, appropriate data will

need to be initialised:

a$.$ An initial administrator user should be set up to facilitate login to the website

to be able to register new users. The username should be $$ubadmin$01$ and

the password should be $$DCSadmin$-01,$ with UserType set to $$admin$,$

firstName set to $$Admin$$ and the surname set to $$User$.$

b$.$ Module results have been supplied as sets of three $.$csv files provided in the

data subfolder of the FMA resources, downloadable from Moodle. You are

required to upload the data in these files and store them securely in a database

table.

c$.$ See later Data Specification for required database table$/$column

specifications.

$2.$ Landing$/$Home page view should display the content and style in the supplied

template $$mockupPage$.$html$$ and $$styles$.$css$.$ It will also facilitate the authentication

of known users to the system via a $$username$$ and $$password$$ login form, or by

displaying the name of a user who has successfully logged in$,$ and a logout button. It

should also display an appropriate main NAV menu, whose options will depend upon a

successful user login and their user type.

$3.$ The main NAV menu should be available on all pages$/$views$,$ displayed as horizontal

options in the