CSC 3140 EAU W12 Advanced Programming Techniques Project

Unit CodeUnit Title
Semester
CSC 3140
Advanced Programming Techniques
Fall 2021
Assessment Type
Assessment Title
Purpose of the
assessment (with
CLO Mapping)
Individual Assignment
Accessing and updating a Users table (Servlets and JDBC)
This assignment is designed to assess students’ knowledge and skills related to the
following learning outcomes:
Weight
Total Marks
Word limit
Submission
Guidelines
10% of the total assessments
100
NA
• All work must be submitted on Moodle by the due date along with a cover page.
• The assignment must be in MS Word format, 1.5 spacing, 11-pt Calibri (Body) font
and 2.54 cm margins on all four sides of your page with appropriate section
headings.
• Reference sources must be cited in the text of the report and listed appropriately
at the end in a reference list using IEEE or Harvard referencing style.
Week-12, 18th November 2021 – submit your report on Moodle and CodePost
• Late project submissions will result in a penalty. A one-week late submission
results in a 10% deduction on the project marking; while a project submitted
between 1 and 2 weeks late will be subject to a 20% deduction on the project
marking. Submissions after two weeks will be considered a fail on the project.
• Plagiarism is defined as the presentation of another person’s work as your own.
This includes copying from books without referencing the material or copying
from another student’s work
Assessment Details and Submission Guidelines
Due Date
Late submission
Academic
Misconduct and
Plagiarism
Instructor Name
Moderator
1. LO-3: Use JDBC drivers and advance programming concepts in database
2. LO-4: Apply server-side technologies using JSP.
Dr.Mostafa Kamil
Dr Blessy
Assignment Description
(Servlets and JDBC)
Write a servlet that enables the user to update his first name and last names from an HTML form.
The servlet performs the following tasks:
• Verify that the user filled in all the fields in the HTML form. If the user missed any of these
fields, the servlet will show an error message. As shown in figures 2 and 3 below.
• Verify the username and password. If the user enters an incorrect username or password
servlet will show an error message. As shown in figures 4 and 5 below.
• If all user information is entered correctly, Servlet will update the user’s last and first names
in the database and show a confirmation message. As shown in Figures 6 and 7 below.
Suppose the user information is stored in a database table named users with four columns: firstname,
lastname, username and password.
The user table is defined as follow :
Figure-1: Users table
Note: after creating the users table, enter some demo information to be used for testing.
Figure-2: User missed one field
Figure-3: Servlet error message for missing one or more fields
Page 2 of 6
Figure-4: User entered incorrect username or password
Figure-5: Servlet shows an error message
Figure-6: User entered correct information
Page 3 of 6
Figure-7: Servlet shows a confirmation message
(LO-3 and LO-4)
Submission Requirements
1. Signed Assignment cover sheet.
2. Report
a. Cover page.
b. Table of contents.
c. Introduction
d. Project (Servlets and JDBC)
i. Analysis and Design
1. Describe the steps for solving the problem (to be submitted on Turnitin).
ii. Screenshots of the database (users table).
iii. Screenshots of the demo data in the database.
iv. Explain the HTML codes.
v. Explain the SQL queries used in the project.
vi. Explain the JAVA codes. Copy and paste the source code in the word file.
Format your code using Courier 10pts.
vii. Describe how you test this project; provide samples of the outputs and updated
database.
viii. Submit the JAVA files on Moodle and codePost.
3. Turnitin report.
Marking criteria:
Marking criteria is shown in following tables:
(Servlets and JDBC)
Sections to be included in
the report
Analysis
Design
Database
Page 4 of 6
Description of the section
Describe the problem, including input and output in your
own words
Describe the major steps of solving the problem. Also, how
the design solves the synchronization problem.
Database implementation
Marks
10
10
10
HTML
Design the User interface
10
Database Queries
Explain the SQL queries used in the project
20
Coding
The code should be fully running.
Explain the implementation steps
20
Testing
Describe how you test this program with examples
15
Cover page, and table of
contents and the organization
of the report
Write a Cover page, and table of contents, and Ensure
everything is typed using a word processor and organized
well.
Total
5
100
Marking Rubric for Assignment-1: Total Marks 100
Note: The marking rubrics varies for each assignment
Mark
80-100
70-79
60-69
50-59