Given the following design - A university has colleges, colleges have departments, departments have students. There are department level elections being held where students nominate themselves to stand for elections and other students vote for them. Design the database and tables to represent this relationship and write a query to get the list of students in each department with maximum number of votes. What would be your choice of database, what would be your table design, what would be your endpoints?

Question

Accepted Answer

Design a database for a university with colleges, departments, and students. Write a query to get students with maximum votes.

Use a relational database like MySQL or PostgreSQL
Create tables for colleges, departments, students, and elections
Use foreign keys to establish relationships between tables
Add columns for election details like candidate names and vote counts
Write a query to join tables and filter for maximum votes per department

Popular interview questions of Software Engineer

Top HR questions asked in Socure India Software Engineer