EffiaSoft Interview Questions and Answers

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 vot

Design a bit.ly URL shortening service with database choice, table design, and endpoints.

• Use a relational database like MySQL or PostgreSQL for scalability and ACID compliance.

• Create a table with columns for the original URL, shortened URL, and metadata like creation date and click count.

• Endpoints should include URL shortening, redirection, and analytics.

• Implement caching to improve performance and reduce database load...read more