All projects

Database development

Relational database design.

I translated business requirements into a MySQL database normalized to third normal form.

  • MySQL
  • SQL
  • ER modeling
  • 3NF

How I built it.

Coursework

Database Design & Development

Model the entities

I identified entities, relationships, and constraints in the requirements and mapped them in an entity–relationship diagram.

Normalize and implement

I normalized the schema to third normal form, populated it, and added primary and foreign keys, indexing, and validation rules.

Query across tables

I used joins, aggregations, subqueries, and stored procedures to retrieve application-level information.