BCPR294 Assignment 1 partB | Complete Solution | Rated A+

PART B     TOTAL:  100 MARKS

Enhanced web site   

Purpose and instructions

The purpose of this part of the assignment is to improve the website you created in part A.
The following enhancements should be made:

•On the main page there should be links to a login page for the administrator and a search page for visitors.
•The administrator should be able to upload images to an images folder.
•The administrator should be able to maintain a list of categories and add new products via a new product form.
•The administrator can enter details of a new product, i.e. productCode, productName, description, fullDescription, category (selected from a list), and price.  The full description (a text data type) can span many lines.  A product may have many images (maybe selected from a list of images previously uploaded, or uploaded as required), but an image is associated with only one product.
•A visitor can search for products by any combination of product name, category/categories, price range, or words contained in any of the product name, description, and full description.  Search results are returned in groups of five (5) with just product name, description and one image with a link to the complete information and all images for this product plus a link that will display everything about the product as a PDF file.
•Improve the product order process so that an order can be for many products.  Do this using a “shopping cart” approach.
 

Element

Marks

Totals

1

Redesign the Database

Create an Entity Relationship Diagram showing all required entities, attributes (including types) and the relationships between entities

5

5

2

Build the database

Create a build.php script that builds the database structure and loads sample data into all tables.

10

10

3

Design and build the application

For each of the parts of the application shown below you should (a) write the pseudo-code and then (b) write the necessary PHP code.  Note that, for the purposes of this assignment, keeping it simple to ensure the necessary functionality actually works is a very good idea!

Administrator: log in                                                                                  

5

Administrator: add a new category

5

Administrator: upload an image

5

Administrator: add new product

5

Visitor:  a search for a product

15

User: can order multiple products

15

All details of a product are displayed as HTML

5

All details of a product are displayed as PDF

10

65

4

Software Engineering Notebook and Reflection

Write 300-400 words on different search interfaces that are used for websites and how to make searching easier for the user.

10

Write 300-400 words, reflecting on what you have learned from this assignment and how you would approach this assignment differently if you were to do it again.

10

20

Total

100

Hand-in: Submit via Moodle a ZIP file containing your scripts and documentation.