4 posts tagged with "database"

Overview​

Designing a database schema that reflects real-world complexity is one of the most important architectural decisions in any data platform. In this post, I share how I modeled complex relationships using Prisma ORM with a focus on extensibility, multilingual support, and practical backend integration.

The system supports elections, leaders, parties, governments, scandals, polls, and more—each with overlapping relationships, dynamic behavior, and historical timelines.

Constraints: Constraints are rules which are imposed on columns or table. Constraints allows only data that meets requirement to be entered. It can be applied on both column and table.

The first version of SQL was developed by IBM called Sequel as part of the System R project. SQL stands for structured query language and is a combination of simple english words. SQL is used as a language to communicate with database. Same SQL code can run on multiple database albeit some database have slightly different syntax than others but still they have to maintain specification of SQL.

ER or Entity Reletionship model is used to create and model the data which is simple, non technical and easily understood by people describing a diagram with relation. It helps us to analyze requirements systematically to produce a well designed database.