PART 3 - Develop website as per requirements and design specifications

Task 1 Implementation tools to develop website components

3.1 Refer to the project scenario and the Requirements Specification (PART 1, Task 1) and use the selected frameworks and/or languages for the software solution to develop the website components. 

Front End Website components include:

a) Navigation 

b) Header and Footer

c) Dynamic content layout

d) Imagery

e) Responsive layout

f) Forms

g) Accessibility elements

A combination of HTML/CSS will be used to develop the front end components structure.

Task 2 Database creation and website integration checklist

The main objective of this project is to integrate a database with a website using a number of current technologies:

• Regarding, development languages and frameworks, your manager will communicate to you which development technologies would be used for the project.

• Regarding the database side of development, you will be using a relational DBMS such as MySQL, DBMaria, MySQL Workbench or similar and structured query language (SQL). 

3.2 Using the ERD provided in the requirements, create a database for the scenario presented. Validate database data by ensuring that:

a) Key constraints are enforced

b) Referential integrity constraints rules have been observed

c) Data types match – specially in primary foreign key relations

d) Export/dump database file (sql extension) and keep it as backup in case you need to recover the structure and/or data. 

3.3 Before you start the integration tasks, retrieve and follow the integration plan that you created in Task 1: 2.5 a). Check that you have access to the required applications/programs and services:

a) A website - developed in 3.1

b) A database server and DBMS - as instructed by your manager and recorded in Part 1: Task 2.

c) A database - created in 3.2 from the ERD provided

Task 3 Integration of database and website

3.4 Using the selected technologies in 1.3 and the DBMS specified in 1.5 write the necessary code to: 

• Connect to the database server and database with the user account and credentials created in 2.5 c. 

• If connection is not achieved, rectify problem and retry. Provide screenshot of successful connection.

3.5 Once the connection to the database has been established you can start the integration by using SQL queries embedded in the selected programming language to add, display and modify data dynamically. The data to be inserted, retrieved and displayed and modified is outlined in the project scenario under the section “Automated Queries and Reports”. Conditions and filters to run the queries are provided in the scenario.

The visual and formatting controls used to display data will be controlled by the site CSS created in Part 3: 3.1. 

The automated queries and reports listed in the scenario require the following functionality: 

a) Log in to website (using username, password)

b) Inserting data into tables using external user input

c) Retrieving and displaying all data from a specific table

d) Retrieving and displaying data filtering the results with specific conditions

e) Retrieving and displaying data from multiple tables

f) Updating specific table rows with user-supplied input

g) Deleting data matching specified condition/s

3.6 Use appropriate code to validate and sanitise external data input before it reaches the database. 

3.7 Export/dump database file (sql extension) and keep it as backup and as evidence of the work completed.