Relational Database
A relational database organizes data into tables which can be linked together based on data that is common in each table. Each table can have one or more columns with unique identifiers (primary key) that point to an id column in another table (foreign key) which forms the relationship between the two tables.
- Easier to do complex queries
- Referential integrity enforced by the system
- Updates are fast because all data is on one machine
- Supports atomic transactions
- Harder to scale ([[Vertical Scaling|vertical scaling]])
- More effort required to design data structures
- Payment/Booking System
- Enterprise resource planning (ERP) system
- Customer Relationship Management (CRM) system
- SaaS application
- Ecommerce and Web
- Web frameworks
- Traditional applications