Description of Assignment:
This assignment is both a written and practical assignment that will demonstrate your skills in the creation of database driven web pages
Create a MySQL database containing a single table (games) for an online games store. The games table will store information about games with the minimum of the following fields: game title, genre, year of release, publisher, screenshot, and a written review and (possibly) other fields of data relating to games. Choose appropriate data types and widths for each field.
Note 1) As your database server might not allow you to choose the database name any name is acceptable for this
Note 2) The screenshot data does not need to be stored inside the table. Commonly this will contain a local file path or URL that can be used as a web hyperlink
Use PhpMyAdmin to add 5 records to the games table based on existing information which you will research on existing games websites.
Create a username and password that can access this database using your firstname+lastname and a password of your own choice. This account should have full access to the database.
Create a webpage that connects to your database using PHP. Store the information the connection needs (database name, table name, username /password) in PHP variables. Display a message in the webpage when a successful connection is 2.3]
Create a Word document Task1 that contains
You will build on your work in task 1 and develop the database to the next stage
Using the existing records in your games db you will need to create the following:
For this You will need to create a complex query using SQL and execute this query on the remote database. This results page will use single control structures for selection and iteration such as conditional statements and loops to go through all the records. [3.1] [4.1]
To document this work, you will create software documentation for the user, this will have three parts.
Task 2a) Write an introductory section which explains how requirements can vary between the client (games store owner) and end user and explain the importance of an effective user experience [1.1]
Task 2b) Create and justify your user interface by producing design documentation in the form of wireframes and sketches to meet the specific client requirements as outlined below. [1.2]
The client requirements are
Task 2c) Create a user guide document with live links and screenshots of your working pages and well commented page listings to show your understanding. Use current web development conventions in your approach.
You will write a report which addresses the following questions within a word limit of 1500 words. Please indicate supporting references.
Finally review and evaluate the success of your uploaded files for your web database application suggesting areas for future development [7.2]File naming. Your tasks should be labelled in the following formatfirstname_surname_Task1_ddwp.docfirstname_surname_Task2_ddwp.docfirstname_surname_Task3_ddwp.docUpload this to Moodle to the designated final submission area by the deadline
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more