CS506 Assignment 3 100% Correct Solution Fall 2019 - 2020

CS506 Assignment No 3 Fall 2019

Dear Students, Here you can read or download CS506 - Web Design and Development Assignment No 3 Solution of Semester Fall 2019 but Year 2020. The Assignment Due Date is 17 January 2020. Total Marks are 20. CS506 Assignment Solution and Sample Preview will be added Soon. This assignment covers Lecture No 1 to 30. Previously we shared CS506 Assignment No 1 Solution Fall 2019.

CS506 Assignment No 3 Solution Fall 2019 Year 2020

CS506 Assignment 3 Uploading Instructions:

• You are not allowed to use any other software/IDE except NetBeans IDE for this assignment development.
• The submission must be a complete NetBeans IDE project folder (which should contain complete source code; Java files, servlet files, HTML files, database file, XML files and builds, etc.). After finalizing, compress it with .zip or .rar format, save with your own Student ID (e.g. bs1234567890.zip) and submit it at VU-LMS within the due date.
• Your assignment should be in .zip /.rar format. Other file formats will not be accepted.
• No assignment will be accepted through email.

Also Read: ISL201 Assignment No 2 Solution Fall 2019 - the Year 2020

CS506 Assignment 3 Rules for Marking:

It should be clear that your assignment will not get any credit if:

• The assignment is submitted after the due date.
• The assignment is not submitted in .zip/.rar format.
• The submitted assignment does not open or file is corrupted.
• The assignment is fully or partially copied from other students or ditto copy from handouts or the Internet; strict disciplinary action will be taken in this case.
• The submitted code is unable to compile/execute in NetBeans IDE; during the evaluation, submitted code will be checked on NetBeans IDE. If unable to execute then ZERO marks will be awarded and no excuses will be accepted in this regard.

Also Read: ENG201 GDB No 1 Solution Fall 2019 - the Year 2020

CS506 Assignment Problem Statement:

You are required to deploy a basic web application using Apache Tomcat Server, named ShoppingCart, for a typical online shopping system. In which a customer can add/remove items to the shopping cart and proceed to place an order. The program should calculate the total bill and display the amount via a web page. Further, all orders will be saved in a backend database using MS Access so that the administrator could process accordingly.

Detailed Description:

The program should facilitate at least one user i.e. Customer. For this purpose, you have to develop an HTML page (index.html) which should contain a login form, as shown in figure 1.

The customer should be able to login by using student id (must be your own student id) as username and "vu" as password.

Figure 1: Sample Login Page (index.html)

Now, write a Java Servlet named LoginServlet.java that will receive submitted information from login form (i.e. index.html) and verify input values; whether entered values are correct or not. If authentication is invalid then print back a message "Invalid Username or Password".

Figure 2: Sample Shopping Cart (ShoppingCartServlet.java)

If customer credentials (i.e. username and password) are correct, jump to Shopping Cart Page (i.e. ShoppingCartServlet.java) which should list down all available products (i.e. products having one or more items), as shown in above figure 2.

Here, customers can provide the quantity of desired product/s and click on the Check Out button. If no item is selected (i.e. no quantity is provided), then a message "Cart is empty" should be displayed.

On the other hand, if the cart is not empty, Checkout Page (i.e. CheckOutServlet.java) should serve the customer by displaying total bill, shipping charges along with no. of products & items, etc. and also provide an input field for shipping address, as shown in figure 3.

Figure 3: Sample Checkout Page (CheckOutServlet.java)

To place an order, the customer must provide the shipping address and click on the Place Order button. Before displaying a message "Order has been placed successfully.”, the program must save order details (i.e. no. of items, subtotal, shipping charges, grand total, shipping address, and selected products with quantity) in corresponding database tables. Further, you need to maintain the number of products in the database so that the customer could not see out of stock products in the next shopping.

Figure 4: Sample About Us Page (info.html)

Button "Go Back" should take back on the Shopping Cart Page. However, customers can sign out from the system by pressing the "Logout" button. In this case, web developer information (student id, name, and email address) should be displayed via an HTML page (info.html), as shown in figure 4.

Figure 5: Folder "assets" under the web directory

CS506 Assignment Required Stuff:

Html Pages:

• index.html
• info.html

Java Servlets:

• LoginServlet.java
• ShoppingCartServlet.java
• CheckOutServlet.java

Java Classes:

• Product.java
• Cart.java
• Order.java
• OrderDetail.java
• DatabaseHelper.java (must contain all database related code)

Database file:

• BSxxxxxxxx.accdb (must be same as your own VU student id)

Shipping Charges:

• Shipping Charges ($) = ((no. of Items / 5) + 1) * 0.5

Sample Data & Database Tables:

S No.	Name	Price	Quantity
1	Flour	$18.00	20
2	Oil	$19.00	50
3	Ghee	$10.00	0
4	Sauce	$22.00	40
5	Sugar	$21.35	35
6	Salt	$25.00	26
7	Daal	$30.00	38
8	Rice	$40.00	92
9	Pasta	$97.00	63
10	Fruits	$35.00	72
11	Dry Fruits	$31.00	70
12	Tea	$21.00	12
13	Coffee	$38.00	9
14	Milk	$10.00	10
15	Snacks	$23.25	13
16	Dessert	$15.50	22
17	Vegetables	$17.45	52
18	Chicken	$39.00	98
19	Beef	$62.50	0
20	Frozen Food	$19.20	30
21	Sea Food	$81.00	29
22	Sweet	$10.00	29
23	Cake	$21.00	0
24	Yogurt	$26.00	0
25	Pickle	$30.00	41

Products Table in MS Access Database

Orders Table in MS Access Database

Order Details Table in MS Access Database

Video Tutorials for CS506 Assignment Help: 

• To download and install of Tomcat Server, please watch;

Click Here to Watch

• To create a web application project in NetBeans IDE, please watch;

Click Here to Watch

• To add ucanaccess driver in a NetBeans project, please watch;

Click Here to Watch

Important Things to Implement in CS506 Assignment:

• You have to provide separate pages, servlets, java files and database tables as guided above. Merging of two or more will result in the deduction of marks.
• You need to put a database file in assets folder under NetBeans project web directory along with HTML pages, as shown in figure 5.
• For storing/fetching data to/from the database, you will need to use proper SQL queries.
• You can use the same Product and Cart Java classes as provided in assignment # 1 & 2 and also can make changes as required.
• Java classes must have proper Data Members and Member Functions along with Constructors, Standard Setters and Getters, etc.
• You need to make sure that exceptions are managed properly throughout the program; especially NullPointerException, ClassNotFoundException, NumberFormatException, and SQLException, etc.
• All images, tables and sample data, given in this document, are just for reference purposes only; you have to provide your own implementations. It is not required to be exactly the same.

CS506 Assignment No 3 Solution Fall 2019

You can see the Sample Preview of CS506 Assignment No 3 Solution provided by (Virtual Study Solutions) below. Click on Download Button to Download Solution File in Your PC. Please Share it with your friends. You can also like our Facebook Page or Subscribe Us on YouTube for Latest Updates related to Assignment Solution and Past Papers.

Also Read: BIF401 Assignment No 2 Solution Fall 2019 the Year 2020

We also recommend you to read:

CS506 Final Term Past Papers Collection

File Name	Download Link
CS506 Final Term Papers Collection	Download

Please Note:

We are here to facilitate your learning and we do not appreciate the idea of copying or replicating solutions.

Recommended: How to avoid Plagiarism or Zero Marks in Assignments

CS506 Correct Solution Explanation 2020

Download CS506 100% Correct Assignment 3 Solution 2020

File Name	Download Link
CS506 Assignment 3 Correct Solution.zip	Download

Please Note: You should change your VU Student ID i.e., bs123xxxxxxx
before submitting this Assignment Solution.

Disclaimer:

First Run the Solution - Test it and then submit it.we will not be responsible in the case of Zero Marks. 2 Idea Solution files have been given above. test them both before Submitting.

Share your valuable feedback in the comments section. Thank You.