Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

COMP4039-DIS – Databases, Interfaces & Software Design Principles

Coursework 2: Database + web interface project

Due date – 15th December 2023, submitted via Moodle

Coursework 2 is INDIVIDUAL WORK

Coursework Deliverables

WARNING: If you submit any non-ZIP formatted archives instead of ZIPs (e.g., RAR) your submission may appear corrupt to markers and therefore parts of it could receive ZERO marks.

Overview. You should provide the following deliverables in a single directory, ZIPped up and submitted by the due date. You must use the following core structure with the following labels (except for the parts marked ‘example’):

DIS-COMP4039-CW2-yourusername-studentID/ [dir]

Further details elaborating the Overview. A single ZIP file named “DIS-COMP4039-CW2-yourusername-studentID.zip” should be submitted, containing the following:

1. A cover page file named “yourusername-studentID_CW2_cover.txt” containing your name, your student ID and your username (please use .txt / plain text file format). In this file you must:

a. A. Provide a list of all files you submitted for this coursework (including those contained in the Docker director below).

b. B. Provide a URL to your main start page for CW2 e.g.,

i. http://localhost/coursework2/login.php

In the cover page file you must also list & specify the origin of ALL resources (e.g., frameworks, assets, styles, JS libraries, code adapted / used from internet sources, etc.) that have used that are not solely your own work—if you do not do so we may consider the absence of such a declaration as indicating academic misconduct.

2. A full copy of your Docker directory, labelled with “yourusername-studentID_Docker” – this must contains all necessary files so that it can be run on an equivalent Docker instance (i.e., based off the github Docker configuration provided). NOTE: You must include SQL files that describe your database and data (.sql plain text file format) so we can reconstruct your database using phpMyAdmin. This directory should obviously also contain your PHP / HTML files that will constitute the web front-end. If SQL files are not present we may be unable to mark your coursework and you will receive ZERO marks.

3. Two documentation files (PDF only please or else these components will be marked ZERO):

a. one named “yourusername_UserManual.pdf” which contains the user manual (as described below); and

b. one named “yourusername_Technical.pdf” which contains the technical manual.

Late submissions will be accepted, but they will be penalised at the University standard rate of 5% per working day.

It is assumed you have read and understood the module’s Academic Misconduct Policy document.

Coursework Specification

For this coursework we will use same scenario as for DIS-COMP4039 Coursework 1A (coursework-1a-scenario.pdf). You will need a backend database and you are free to either use your own or adapt the one provided (coursework-2-database.sql). Note this will need modification.

The task is to create a usable end to end system that will allow police officers to record and retrieve information about vehicles, people and traffic incidents. Although the database provided is small you should consider how your design solutions would scale to a much larger amount of data.

You must implement an interactive web frontend for your database using PHP, PHP’s SQL interface, and HTML (as well as other technologies such as CSS or JavaScript, as you see fit).

This package / your system should be installable on any machine with a MySQL / Apache / PHP stack (e.g., LAMP)—so you should avoid absolute pathnames and you should use header files to ensure configuration (e.g., MySQL hostname etc.) is held in one file only. For example, see db.inc.php in the PHP demo code available on Moodle (use require("path/to/db.inc.php") in your other PHP files to include this common header.

We will be using Google Chrome (available on CS machines) to test your coursework (so make sure web interface elements function correctly in that browser).

Marking criteria

Coursework 2 is worth a total of 60% of the total marks for this module.

Coursework 2 is marked out of 100. The mark will be scaled to provide the final mark for this coursework. Most marks are allocated for specific required features, although to achieve the higher end of marking we encourage you to go beyond what is required. There are a few general mark categories that are awarded for the coursework as a whole which will also benefit from creatively going beyond the bare minimum of functionality specified in the questions. Finally, we note that marking will take into account specific code fragments (e.g., PHP, SQL, JS, etc.) that you have been provided with by convenors.

Core required features [80 marks total]

1. A police officer should be able to log into the system using one of the following usernames/password combinations:

Once logged in the police officer should have the ability to change their password.

IMPORTANT NOTE – in any real world system involving a database and web frontend, security would be paramount. However, addressing security is beyond the scope of this module, so you should ignore this. For example, usernames and passwords can be stored as plain text fields in your database – do not attempt to encrypt them or secure your database in any way. [10 marks]

2. The police officer should be able to look up people by their names or their driving licence number (by typing either of these in to the system). If the person is not in the system it should give an appropriate message. This search should not be case sensitive and it should work on partial names (e.g., “John”, “Smith” and “John Smith” would all find John Smith. If there are several people with the same name they should all be listed. [6 marks]

3. The police officer should be able to look up vehicle registration (plate) number. The system will then show details of the car (e.g., type, colour etc.), the owner’s name and license number. Allow for missing data in the system (e.g., the vehicle might not be in the system, or the vehicle might be in the system but the owner might be unknown). [6 marks]

4. The police officer should be able to enter details for a new vehicle. This will include the registration (plate) number, make, model and colour of the vehicle, as well as its owner. If the owner is already in the database, then it should be a matter of selecting that person and assigning them to the new vehicle. If the owner is not in the database they should be added (along with personal information including the license number). [14 marks]

5. The police officer should be able to file a report for an incident and retrieve existing reports (e.g., via a search). Filing new ones will involve submitting a textual statement, recording the time of the incident and the vehicle and person involved. If either the person or the vehicle are new to the system, then appropriate new entry/entries to the database should be added. The officer should be able to record the offence from a list of offences contained in the database. NOTE: a fine is not stored at this stage, because the fine will be issued by a court at a later time, and added by an administrator. The officer should be able to retrieve and edit the report. [14 marks]

6. An administrator should be able to log into the system with the username “daniels” and the password “copper99”. The administrator should be able to do everything that an ordinary police officer can do with the following additions:

• The administrator should be able to create new police officer accounts

• The administrator should be able to associate fines to reports [10 marks]

7. To support various regulatory and statutory requirements, police need to have access to an audit trail to account for database record accesses and changes that are made (e.g., deletions, updates, etc.). Implement a basic auditing feature in the web interface which will enable an administrator to review the above, on a per user basis (you may extend this to provide other auditing views e.g., per record). [20 marks]

Other required features [20 marks total]

Documentation. You should produce two documentation manuals – a user manual and technical documentation. The user manual should explain to a user (i.e., a police officer or an administrator) how to use the system. It is extremely important that all of the software features you have implemented should be described in this manual (otherwise you might not get marks for them!). The user manual should be no more than 500 words, though it may have screen shots if you so wish.

The technical manual should contain all of the information that would be needed if you were handing this project over to another developer to take it further. It should explain how to install your software (you may assume that MySQL, and a web server implementing PHP are already installed and configured). It should also contain a detailed description (including diagrams) of the structure of your system, together with a brief rationale for its design. For example, you could include explanations of key queries, key PHP components, etc. Please avoid including screenshots of code or large amounts of code listings. The technical manual should be no more than 500 words (diagrams, screenshots, etc. do not count for words). [10 marks]

User interface. This is the visual design, interaction design and usability. You might pick up a few marks for creating a beautiful user interface, but not many. What is more important is that your system is usable, in this case with minimal or ideally no training. We strongly advise you primarily examine Nielsens’s 10 heuristics and secondarily look for existing best practices in web interface design to guide you. [10 marks]