COM1025 Web and Database Systems
- Developing and Testing Environment
You should provide the following information in this section:
- What figure drawing softwareyou used to draw the EER diagram (you can also mention this in Section 2, but it will still be considered as part of this section).
- What version of MySQL serveryou used to create and test your MySQL database. If you used the MySQL server in XAMPP Portal used in the lab sessions, simply include the version of the XAMPP; otherwise detail the type of MySQL server and version with the URL from where you downloaded the MySQL server.
- Note that using a different version of MySQL may mean the marker cannot run your MySQL code so you may be disadvantaged.
- What MySQL client-side tool you used to test your MySQL database.
- You do not have to use the mysql.exe used in the lab session but any software tool as long as the MySQL code was written by you manually.
- What web server and PHP module you used to test your website. If you used the XAMPP Portal used in the lab sessions, simply include the version of the XAMPP.
- What web browser(s) and their version numbers you used to test your website.
- The operating systems you used during your development and testing processes.
- EER Data Model and Diagram
The core of this section should be an EER diagram showing each single detail of your EER model. You should also explain key characteristics of your ER/EER model in writing to cover all important concepts including entity types, attributes, relationships, cardinality and participation constraints of binary relationships, disjointness and participation constraints of supertype-subtype relationships.
- Conceptual/Logical Relational Database Schema
In this section, you should show the conceptual/logical relational database schema translated from the EER model. You should include a relational schema diagram visualising all primary keys, all foreign keys and domains of all attributes of all relations.
- MySQL Code
In this section, you should explain details about your MySQL code for creating and populating your MySQL database. You should not copy all MySQL code into this section, but try to explain key aspects that need explanation.
You should also list all embedded MySQL code in your PHP code and explain what those MySQL statements are used for.
- Website Working with MySQL Database
In this section, you should give a list of all files (can be one if you decide to have a simple webpage, but remember you are not marked for front-end) of your website and focus on those files (PHP scripts) directly interacting with your MySQL database. Clearly state in which PHP script where PHP code is used to access the MySQL database and for what purposes.
You should include recommended steps for testing the database part of your website and provide screenshots if necessary. Please note that you do not need to provide info on other parts which are not directly related to test your PHP code for accessing the MySQL database.
- Advanced Tasks
In this section, please detail what advanced tasks you have done. If you did some advanced tasks but forgot to include them in this section, you have to bear the risk that such advanced tasks may not be noticed by the marker and thus additional marks may not be awarded. If you did not attempt any advanced task, still include this section but just say you didn’t attempt.
- References (Optional)
If you like, a list of references can be included here. If you do so, make sure you cite every reference in the main body of your report. Particularly, if you used source code and/or external libraries in your website, make it clear in the main body of the report and add proper references (with URLs if relevant). Make sure you have the needed permission to use such code and libraries as well (which will not be checked in the marking process of this coursework assignment but you should be aware of such legal issues and what are your responsibilities).
- Appendix (Optional)
You can include anything else you want to provide as additional material here. Use sub-sections to cover different types of material. Please refer to all the items listed here in the main body of your report, otherwise the marker may not read this part (since it is an appendix).
USA 
India