Model the entities
I identified entities, relationships, and constraints in the requirements and mapped them in an entity–relationship diagram.
Database development
I translated business requirements into a MySQL database normalized to third normal form.
Coursework
Database Design & Development
I identified entities, relationships, and constraints in the requirements and mapped them in an entity–relationship diagram.
I normalized the schema to third normal form, populated it, and added primary and foreign keys, indexing, and validation rules.
I used joins, aggregations, subqueries, and stored procedures to retrieve application-level information.