College of Computing and InformaticsProject
Deadline: Tuesday 14/02/2023 @ 23:59
[Total Mark is 14]
Student Details:
CRN:
Name:
Name:
Name:
Name:
ID:
ID:
ID:
ID:
Instructions:
• You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on
Blackboard via the allocated folder. These files must not be in compressed format.
• It is your responsibility to check and make sure that you have uploaded both the correct files.
• Zero mark will be given if you try to bypass the SafeAssign (e.g. misspell words, remove spaces between
words, hide characters, use different character sets, convert text into image or languages other than English
or any kind of manipulation).
• Email submission will not be accepted.
• You are advised to make your work clear and well-presented. This includes filling your information on the cover
page.
• You must use this template, failing which will result in zero mark.
• You MUST show all your work, and text must not be converted into an image, unless specified otherwise by
the question.
• Late submission will result in ZERO mark.
• The work should be your own, copying from students or other resources will result in ZERO mark.
• Use Times New Roman font for all your answers.
Description and Instructions
Pg. 01
Description and Instructions
Project Objective:
This project is an opportunity for you to practice your knowledge to develop a dynamic
web application using PHP, MySQL, and any web development technologies introduced
in this course. It also allows you to develop skills for working in teams.
Project Description (Online Inventory Web Application):
A local auto company has asked you to create an online inventory web application that
allows them to manage the company’s inventory which includes sales of both new and
used vehicles. Your web application must provide the following specifications in each
part:
• Part (A)
A database will store the information of each vehicle, which includes VIN, maker,
model, year, color, mileage, and price. VIN is the Vehicle Identification Number, which
is unique for each vehicle. Also, store a picture of each vehicle in the database along
with the rest of its information.
• Part (B)
Any user can search the online inventory web application and explore the information
on the listed new and used vehicles.
• Part (C)
A manager can update the inventory. She/he needs to log in by enter the identifying
information (username and password). Once given access to the application, she/he can
add a new vehicle, and delete an existing vehicle. Also, a manager can update an existing
vehicle’s information except for its VIN.
Note: Make sure to validate the data entry.
Description and Instructions
Pg. 02
Project Guidelines and Tools:
You are allowed to use any web development technologies that only introduced in this
course to build your application.
Download the XAMPP server by following the link.
Download XAMPP (apachefriends.org)
Submission Guidelines:
1. The work on this Project must be performed by a group, minimum 2 or maximum
4 students.
2. You are required to submit the report and the source code on or before the due
data via BlackBoard.
3. Only the Group Leader must submit the report and the source code via
BlackBoard. However, the names and IDs of all the group members should
appear on the report.
4. submit the source code and all your application related files in a separate zip file.
Do not forget to document (comment) on your code.
Description and Instructions
Pg. 03
5. Work should be your own, copying from students or other resources will
result in ZERO marks.
6. You MUST show all your application code as text, code must not be converted
into an image.
7. You are advised to make your work clear and well presented; marks may be
reduced for poor presentation. This includes filling your information on the cover
page.
Marking Criteria:
Part (A) is achieved and error-free
/3
Part (B) is achieved and error-free
/2
Part (C) is achieved and error-free
/5
Web application data visualization is achieved
/1
The code is well documented (commented)
/1
The report is well-presented
/1
Output screenshots in the report
/1
Total
/14
Answer
Pg. 04
Learning
Outcome(s):
CLO1: Describe
methods and
tools in designing
a creative and
dynamic website
CLO3: Create
web databases
using MySQL
Answer
14 Marks for project
1. Brief description
Provide a brief description of your application in this section.
2. Screenshots
Put the different screenshots of your application with a brief description in this
section (at least 8 screenshots).
CLO4: Build web
applications using
PHP and MySQL
3. Program code
Put the code of your application in this section. Also, submit the source code in
a separate zip file. Do not forget to document (comments) on your code.
Note: Code should be textual, screenshots are not acceptable.