In my RBDMS class, my team and I built a database to maintain "Happy Maps" data. Happy Maps is an idea developed by Daniele Quercia, a maps researcher, who wants to build a navigation system that accounts for enjoyment and not just the most efficient route from one destination to another. Our database project aimed to capture this alternative cartography of a city weighted by human emotions. Our database will be designed to be used for qualitative and quantitative research on city navigation.

Our database design accounts for different data values, such as beauty, happiness and peacefulness (quiet) within their urban environment. Our team first built an Entity Relationship Diagram of relationships that could exist within different tables of our database. Then we built out a database using MS SQL Server and filled it with sample data.

View the code here.