Assessment Task:
PHP and MYSQL IT Assessment Answer

You are required to design and develop a website for the purpose of selling prints of art. You should focus on the core functionality of an e-commerce site: populating a catalogue as an administrator, displaying products to the public, creating a shopping cart, and storing orders in a database. From a technological point, you will be using PHP and MYSQLi for these functions.

1.    Use normalization to design a database for higher grades
2.    Create a database and suitable tables in MySQLi. Make sure that the data type is the most suitable and efficient.
3.    Create an administration side that allows you to add products and new artists to your inventory, so that customers are able to buy them.
•    you could create admin rights with different accesses so that one user can only add items and another with higher access can amend and delete
•    Create scripts that allow an administrator to amend and delete the products or artists. 
4.    For customers to be able to purchase products, they'll need to view them first. 
•    In the product catalogue, it will display a list of all the available prints. 
•    If a particular artist has been selected, only that artist's work will be shown; otherwise, every print will be listed. 
•    Using a variety of other filters will help you to achieve a higher grade.
•    A second script will be used to display additional information for a single print, including the image. On this page customers could include an Add to Cart link, so that the print may be added to the shopping cart.
•    Higher grades will be given if the quantities are automatically updated when an order is submitted
5.    Add items to your shopping cart including multiples of an item
6.    View and update the shopping cart 
7.    Calculate the running total of all the items
8.    Create a page for users to submit their orders and their details
9.    Log the user out by killing the session
10.    Record the order in the database
11.    For higher grades, as order processing, backup the order transaction as a text file.
12.    Use cookies or/and sessions as appropriate
13.    Allow a user to self-register with their own choice of user name and password to access a special members-only page.

 

This Finance Assessment has been solved by our Finance experts at UniLearnO. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

Eureka! You've stumped our genius minds (for now)! This exciting new question has our experts buzzing with curiosity. We can't wait to craft a fresh solution just for you!

  • Uploaded By : Mitchell Lee
  • Posted on : December 05th, 2018

Whatsapp Tap to ChatGet instant assistance