Posts

Showing posts from December, 2022

Databases

 At the beginning of this semester, I had no idea what a database was. I knew they existed and stored data, but I didn't know anything else. Over the course of this class I have learned that a database is an organized collection of information that is stored electronically. I have learned that it is more efficient and easier to use than spreadsheets. Its organization avoids some of the problems that occur with spreadsheets such as update and delete anomalies. It is also able to store vast amounts of data and allows for collaboration. The database that we created for our project contains information about different statistics to do with flights. More specifically, it contains information about different flight statistics for major US airports during different time periods from 2003 to 2015, such as the total number of flights and the number of minutes flights were delayed. We created 3 tables, airports, dates, and statistics. We took the flight data from the CORGIS website and propa