Skip to content

ishitab1310/DnA-Project

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

27 Commits
 
 
 
 

Repository files navigation

Flight Management System - Project Phase 4

Overview

This project is the final phase of the CS4.301 - Data and Applications course (Monsoon '23). The objective is to implement a Flight Management System using MySQL for database creation and Python3 for building a command line interface. The project involves creating the database based on previously modeled relational schemas and implementing functional requirements through SQL queries and a Python script.

Project Structure

The project is divided into two main parts:

  1. Creating the Database:

    • Utilize MySQL CLI to create the database according to the relational model from Phase 3.
    • Account for all constraints (entity, referential, domain, etc.) while creating the database.
    • Load tables with legitimate values; each table should contain at least 5 tuples.
  2. Performing Queries on the Database:

    • Implement functional requirements mentioned in the Phase 1 submission.
    • Include at least 2 queries for each kind of operation (insertion, update, selection, projection, etc.) for both modifications and retrievals.
    • Include at least 2 analysis queries involving the JOIN clause from Phase 1.

About

DNA course project

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 4

  •  
  •  
  •  
  •