Skip to content

Latest commit

 

History

History
8 lines (5 loc) · 553 Bytes

File metadata and controls

8 lines (5 loc) · 553 Bytes

U.S. School System Finance Database

First phase of this project focuses on creating ER(Logical) Model, use the model to create tables and other consttraints in MYSQL, and then populate the database with the data from the dataset( 2010-2015).

On the Second phase, from ER Model create a Dimensional Model , use Dimensional Model to ( in a new database) create tables and constraints, and then populate this new database with data from the prior database that was created.

Data Source: US Census Data

Platform: MYSQL Workbench, LucidChart