Skip to content

Latest commit

 

History

History
38 lines (25 loc) · 2.85 KB

2nd_year_PreliminaryTask_OS.md

File metadata and controls

38 lines (25 loc) · 2.85 KB
Raw

Open Source Authors - Nehal Khan and Rohit Prasanna

Question 1

RDBMS

MySQL is a popular open-source relational database management system (RDBMS) that uses Structured Query Language (SQL) for managing and organizing data. Known for its speed, reliability, and ease of use, MySQL is widely used in web applications, data warehousing, and logging applications making it a top choice for developers and organizations to handle large volumes of data efficiently

Preparatory Step:

  • Download MySql from MySql.org
  • Use the MySQL Command Line Client to do the tasks and not MySQL WorkBench

Story Line:

Skyways, a regional airline, was facing significant challenges in managing its operations. The airline was experiencing frequent delays, cancellations, and a decline in customer satisfaction. These issues were primarily attributed to manual processes and outdated systems that were unable to keep up with the growing complexity and demands of the airline's operations.

Recognizing the urgent need for improvement, the airline's management decided to develop a modern Flight Management System. The goal was to automate key processes, improve decision-making, enhance customer service, and seamlessly integrate with existing systems.

Skyways' primary goal: To develop a comprehensive Flight Management System using Tkinter as the GUI and MySQL as the backend database.

Objective:

  • Create a Table with an available flight list (Flight Number, Start, Destination, Price, etc.)
  • Create an empty table for the user's booked flight list.
  • Using Tkinter, On booking a ticket check the available options and choose the flight
  • Using Tkinter to Display the user-booked flight ticket
  • Using Tkinter to Cancel user-booked flight ticket

References:

Submission Guidelines:

  • Submit the document source code and its dependency (i.e. other files like images ) in the GitHub directory.
  • create a video for its working and upload it in a drive and share the link in the submission forms. Make sure the link works.
  • Note: The video Creation/Editing would also be noticed, It does not matter if you are bad at it, there is always a beginning and room for improvement BE CONFIDENT