BCPR294 Assignment 1 partB Complete Solution

Question: #746

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.

Solution: #760

BCPR294 Assignment 1 partB Complete Solution

down the search results and even if it does, it will have lesser option than the earlier search interface. This is because, the visual search interface is meant to be a simple form of search. The results being displayed will not be text based rather be displayed most likely in a grid like...