Student marks database schema with role-based security views
Filed under Numerify
The question
Design a database schema to store student marks for each test per term along with the professor in-charge. Create views or security rules such that professors can view all data, students can view their own data, and students can view class low, average, and high scores per subject without student names.
No write-up yet. Related questions below have one.
Related Numerify questions
Collected from public candidate posts and coding forums. Updated Nov 2026.