This is a group project in Database design subject. We select the airline business to design database and simulate real/close to real operations.
There are 5 phases in the development of project:
- Data base Planning and Requirements Analysis.
- Conceptual Database Design: User requiremnet and ERD.
- Logical Database Design (ER diagram and Relation schemas & constraints).
- Implementing phase.
- Database Tuning.
- Azure data studio
- Microsoft SQL Server
- Draw.io
- ChatGPT