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.