Hamro Books

Overview

Hamro Books is an online book shopping store where customers can buy books of various kinds. This Database Management System (DBMS) project was developed as part of a lab-project of DBMS subject of our SEM V to showcase the integration of frontend, backend, and database management.

Project Team

• Pankaj Bhatt (THA078BEI025): Frontend Design + Database Insertion
• Pratik Pokharel (THA078BEI027): Backend Design + Database Creation
• Subham Gautam (THA078BEI042): Frontend Design + Database Management

Technologies Used

• PostgreSQL: For creating and managing the database.
• Node.js: For developing the backend server and linking it to the database.
• HTML, CSS, JavaScript: For designing the front-end webpages.

Hosting

The entire system, including the database, backend, and frontend, is hosted on Render.com.

Features

Customer Page

• Registration: Customers can register by providing their username, password, full name, email, mobile number, and address on the login page.
• Login: Customers can log in using their username and password.
• Book Search: Customers can search for books of various kinds.
• Categories: Browse through different categories of books.
• Book Details: View detailed information about specific books.
• Shopping Cart: Add books to the cart and proceed with the purchase.
• Profile Management: Customers can access their profile and log out.

Seller Page

• Registration: Sellers can register by providing their username, password, full name, email, mobile number, and address on the login page.
• Login: Sellers can log in using their username and password.
• Book Management: Sellers can search for, add, manage, and delete books.
• Order Management: Sellers can view customer orders and accept or remove them.
• Profile Management: Sellers can access their profile and log out.

Database Synchronization

Any changes made to both the customer and seller pages are automatically updated in the database, ensuring data consistency.

Getting Started

Prerequisites

• PostgreSQL: Ensure you have PostgreSQL installed for database management.
• Node.js: Install Node.js to run the backend server.
• Web Browser: A modern web browser like Chrome, Firefox, or Edge.

Installation

1. Clone the repository:

   git clone https://github.com/pratik-writer/Hamro-Books.git

2. Navigate to the project directory:

   cd Hamro-Books

3. Install dependencies:

   npm install

4. Set up the database:

   • Create a PostgreSQL database.
   • Run the SQL scripts provided in the db folder to set up the database schema and insert initial data.

5. Start the backend server:

   npm start

6. Access the website: Open your browser and go to Hamro Books.

Usage

• Customer Page: Register or log in to explore books, add them to your cart, and make purchases.
• Seller Page: Register or log in to manage your book listings and process customer orders.

Links

• Website: Hamro Books
• GitHub Repository: Hamro Books on GitHub
• Demo Video: Watch Demo

Contributing

Contributions are welcome! Please follow these steps:

1. Fork the repository.
2. Create a new branch (git checkout -b feature-branch).
3. Make your changes.
4. Commit your changes (git commit -m 'Add some feature').
5. Push to the branch (git push origin feature-branch).
6. Open a pull request.

License

This project is not yet licensed.

Contact

For any inquiries or feedback, please reach out to:

• Subham Gautam: gautamsubham65@gmail.com
• Pratik Pokharel: pratikpokhrel14@gmail.com
• Pankaj Bhatt: pankajbhattcoc16@gmail.com