University Academic Management System (UAMS)

The diagram of UAMS Database Schema

Analysis and Methodology:

  1. Simplified Entity-Relationship Diagram (EER) Overview + Expanded EER Diagram (Textual Representation) via MySQL Workbench
  2. Implementatin via MySQL shell
  3. Implementatin via Jupiter Notebook for better visualization (Using IPython SQL Magicm extension allows us to write SQL queries in Jupyter Notebook cells)
  4. Normalization Analysis
Hin Chi (Haley) Kwok
Hin Chi (Haley) Kwok
Student in ISE and Computing