Amity Software Limited Interview Questions and Answers

Design schema for a movie booking system.

• Create tables for movies, theaters, users, bookings, and payments.

• Use foreign keys to establish relationships between tables.

• Include attributes like movie title, showtime, seat number, user details, booking status, payment details, etc.

• Consider implementing a booking algorithm to handle seat selection and availability.

• Ensure data integrity and normalization for efficient data re

To scale the app database over India, consider sharding, replication, and using cloud services.

• Implement sharding to distribute data across multiple servers based on geographic location or other criteria.

• Set up replication to ensure data consistency and availability in different regions.

• Utilize cloud services like AWS or Azure to easily scale resources based on demand.

• Optimize queries and indexes to improve database pe...read more

Sharding and partitioning are both techniques used in database management to improve performance and scalability by dividing data into smaller chunks.

• Sharding involves splitting a database into smaller, independent databases called shards, each responsible for a subset of the data.

• Partitioning involves dividing a database into smaller segments called partitions, each containing a subset of the data based on a defined c...read more

The 3 basic components of a database are data, schema, and software. An RCA for a DB being down involves identifying the root cause of the issue.

• Data: the actual information stored in the database, such as customer records or product details.

• Schema: the structure that defines how the data is organized and related to each other, including tables, fields, and relationships.

• Software: the database management system (DBMS) ...read more