HO CHI MINH CITY UNIVERSITY OF TECHNOLOGY AND EDUCATION
FACULTY OF INTERNATIONAL EDUCATION

CAPSTONE PROJECT

CREATING A WEBSITE AND APPLICATION
FOR GOLD, SILVER AND GEMSTONE ENTERPRISE

ADVISOR:

MAI ANH THƠ, PhD

STUDENTS: Lê Chí Thông
Trần Minh Quang

Ho Chi Minh, December 2024

17110078
17110067

HO CHI MINH CITY UNIVERSITY OF TECHNOLOGY AND EDUCATION
FACULTY OF INTERNATIONAL EDUCATION

CAPSTONE PROJECT

CREATING A WEBSITE AND APPLICATION
FOR GOLD, SILVER AND GEMSTONE ENTERPRISE

ADVISOR:

MAI ANH THƠ, PhD

STUDENTS: Lê Chí Thông
Trần Minh Quang

Ho Chi Minh, December 2024

17110078
17110067

SOCIALIST REPUBLIC OF VIETNAM
Independence - Freedom – Happiness
*******
Ho Chi Minh City, December, 2024

CAPSTONE PROJECT OBJECTIVES

Students’ names:
1.

Lê Chí Thông

ID:17110078

Class: 17110CLA1

2.

Trần Minh Quang

ID:17110067

Class: 17110CLA4

Major: Software Engineering
Instructor: PhD. Mai Anh Thơ
Date of assignment: 02/09/2024

Date of submission: 12/12/2024

1- Project title: Creating a website and application for gold, silver, and

gemstone enterprise
2- Initial materials provided by supervisor: None
3- Content of the project:
Theory:
-

Nextjs

-

Nodejs

-

Expressjs

-

PostgreSQL

Practice:
Creating an Online Gold Store Management Web Application with Advanced Features:
 Efficient Management for Staff and Managers:

Allow managers to oversee staff accounts, orders, gold products, and categories efficiently
within the system.
 CRUD Operations on Gold Products and Categories:

Empower managers to perform , Read, , and (CRUD) operations on
gold product and category information to ensure up-to-date inventory management.
 Order Status Management:

Enable staff to review and the status of customer orders, ensuring a smooth
workflow for handling buy-ins, sell-outs, and other transactions.
 Product Search and Details:

Allow staff to search and view detailed gold product information, such as gold type, weight,
and pricing, to assist customers effectively.
 Transaction History:

Provide managers with the ability to track transaction history and performance insights to
make informed business decisions.
 Internal Notifications for Staff and Managers:

Notify staff about s on orders or tasks to ensure efficient workflow and seamless
communication between team members.
 Payment and Reconciliation Tracking:

Enable staff to track payment methods, including VNPay and PayPal, and ensure accurate

...

...
ations requires significant time and
expertise.
 Maintenance Effort: Regular s and troubleshooting of advanced features
like real-time notifications and API optimization may require ongoing developer
involvement.
 Resource Demands: The platforms advanced features, such as analytics and realtime tracking, may require higher server and database resources, potentially
increasing operational costs.

8.3. Development
 Designing user-friendly interfaces and implementing back-end functionalities
provided a comprehensive learning opportunity.
 On the front end, we worked with responsive design principles to a seamless
experience across web and mobile platforms.
 On the back end, we implemented features like role-based access controls, inventory
management, and real-time s.
 We focused on robust API integration, database optimization, and security
measures.
 Testing and iteration ensured the application was reliable and met user needs.

116

Work Distribution

Work Distribution
Table 0-1: Work Distribution

Student
Lê Chí Thông

Trần Minh Quang

Deion
1. Write code FE
2. Write code BE (30%)
3. Design and write report
Deploy website to host
1. Write code BE (70%)
2. Design and write report
3. Summarizing content of
the reports
4. Test program

Report Assignment
Demo program

117

References

REFERENCES
[1]. Mozilla Developer Network. (n.d.). Introduction to HTML and CSS.
https://developer.mozilla.org
[2]. Next.js Documentation. (n.d.). Next.js – The React Framework for Production.
Vercel. https://nextjs.org/docs
[3]. PostgreSQL Global Development Group. (n.d.). PostgreSQL Documentation.
https://www.postgresql.org/docs
[4]. Node.js Foundation. (n.d.). Node.js Documentation. https://nodejs.org/en/docs
[5]. Tailwind

CSS.

(n.d.).

Tailwind

CSS

Documentation.

https://tailwindcss.com/docs
[6]. TypeORM. (n.d.). TypeORM Documentation. https://typeorm.io
[7]. Recharts. (n.d.). Recharts – Simple React Charting Library. https://recharts.org/
[8]. Medium. (n.d.). Building a Full-Stack Application Using the PENN Stack.
https://medium.com/
[9]. Medium. (n.d.). Best Practices in Type Development. https://medium.com/
[10]. Medium. (n.d.). Building Robust Clean Architecture with Type
https://medium.com/
[11]. PostgreSQL Global Development Group. (n.d.). PostgreSQL Documentation.
https://www.postgresql.org/docs/
[12]. Medium. (n.d.). Best Practices for Optimizing PostgreSQL Databases.
https://medium.com/

118