London International Airport would like to implement an SQLite database that will be used to keep track of airplanes, fl
Posted: Tue Jul 05, 2022 10:19 am
London International Airport would like to implement an SQLitedatabase that will be used to keep track of airplanes, flights,passengers, and plane maintenance.
This database needs to support the following requirements:
(Note: You may store date and time attributes as strings, sinceSqlite doesn’t support real date and time data types)
Your task for this part of the project is to create a databasethat satisfies the requirements listed above. The database shouldbe properly normalized. Additionally, please include some sampledata in each of the tables; only three to five rows of sample dataper table is necessary.
This database needs to support the following requirements:
(Note: You may store date and time attributes as strings, sinceSqlite doesn’t support real date and time data types)
Your task for this part of the project is to create a databasethat satisfies the requirements listed above. The database shouldbe properly normalized. Additionally, please include some sampledata in each of the tables; only three to five rows of sample dataper table is necessary.