OBJECTIVE
This assignment assesses the student's ability to design and build a web-based application for electronic commerce.
SCOPE
Working in a team of 3 or 4 students, you are required to design and implement a web-based online gift shop for a local merchant. Each team member is required to implement 1 of the 4 functional areas described in Section 3.0. In addition, the team is required to integrate the different functional areas that the team has implemented to present an integrated system.
The data dictionary of this online store is shown in Appendix A. You can download a script file that contains the database schema and sample data to construct your database for the website, as well as product image files required for your assignment from the eCAD website at MeL. You should use the database and product images given to you to develop the application. You may also download other product images from the Internet for this assignment, but do take note that the images file downloaded should be purely used for the purpose of doing this assignment and should not be used or posted in other websites, e.g., Facebook.
You may choose a name of your choice for your eCommerce store but the name should not be a registered business, or is insulting, intrusive or defamatory in nature.
You should NOT copy the website design of other websites.
The required resources for this assignment are:
- WAMP 3.x
- Adobe Creative Cloud - Dreamweaver
All programs should be developed using HTML, JavaScript, PHP and MySQL technologies.Each member in the team should implement 1 of the 4 functional areas as described in sections 3.2 to 3.5. If your team consists of:
• 3 members - do "Product Catalogue", "Shopping Cart" and "Checkout".
• 4 members - do "Membership Registration", "Product Catalogue", "Shopping Cart" and "Checkout"
You may also implement additional sensible functionality related to your functional area, within the constraints of the given database design. Make your own assumptions where necessary and stated clearly in your report.
The different functional areas are to be integrated as one system as described in Section 3.1.
Integration of System
Working as a team, you should design and implement at least the following requirements for the online store:
- A home page (named as index.php) with navigation system that integrates all the functional areas of the online store. The home page should display the products that are on offer currently.
- A login page that accepts eMail account and password for member's authentication. The login credentials, i.e. eMail account and password, should be verified against records stored in the database.
You may implement additional functionalities which you think are useful.
Membership Registration
A shopper has to register as a member before making any purchase. For guest shoppers who do not wish to register with the online store, they can only browse or search the product catalogue, but not able to drop the product into a shopping cart.
When a shopper registers with the online store, he must provide his personal particulars which include an eMail account and a password for login purpose. The shopper may choose to supply a question and an answer to the question for the purpose of retrieving a forgotten password. Refer to the data dictionary in Appendix A for other information that should be provided during registration.
Upon successful registration, the information entered during registration is saved as a shopper profile. A unique member ID will be assigned and made known to the member.
Basic Requirements
- Allow a shopper to register as a member. Appropriate input data validation should be incorporated.
- Allow an existing member to update the profile. Appropriate input data validation should be incorporated.
- When registering and updating member profile, ensure that the eMail account provided by the shopper is unique in the database.
Additional Requirements
- Provide the password to a member who has forgotten it after he has provided the right answer to a question. The question and answer are captured during member's registration.
[SMTP service is not available on the server for you to eMail the password to the member. Hence you can only display the password on screen.]
- Allow member to enter his/her important dates and display at the home page a list of important dates in the current or next month. [Note: This feature helps to remind busy people about some important dates defined by them, e.g. wedding anniversary, birthday of the loved one and encourages them to buy a gift for the loved one.]
Product Catalogue
The product catalogue shows all the product categories of the online store and displays all products under each category. Detailed information of each product, including a product's image, should also be provided. A shopper may access a particular product through the categories or a search page. The shopper may choose to add a product into his shopping cart.
The product catalogue plays a vital role in giving the shopper a pleasant shopping experience. Hence it should be designed to offer convenience and useful information to the shopper.
Basic Requirements
- Display the Product Catalogue.
o The product catalogue should contain a "Categories" page showing all product categories available in the online store, sorted in alphabetical order.
o The product catalogue should contain a "Product Listing" page showing all products of a selected category. The product list should be sorted in alphabetical order.
o A "Product Details" page displaying detail information of a product and for the shopper to add the product to his shopping cart.
- Display "Out of Stock" indicator and disable the "add to cart" button.
For products which have an inventory level of zero or negative, an "Out of Stock" indicator should be displayed and shopper should be prevented from ordering such products by disabling the "add to cart" button.
- Provide a simple search feature for products.
A shopper should be able to search for products by supplying a partial search string of the product's name or description.
Additional Requirements
- Display an "On Offer" indicator on the "Product Listing" page for products which are marked as "offered" within a period indicated in the database. (i.e. "Offered" column in the "Product" table has a value of "1".) On the "Product Details" page, besides displaying the "On Offer" indicator, you should also display the price before offer and strike it off.
- Provide an advanced product search feature that returns a list of products that match certain search criteria, e.g. price range, occasion.
Shopping Cart
The shopping cart contains all products selected by the shopper. Each shopper should have his own shopping cart and should not be able to view another shopper's cart. Only one shopping cart should be used per shopping session. if a shopper does not have any shopping cart, a new shopping cart should be created when he selects an item from the product Catalogue.
(Note: Only registered members are allowed to make purchases, i.e. shoppers must login to the system before adding a product to shopping cart.)
Basic Requirements
- Able to add a product to the shopping cart.
When the shopper selects a product in the catalogue and adds to his shopping cart, the shopping cart should be updated with the selected product. Note that adding of duplicated product to the shopping cart should increase the quantity of purchase for that product in the shopping cart.
- Display and update the content of the shopping cart.
o It should display the product name, the unit price, quantity of purchase and the total purchase amount for each and all of the products in the shopping cart.
o Shopper should be allowed to change (i.e. update) the quantity of purchase for each product in the shopping cart.
o Allow the shopper to delete individual product from the shopping cart.
- After a member logs in successfully, his shopping cart which contains any unchecked out items from the last shopping session should be loaded.
Additional Requirements
- Waive the delivery charge (assumed express delivery) if subtotal amount is more than S$200.
- Compute the number of items in cart by adding the quantity of purchase for each item in the shopping cart, e.g. 2 pcs of Product 1 and 3 pcs of Product 2 in cart, the total number of items in cart should be 5.
Checkout
The total amount payable inclusive of the delivery charge and tax (GST) should be computed correctly before redirecting shopper to PayPal page for payment.
Basic Requirements
- Delivery is within Singapore only and there are 2 delivery modes. Calculate the delivery charge based on the mode of delivery. Delivery charge is $5 per trip for "Normal Delivery" (within 2 working days after an order is placed) and $10 per trip for "Express Delivery" (delivered within 24 hours after an order is placed).
- Allow a user to checkout using PayPal (Note: Test with your PayPal Sandbox's accounts). When checkout is successful, a confirmation page with the necessary information should be displayed. The confirmation page should carry an order ID for future reference by the shopper.
- Update the inventory level in the database accordingly once the order is confirmed,
Additional Requirements
- Check to ensure that the quantity of purchase for any product should not be more than the quantity in stock during checkout.
- Calculate tax payable based on the current GST rate retrieved from the database.DEMONSTRATION
You are required to demonstrate your online store (using the submitted copy) to your tutor during the time-tabled classes of weeks 15 and 16. Your tutor will inform you of the schedule for demonstration. Each member of the team is expected to conduct the demonstration of his functional area. The duration of the demonstration for each team should be kept within 40 minutes for a 4-person team, and 30 minutes for a 3-person team.
During the demonstration, you will be expected to explain the functionality of your own functional area as well as that of the system as a whole. Your tutor will ask you relevant questions to test your understanding of eCommerce application and PHP coding.
Attachment:- CAD2016 Assignment.pdf