BDW4213
WEB DEVELOPMENT AND APPLICATIONS
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.
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.