程序代写代做代考 database SQL SIT203 Assignment 2

SIT203 Assignment 2
Marking Guide

Relevant php files and database (.sql or .txt) script files submitted.
3

URL(s) on Deakin webserver correctly specified
3

Database

     Database created on deakin server and accessible
2

     Appropriate table structure and field names
2

Server Side Scripting

     Search form

         Information from form fields properly extracted
1

Select one of the following options:
5

· Database & php used

         SQL statement(s) correctly formed – 3

         Proper records retrieved from database table – 2

· XML & php used

Proper info retrieved from XML file – 5

         Sensible search suggestion(s) provided
5

     Search response page(s) after user clicks on search

             Script generates a response to the user
1

             Information on the response page is accurate
3

             Information on the response page is appropriate and well laid out
3

     Checkout form on the fly validation

         Fields that are required are checked for completeness
2

         Validation reflects data formats/information required
5

         Appropriate ‘error’ messages presented where problems detected
2

         Form not processed further unless full validation has occurred
2

         Validation is done on the fly using Ajax
5

     Checkout form/Shopping cart

         Information from checkout form fields properly extracted
1

         SQL statement(s) correctly formed
2

         Information correctly added to correct database table
2

         Products correctly added, removed or modified in the order form/shopping cart
8

    Checkout form response page(s)

             Script generates a response to the user
1

Information on the response page is accurate
4

             Information on the response page is appropriate and well laid out
3

     My account

         User can change password
3

         User can edit personal info
3

     Register

         A new user automatically register on the website after making an order. A new account name and a temporary password is provided to the new user.
3

         A new user can directly register on the website before making an order
2

         Registered name displayed once registered
5

         Shipping address automatically filled if a registered user makes an order.
5

         Auto-filled shipping address is editable.
5

     Code appropriately commented
2

     Code layout appropriate and readable
2

Overall design
5

Total Mark
100

Weight
50%