โ† Microsoft questions
Low-Level DesignReported in a candidate post, Aug 2012

Design and normalize a college management database schema

Filed under Microsoft

The question

Design a relational database schema for student management, normalize it up to 3NF, and write a SQL query to retrieve each student's highest score in last semester's math subject.

No write-up yet. Related questions below have one.

Related Microsoft questions

Collected from public candidate posts and coding forums. Updated Nov 2026.