Read Requirements, Complex Join Queries

Relational Database has a fixed schema. When relationships between tables are important and data is highly structured and requires referential integrity.

▪ Can work with complex queries, table joins and reports on normalized data models.

▪ Relational Database supports a powerful SQL query language.

▪ Deployments, Centralized Structure

Relational Databases will be deployed to large and one or few locations. Relational database has centralized structure.

▪ Relational databases have a single point of failure with failover.

▪ Relation database is deployed in vertical fashion

https://www.pluralsight.com/blog/software-development/relational-vs-non-relational-databases