This project is a Database Management System (DBMS) implementation for SAME, an insurance company that provides coverage to domestic and international passengers. As the company expanded, manually managing data became inefficient.
This project introduces a relational database system to efficiently store, update, and manage data related to passengers, flights, insurance policies, payments, and agents.
The database is designed using Oracle SQL, and the web application is built with Node.js and React.js for seamless user interaction.
✅ Ternary Relationship Model – Efficiently maps relationships between passengers, flights, and insurance policies.
✅ Normalization & Redundancy Reduction – Uses foreign keys to reduce redundancy, particularly for agents.
✅ User-Friendly Web Application – Built using React.js and Node.js for a dynamic user interface.
✅ Security Implementation – SQL Injection prevention techniques included.
✅ Payment & Invoice Management – Allows multi-card payments per booking.
- Ternary Relationship: Passengers, Flights, and Insurance policies are interrelated.
- Agents Table: To avoid redundancy, a separate Agent Table stores agent details.
- Passengers' Preferences: Cabin class, meal plan, and special requests are recorded.
- Payments: A single invoice may be paid using multiple payment methods.
- Airports & Airlines: Have a many-to-many relationship.
- Normalization:
Agentsare referenced viaagentIDto eliminate duplicate data.Passengersmay not always have a passport (domestic flights allow local IDs).
✅ SQL Injection Prevention – Uses parameterized queries to prevent unauthorized access. ✅ User Authentication – Ensures only authorized users can access certain data.
