Built a relational database for an e-store domain from scratch — produced an ERD, normalized the schema to Third Normal Form (3NF), and wrote SQL queries validating data integrity and answering business questions.
Final project for DS1311 — Data Management, BS Data Science, University of Asia and the Pacific.
erd/ ERD diagrams (drawio source — open in diagrams.net or VS Code Drawio extension)
normalization/ 1NF → 2NF → 3NF normalization worksheet (XLSX)
sql/ SQL query reference (PDF) + estore-database schema notes
notebooks/ Python notebooks for normal-form validation + data cleaning/processing
data/
3NF CSVs/ Final 3NF-conformant tables (customers, products, transactions...)
cleaned data/ Intermediate cleaned CSVs
raw data/ Source dataset
documents/ Setup notes, steps taken, analysis & insights, case studies (Ocado, Equifax)
proposal/ Data-needs profile + evaluation checklist from project proposal phase
- ER modeling (entities, attributes, relationships, cardinalities)
- Normalization: 1NF → 2NF → 3NF
- SQL: schema definition, joins, aggregations, integrity constraints
- Data governance frameworks (Ocado, Equifax case analyses)
SQL · ERD (drawio) · Excel (normalization worksheet) · Python / Jupyter (notebooks for normal-form checks)
Course final project, completed Sep–Dec 2025.
David Nathaniel P. Riego · BS Data Science, UA&P (Aug 2023 – Aug 2027 expected) · LinkedIn