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 Kwok
Hin Chi Kwok
Student in IEOR and Computing

I strongly believe that the 3Cs - CURIOSITY, CHALLENGE, and CHANGE - will shape my future, help me achieve my goals, and positively impact my community. I am passionate for technology, and I am here to share my journey of rediscovering my passion for STEM. Despite facing gender stereotypes and societal expectations from selecting IT as my career before, I pursue my CURIOSITY and participate in research projects and competitions. I embrace CHALLENGES, seek innovative solutions, and am actively involved in academic exchanges and entrepreneurship. My ultimate ambition is to translate my research into real products, contribute to make CHANGES in the science and technology industry, and inspire others to pursue a career in STEM.