StyleUE – DBMS Project

StyleUE is a database-driven web application designed as a college-level DBMS project. It showcases the integration of front-end technologies with a robust SQL backend to manage user interactions, transactions, and embedded queries.

📌 Project Overview

This project demonstrates the use of:

• SQL for database schema design, triggers, and transactions
• Python for backend logic and embedded queries
• HTML/CSS/JavaScript for the user interface
• Node.js (via package.json) for dependency management

The application simulates a fashion or e-commerce platform where users can interact with a styled interface and perform various database operations.

🗂️ Features

• User-friendly web interface
• Embedded SQL queries for dynamic data retrieval
• Transaction management using SQL scripts
• Trigger-based automation for database events
• Modular Python scripts for backend logic

🛠️ Tech Stack

Layer	Technology
Frontend	HTML, CSS, JavaScript
Backend	Python
Database	MySQL (SQL scripts)
Tools	Node.js, npm

📁 Folder Structure

├── templates/              # HTML templates
├── EmbeddedQueries.py      # Python script for embedded SQL queries
├── main.py                 # Main backend script
├── *.sql                   # SQL scripts (schema, triggers, transactions)
├── utils.css               # Custom CSS
├── script.js               # JavaScript for frontend interactivity
├── User Guide.pdf          # Documentation for usage
├── TRANSACTIONS_-.pdf      # Sample transaction report

🚀 Getting Started

1. Clone the repository:

   git clone https://github.com/SanyamBK/DBMS-Project--StyleUE.git
   cd DBMS-Project--StyleUE

2. Set up the database:

   • Import styleu.sql or database.sql into your MySQL server.
   • Run trigger.sql and transactions.sql to enable triggers and transactions.

3. Run the backend:

   python main.py

4. Open roufgh.html or other templates in your browser to interact with the UI.

📄 Documentation

Refer to the included User Guide.pdf for detailed instructions on using the application and understanding its database structure.

👨‍💻 Contributors

• @SanyamBK
• @prithuchauhan
• @Anikait1807
• @aditripaweria

---