TECHWORLD

Techworld is an e-commerce website developed as part of a Database course project focusing on handing database queries and building an interactive UI around it. The website focuses on selling PCs, PC components, and other related devices. It implements extensive database operations, including complex SQL queries and PL/SQL programming.

Features

• PC-BUILDER: A core feature that allows users to customize and build their own PCs by selecting components such as motherboards, processors, RAM, storage, and power supplies.
• User Authentication: Secure user authentication using sessions and cookies.
• Product Management: Add, remove, and update products in the inventory.
• Brand Management: View and manage brands, including adding new brands and updating existing ones.
• Order Management: View order history and previously selected products.
• Admin Panel: Admin functionalities to manage users, products, brands, advertisements, and breaking news.

Technologies Used

• Node.js: JavaScript runtime environment used for server-side development.
• Express.js: Web application framework for Node.js, used to build the backend API.
• EJS (Embedded JavaScript): Templating engine used to generate HTML markup with plain JavaScript.
• PostgreSQL: Relational database management system used for storing and managing data.
• Oracle DB: Database management system used for complex SQL queries and PL/SQL programming.
• Bootstrap: Front-end framework used for responsive design and styling.

Frontend Codes can be found in the 'templates' directory.

Installation

1. Clone the repository:

   git clone https://github.com/your-username/techworld.git

2. Navigate to the project directory:

   cd techworld

3. Install the dependencies:

   npm install

4. Start the server:

   npm start

Usage

• Access the website at http://localhost:3000.
• Use the PC-BUILDER feature to customize and build your own PC.
• Admin users can manage products, brands, advertisements, and breaking news through the admin panel.