SkyLine Airlines - DBMS System
Airline reservation system with Flask and PostgreSQL featuring advanced SQL queries and booking management.
- Role: Developer
- Timeline: September 2021 - December 2021
- Team: DBMS Course Project (2 members)
- Technologies: Flask, PostgreSQL, HTML/CSS, SQL
- Link: https://github.com/Laxman824/Dbms-Project
Problem
Database management course project requiring demonstration of advanced SQL concepts: complex joins, triggers, stored procedures, and transaction management in a real-world application.
Solution
Built a complete airline reservation system showcasing: flight search with multi-stop routing, seat inventory with overbooking, dynamic pricing, loyalty program, and comprehensive admin reporting.
Impact
- Comprehensive DBMS demonstration
- Complex SQL query optimization
- Transaction management implementation
- Top grade in DBMS course
Key features
- User registration with hashed passwords
- Flight search with filters
- Multi-city routing algorithm
- Seat selection with class options
- Dynamic pricing based on demand
- Booking confirmation and e-tickets
- Loyalty points system
- Admin reports and analytics
Tech stack
- Frontend: HTML, CSS, Jinja2, Bootstrap
- Backend: Python, Flask, SQLAlchemy
- Database: PostgreSQL, Stored Procedures, Triggers
- Tools: pgAdmin, Postman
What K Laxman learned
- Advanced SQL query optimization
- Database normalization principles
- Transaction ACID properties
- Building database triggers and procedures
Explore more
- Home — overview, skills and a built-in AI assistant
- Experience — roles at Think360 AI (CAMS), CAMS Mutual Funds and IIT Delhi
- Projects — GenAI, LLM, RAG and full-stack builds
- Education — IIT Delhi, M.Tech & B.Tech Computer Science
- GitHub Activity — open-source contributions
- Contact / Hire me