The goal of this project is to design and implement a relational database from raw data. College-Selection-Platform provides a database, helping a student in search of a college, to get information and compare different educational institutions to choose the best one for himself/herself.
Datasets: The datasets are taken from government website of the United States link.
(Most-Recent-Cohorts-Institution_09012022 - 2989 columns, 6682 rows)
(Most-Recent-Cohorts-Field-of-Study - 121 columns, 224818 rows)
• MySQL
• MySQL Workbench
• Microsoft Excel
Data Operations
- Data Preparation
- Data Processing
- Data Loading
- Data Analysis
Database operations
- ER Diagram
- Schemas derived from the entity sets
- Schemas derived from the relationship sets
- Database Design Choices
- Constraints
Detailed information about the project is included in the file Project_Details.pdf.