iSchool Capstone

Data Structures and Information System Redesign

Project tags:

community engagement & outreach

database administration & development

knowledge organization

The information problem to solve is scattered organizational data, the lack of data normalization and non-collaborative information system. Based on our user stories and Entity Relationship diagram, we created a database for Foundry10 hosted on Azure to store our database as a cloud solution. We utilized Microsoft Access as our front-end platform to communicate with the database. Benefits for our sponsor: Built solid foundation for consolidating internal data structure Create more consistent reports for staff; a database system will bring in data consistency Descriptive data normalization for efficient data analysis by reducing duplicates and organizing unstructured datasets

Project participants:

Clarissa Kusumo

MSIM

Julian Ngo

MSIM

Lucia Wang

MSIM

Uttam Shri Harsha

MSIM