Pakistan International Airline (PIA) Reservation System aims to automate the flight operations and ticketing / seat booking and confirmation system of an airline company. The software is providing options for viewing different flights available within a different timings for a specific day. That provide customers within facility to able to book ticket smoothly. The customers can modify and able to cancel the ticket for any reason. That prepare within a role and policies. Part-I: Collect and analyze the requirement for developing the database. Create conceptual schema based upon your analysis. Following design requirement should have included: Login facility for customers. Checking availability of the tickets. Customer should get message when the ticket is unavailable. Showing the history of previous reservations. Feedback record of customers that will help others in future. Part-II: Develop the logical design of database and give an appropriate internal model that allows you to store whole information into tables.