A complete full-stack implementation for learning database management systems (DBMS) and web development. Built with vanilla JavaScript for maximum educational value.
- 6 Normalized PostgreSQL Tables (Users, Products, Orders, etc.)
- Complex SQL Queries with JOINs and transactions
- Secure Authentication with password hashing
- Node.js/Express RESTful endpoints
- JWT Authentication middleware
- Error Handling for database operations
- Pure JavaScript DOM Manipulation
- LocalStorage Cart with DB synchronization
- Modal-Based UI (No page reloads)
- Database: PostgreSQL 15+
- Backend: Node.js 18+, Express 4.x
- Frontend: Vanilla JavaScript, CSS3, HTML5
- PostgreSQL 15+ (Install Guide)
- Node.js 18+ (Install Guide)
- Clone the repository
git clone https://github.com/umer33511/ecommerce-dbms-system.git cd ecommerce-dbms-system
- Database Setup
psql -U postgres -f sql/schema.sql psql -U postgres -f sql/seed.sql
- Configure Environment
Edit.env with your PostgreSQL Credentials
- Install Dependencies
npm install
- Run the Application
npm start
Access at: http://localhost:3000
-
Understand relational database design
-
Practice SQL query optimization
-
Learn REST API development
-
Master client-server communication
├── sql/ │ ├── schema.sql # Database schema │ └── seed.sql # Sample data ├── server/ # Node.js backend ├── public/ # Frontend ├── css/ ├── js/ └── test3.html
-
Report bugs as GitHub Issues
-
Fork & submit Pull Requests
-
Keep code style consistent
-
"Can't connect to PostgreSQL?" → Verify credentials in .env
-
"npm install fails?" → Try npm cache clean --force
-
"Missing modules?" → Delete node_modules and re-run npm install
MIT License - See LICENSE file
For educational inquiries: [email protected]
Project Link: https://github.com/umer33511/ecommerce-dbms-system