Matching Items (1,572)
Filtering by

Clear all filters

Building an ESG Metrics Database for US Law Firms: ESG Intelligence Group's Data Management Solution

Description
I built a database for ESG Intelligence (ESGi) Group, a consulting firm that advises law firms on implementing good environmental, social, and governance (ESG) practices internally as well as how law firms can better serve their clients with respect to ESG. This paper explores my decision-making process for the design…

I built a database for ESG Intelligence (ESGi) Group, a consulting firm that advises law firms on implementing good environmental, social, and governance (ESG) practices internally as well as how law firms can better serve their clients with respect to ESG. This paper explores my decision-making process for the design of the database and the challenges I ran into while creating and populating the database. I turned a list of things that ESGi Group wanted to track into an entity relationship diagram (ERD), which I eventually turned into a relational database in MySQL. I further defined the contents of the database by mapping the ERD into a relational model, normalizing the relational model, and creating an attribute domain table. I coded the database in SQL, collected data in an excel spreadsheet (downloaded from AMLAW 200 and NLJ 500 purchased data, manually searching individual firm websites, and scraping law.com in R), and then inserted the data into the database. I ran into issues with data completeness due to the lacking regulation of firm transparency about ESG reporting, but this project succeeded in proof of concept rather than implementation. I also discuss security and privacy considerations, and ESGi Group’s possible options for further development of this project in the future.
ContributorsSell, Lily (Author) / Sopha, Matthew (Thesis director) / Cone, Pamela (Committee member) / Barrett, The Honors College (Contributor) / Department of Information Systems (Contributor) / School of Mathematical and Statistical Sciences (Contributor)
Created2024-05

Asian/Asian Pacific American Students' Coalition (AAPASC) 2024-2025 Guidebook

Description
By assembling the countless work put in by past and current AAPASC community members, this guidebook aims to serve as a foundation for future AAPASC executive boards and organizations. The goal for this project is to be a living document, maintained and changed by future generations of AAPI student leadershi…

By assembling the countless work put in by past and current AAPASC community members, this guidebook aims to serve as a foundation for future AAPASC executive boards and organizations. The goal for this project is to be a living document, maintained and changed by future generations of AAPI student leadership to adapt to the needs and goals of their university experience, but also to provide a connection to the learned experience of the past.
ContributorsLiu, Sabrina (Author) / Kuo, Karen (Thesis director) / Yellow Horse, Aggie (Committee member) / Barrett, The Honors College (Contributor) / Economics Program in CLAS (Contributor) / School of Mathematical and Statistical Sciences (Contributor)
Created2024-05