Project Proposal

Web-Based Vehicle
Spare Parts
Management System

Project Group : B7G2-10
Group Members
Hathurusinghe H.D.V.IT25101623
Herath H.M.C.K.IT25102452
Sathursan S.IT25103491
Perera S.K.A.N.I.IT25101379
Namarathna N.B.A.D.M.A.IT25103288
Gunawardhana K.C.IT25100474
What we will cover

Presentation Outline

Section 01

Project Overview

01

Web-Based Vehicle Spare Parts Management System

Replaces Excel sheets and paper records
Centralized real-time database
Java Web Application
MySQL Database

Company Problems

Manual records
Stock mismatches
Delayed updates
Difficult purchase tracking
No reliable reporting
Section 01 · Product overview

What we propose

02

One web application, used from a browser on the company network. Stock, sales, purchasing, customers and returns share a single database and update in real time.

Section 01 · Objectives

Eight objectives

02
Section 02

Scope

02

In Scope

Browser-based application
Six integrated modules
MySQL database
Reports
Role-based login
Alerts

Out of Scope

Online payments
Customer portal
Mobile app
Multi-branch support
Accounting integration
Section 03

System Overview

03
Browser-based Java application
Six integrated modules
Shared MySQL database
AdministratorInternal user
ManagerInternal user
Store StaffInternal user
Sales StaffInternal user
Customers & SuppliersExternal · no accounts
Web browserClient interface · JSP pages
Access controlLogin · role permissions · session
Application server · Java web application
InventoryParts & stock
SalesOrders & invoices
PurchasingSupplier orders
CustomersOrder lifecycle
ReturnsClaims & alerts
AdministrationUsers & logs
Data access layer · JDBC / DAO
ReportsPDF and Excel export
MySQL databaseParts · orders · users · logs
AlertsLow stock · deliveries
Section 04 · Functional requirements

26 functions, six modules

05

Every requirement carries an identifier 3.x.x, so it can be traced from this proposal through design, implementation and testing.

26
Functional requirements
6
Core modules
9
Quality attributes
13
Shared minor functions
Section 04

Functional Requirements (1/2)

04

Inventory

Manage parts
Search inventory
Update stock
Low-stock alerts

Sales

Create sales orders
Check live stock
Print invoices
Cancel orders

Supplier & Purchasing

Supplier profiles
Track purchase orders
Goods receipts
Supplier history
Section 04

Functional Requirements (2/2)

05

Customer & Order

Customer profiles
Order tracking
Purchase history
Inquiries record

Returns & Notifications

Process returns
Classify conditions
System alerts
Delivery notifications

User Management & Reports

Manage roles
Enforce permissions
Activity logs
Generate reports
Section 05 · Non-functional requirements

Measurable quality targets

06
Section 06

Stakeholders

07

Internal Users

Administrator

User management
Permissions
Logs

Manager

Dashboard
Reports

Store Staff

Inventory
Purchasing

Sales Staff

Sales
Customer Orders

External Stakeholders

Customers

Purchase parts
Returns

Suppliers

Deliver products
Purchase orders
Section 07 · Major functions

Six modules, one owner each

08

One module per member — requirements, design, implementation, testing and demonstration.

Section 07 · Major functions

Inventory, sales and purchasing

Modules 1 – 3
Section 07 · Major functions

Customers, returns and administration

Modules 4 – 6
Section 08 · Minor functions

Shared supporting features

09

Used across every module and owned by the group as a whole.

Section 09 · Limitations

Constraints and assumptions

10
Section 10 · Timeline

Week 3 to Week 14

Agile · Scrum sprintsShared backlog & board
Week 10
Progress demo at ~75% complete, design document submitted
Week 13
Final presentation, demonstration and viva; final report
Week 14
Final source code and documentation submitted
Section 11

Conclusion

11
Eliminates manual records
Improves inventory accuracy
Faster operations
Better reporting
Agile team development

"Delivering a reliable, centralized and scalable spare parts management system."

Project Group : B7G2-10

Thank you

We are happy to take your questions.
Gunawardhana K.C.Perera S.K.A.N.I.Hathurusinghe H.D.V. Namarathna N.B.A.D.M.A.Sathursan S.Herath H.M.C.K.
Web-Based Vehicle Spare Parts Management System
1 / 20

All slides

Web-Based Vehicle Spare Parts Management System Proposal