Subject & Section: CTINFMGL - COM231
Professor: 👩 Jensen A. Santillan
No. of Units: 3 Units
Prerequisite: CCDATRCL - Data Structure and Algorithm
Course Repo: CTINFMGL - INFORMATION MANAGEMENT
A flight booking web application designed to simplify the process of booking flights with the used of modern JavaScript techstacks
Overview The Flight Booking App is a web application designed to simplify the process of booking flights for users. The app allows users to search for flights, book tickets, manage their itineraries, and make payments seamlessly. The app also includes an admin panel for managing flights, users, and payments. The goal is to provide a user-friendly, efficient, and secure platform for flight bookings.
🚀 1. User Authentication: Users can create accounts, log in, and manage their profiles.
🚀 2. Flight Search: Users can search for flights based on destination, departure time, and other criteria.
🚀 3. Booking Management: Users can book flights, view their bookings, and cancel or modify them.
🚀 4. Payment Integration: Secure payment gateway integration for processing payments.
🚀 5. Admin Panel: Admins can manage flights, users, and payments.
- Frontend: React.js or Next.js (JavaScript)
- Backend: Node.js with Express.js or NestJS (Node.js framework)
- Database: PostgreSQL (Recommended for its robustness and scalability; If we choose SQL standard; It depends on the flow and overall decicion)
- Database: MySQL for flexible use of SQL
- Authentication: JWT (JSON Web Tokens)
- Payment Gateway: Stripe or PayPal ( Not required!)
- State Management: Redux or Context API
- Styling: CSS-in-JS (Styled-components) or Tailwind CSS
- Deployment: Vercel (for Next.js) or Heroku or Dokploy
https://dokploy.com/#pricing)
Run npm install to to install node modules
npm install
Direct to frontend folder after you install the node modules
cd frontend
npm start
Open another terminal in the current codebase to run nodejs for VS Code or other IDE base on what you are using such as Webstorm
cd backend
node index.js
See Database folder above
sql
INSERT INTO `flights` (departure_city, arrival_city, flight_date, duration_hours, base_price, flight_status) VALUES
('New York', 'London', '2024-11-10', 7, 500.00, 'Full'),
('Los Angeles', 'Paris', '2024-11-11', 10, 900.00, 'Available');
INSERT INTO `users` (username, password_hash, role, email, phone_number) VALUES
('akosidogi', '$2b$10$yFTXogxecYrNSRLvFMb.dej4A4snSkHF72ZLItUjwrDFT16tlHCvK', 'admin', 'admin@example.com', '1234567890');
INSERT INTO `carts` (flight_id, user_id) VALUES
(1, 1);
INSERT INTO `seats` (flight_id, seat_number, class, status, seat_price) VALUES
(1, '1A', 'Economy', 'Available', 100.00),
(1, '1B', 'Economy', 'Booked', 100.00);
INSERT INTO `flight_names` (flight_id, region, name) VALUES
(1, 'Europe', 'Transatlantic Express');
Description Coming Soon
Entity Attribute Value Model will be uploaded in this section file after 💥 Myckle Vince fininish the Normalization
Full Overview of Normalization is in the Folder of documentation
Coming Soon
If you would like to contribute to the Flight Booking App, please follow these steps:
- Fork the repository.
- Create a new branch for your feature or bug fix.
- Make your changes and commit them.
- Push your changes to your forked repository.
- Submit a pull request to the main repository.
🧠 Contributions are welcome! If you have ideas for improvements or want to add more exercises, follow these steps:
- Fork the repository.
- Create a new branch.
- Make your changes and commit them.
- Push to your fork and submit a pull request. 💕💕💕💕
-
😎 Jay Arre Talosig - Machine Learning Engineer | Blockchain Developer | Bioinformatics Scientist
-
🧭 Custer Valencerina - Machine Learning Engineer | Full Stack Engineer | Front-End Developer
-
💥 Myckle Vince Natividad - Cybersecurity Forensic Engineer | Cloud Security Architect | Cyber Defense Forensic Analyst | Cybersecurity Scrum Master
-
🎲 Angelo Castillo - Network Security Engineer | Machine Learning Engineer | Security Forensic Analyst
-
🤖 Neo Flores - Machine Learning Engineer | Network Engineer | DevOps Engineer
-
🌟 Yeshua Venezuela - Cyber Intelligence Specialist | Software Engineer | UI / UX Designer | Digital Forensic Analyst
Some changes need to be address
- Coming Soon
- Coming Soon
- Coming SoonComing Soon In the License tab
The National University of Manila License grants permission to students of the National University of Manila to use, modify, and distribute this project for educational purposes within the scope of their coursework and assignments.
- You may use this project as a reference or learning material for your studies at the National University of Manila.
- You may modify the project to suit your educational needs and requirements.
- You may share the project with your fellow students or instructors for educational purposes.
- You may not use this project for commercial purposes.
- You may not redistribute or publish this project outside the National University of Manila without explicit permission.
This project is provided "as is" without warranty of any kind, express or implied. The National University of Manila and the project contributors disclaim any liability or responsibility for any direct, indirect, incidental, special, exemplary, or consequential damages arising out of the use or misuse of this project.
Professor Mrs. Jensen Santillan is a highly respected academic and industry practitioner. Her expertise spans a wide range of areas, including Data Analytics, Data Science, Data Analysis, Data Structures, and Information Management. As a distinguished faculty member at the College of Computing and Information Technology at National University, she shares her knowledge and skills with students.
Your dedication to advancing knowledge in this field and your commitment to educating future professionals have been invaluable. Thank you for your guidance, support, and the wealth of information you have shared. Your efforts have greatly enriched this final project and will undoubtedly have a lasting impact on all who engage with this repository.
Chronological list of updates, bug fixes, new features, and other modifications for our Flight Booking Appplication.
- 💻 Final Project requirements for our project
- ✨ Create a repository for this Flight Booking App
- ✨ Brainstorming for our Project requirements
- ✨ Coming Soon 💻 🚀
- ✨ Coming Soon 🧠 🔑
- ✨ Brainstorming on what database should we use
- ✨ Custer Uploaded ERD Diagram
- ✨ Angelo, Myckle, Neo revise the EAV model
- ✨ Uploaded the EAV model
- ✨ Fix Node modules for Flight Booking Client source codebase
- ✨ Fix EAV and Normalization
- ✨ Revise the Entity Attributes View model
- ✨ FrontEnd (Client) for our Flight Booking
- ✨ Fix attributes for EAV and Normalization
- ✨ Revision for Backend and database
- ✨ Revise ERD
- ✨ Upload ERD
- ✨ Upload Screenshot for Flight Booking
- ✨ Push the Front-end folder
- ✨ Update Changelogs for Flight Booking
- ✨ Upload Normalization
🧊 Flight Booking
