SFILS is an integrated library system for the San Francisco Public Library.
This project uses the library usage data set to build a complete database of the San Francisco Public Library.
There could be missing data (some of them intentional - to protect the identity of the patrons). However, we do not complement the data with other data sources. The only data set that is used in this project is SFPL_DataSF_library-usage_Jan 2023.xlsx, which is also linked from the library usage data set page linked above.
The goal of this project is to carefully store this Excel sheet in a database with several tables. Eventually, we find interesting insights into the San Francisco public library through this database, and provide an app that allows for updates and edits.
The aim is to understand and demonstrate the optimal use of MySQL through efficient indices and multiple tables, rather than simply dumping the whole excel sheet into a single large table. We create several tables from this single excel sheet in a meaningful manner.