BDW4213 WEB DEVELOPMENT AND APPLICATIONS

Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

BDW4213

WEB DEVELOPMENT AND APPLICATIONS

Trimester March 2024

PROJECT GUIDELINES

LEARNING OUTCOMES

• Build an online eCommerce system by incorporating client-side and server-side scripting languages and using web editing tools.

OBJECTIVES

• At the end of this project, students will be able to:

o Develop a fully functional e-commerce website that allows customers to browse products, add them to a cart and complete transactions online.

o Establish a secure and user-friendly registration and login system to authenticate users and prevent unauthorized access to customer information.

o Create an intuitive product display page that showcases products with detailed descriptions and high-quality images to improve user experience and increase sales.

o Implement an administrative panel that allows the business to manage products, orders, customers, and payments efficiently.

INTRODUCTION

• You are required to create an e-commerce website with CRUD (Create, Read, Update and Delete) operations.

• The website should allow users to browse products, add products to a shopping cart, place order and manage their account information.

• The website should also allow an administrator to manage products, categories and orders.

SUBMISSION

• Date : Week 14 (24/6/2024 Monday).

• Time : Before 12.00pm noon.

• Location : Files must be uploaded at the link given by the lecturer.

• Submission : Project Folder and the Database (Export from MySQL).

TECHNICAL REQUIREMENTS

• The website should be built using HTML, CSS and JavaScript for the front-end (client-side) scripting and PHP for the back-end (server-side) scripting.

• The database to be used is MySQL where all the products, users, transactions and other related information will be stored.

• The website should have a user authentication system that allows users to create an account, login and logout.

• There will have 2 types of users:

o Customer (User)

o Administrator (Seller)

• The website should implement CRUD operations for users, products, orders and other related tables if necessary.

TASK

1. Pick a topic.

o Decide on a product to sell. It can be any product that can be sold online. You may refer to websites such as Lazada or Shopee to get some inspiration.

o Example:

− Computer Store                                 − Bath & Body Store

− Smartphone Store                              − Fitness & Training Store

− Vitamins & Supplements Store             − Bedding Store

− Kitchen Appliance Store                       − Furniture Store

2. Design the Entity Relationship Diagram (ERD).

o Use a Crow’s Foot model to create the ERD.

o All tables and attributes must be named properly.

o All the primary and foreign keys must be clearly defined.

o All the relationships must be correctly labelled.

o Need to be finalised by the lecturer on the design.

3. Database Setup.

o Use MySQL to create the database based on the ERD.

4. Complementary Web Pages.

o Design some web pages which will complement the e-commerce platform:

− The index page – design the home page.

− The About Us page – Should include the information about the store, mission, vision and the members’ description with photo.

− The Contact Us page – Include a form for visitors to give feedback. This feedback will be seen by the Administrator.

− Terms and Conditions page.

− Privacy Policy page.

− Frequently Asked Questions (FAQ) page.

5. User Registration (Sign-up) and Login (Sign-In) pages.

o Create a user registration page or sign-up page where users can sign up for an account with their name, email and password.

o Use JavaScript to validate the input fields to ensure that the user enters the correct format for each field. Important data such as contact number and email address cannot be duplicated.

o Create a login page or sign-in page where users can log in with their email address and password. Validate the input fields to ensure that the users enter the correct format for each field.

o Make sure to use sessions.

6. User Dashboard.

o Users should be able to view and edit their profiles after they have logged into their account. Data must be validated before being saved.

o Product Catalogue Page.

− Create a page that displays minimal information of all the products available in the store.

− Enable the user to search products by name, category or keywords.

− Enable the user to view more details about each product.

o Shopping Cart.

− User should be able to add products into the shopping cart.

− Create a page to display all the products that have been added into the shopping cart.

− Enable the user to remove items from the shopping cart and edit the quantity of products.

− Must include a Checkout button to confirm the orders.

o Transaction History.

− Create a page which displays all the past transactions made by the user.

7. Administrator Dashboard.

o Create an admin panel that allows the admin to manage their profile, products, orders and customers.

o The admin should be able to add, edit and delete products and its related information, view customer orders and update the delivery status of orders.

SAMPLE WEBSITE TEMPLATE (HTML & CSS)

• Students are allowed to use free templates for the webpage design only (HTML & CSS).

o https://www.html5webtemplates.co.uk/templates/

o https://www.free-css.com/

o https://www.os-templates.com/

• These demo websites will demonstrate how an online store transaction works.:

o https://woovina.com/ecommerce-website-templates

o https://www.j2store.org/demo-stores.html

o https://ecommerce.tealiumdemo.com/

MARKING

• This project carries 30% of the entire course assessment percentage.

• The e-commerce platform carries 80% of the overall project marks.

• The peer evaluation carries 20% of the overall project marks.