Description of Assignment: This assignment is both a written and practical assignment that will demonstrate your skills

[answerhappygod]

Description of Assignment:
This assignment is both a written and practical assignment thatwill demonstrate your skills in the creation of database driven webpages
TASK 1
Create a MySQL database containing a single table (games) for anonline games store. The games table will store information aboutgames 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. Chooseappropriate data types and widths for each field.
Note 1) As your database server might not allow you to choosethe database name any name is acceptable for this
Note 2) The screenshot data does not need to be stored insidethe table. Commonly this will contain a local file path or URL thatcan be used as a web hyperlink
Use PhpMyAdmin to add 5 records to the games table based onexisting information which you will research on existing gameswebsites.
Create a username and password that can access this databaseusing 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. Storethe information the connection needs (database name, table name,username /password) in PHP variables. Display a message in thewebpage when a successful connection is 2.3]
Create a Word document Task1 that contains
TASK 2
You will build on your work in task 1 and develop the databaseto the next stage
Using the existing records in your games db you will need tocreate the following:
For this You will need to create acomplex query using SQL and execute this query on the remotedatabase. This results page will use single control structures forselection and iteration such as conditional statements and loops togo through all the records. [3.1] [4.1]
To document this work, you will create software documentationfor the user, this will have three parts.
Task 2a) Write an introductory section which explains howrequirements can vary between the client (games store owner) andend user and explain the importance of an effective user experience[1.1]
Task 2b) Create and justify your user interface by producingdesign documentation in the form of wireframes and sketches to meetthe specific client requirements as outlined below. [1.2]
The client requirements are
Task 2c) Create a user guide document with live links andscreenshots of your working pages and well commented page listingsto show your understanding. Use current web development conventionsin your approach.
TASK 3
You will write a report which addresses the following questionswithin a word limit of 1500 words. Please indicate supportingreferences.
Finally review and evaluate the success of your uploaded filesfor your web database application suggesting areas for futuredevelopment [7.2]File naming. Your tasks should be labelled in the followingformatfirstname_surname_Task1_ddwp.docfirstname_surname_Task2_ddwp.docfirstname_surname_Task3_ddwp.docUpload this to Moodle to the designated final submission area bythe deadline
JUST WRITE THE CODES, DATABASES AND ATTACH SCREENSHOTS, IWILL DO THE REPORT