What is system Design ❓
System design is a process of defining architecture, component ,modules , interfaces and data flow of a system to meet specific requirements
it involves multiple decisions about how different parts of system will interact and and work together to achieve scalability , functionality, reliability and performance of the product.
how to approach System Design ?
what is Relational Database ?
Databases are most critical component of any system, They make or break a system.
in relational database data is stored in rows and columns.
Relational database have some key properties
| data consistency | data integrity | constraints |
|---|---|---|
| data durability | everything in one place |
because of the ☝🏽 reasons , relations database provides us “Transactions” property.
“Transactions” is know to have ACID property.(we call a given statement to db a transaction)
A → Atomicity
C → Consistency
I → Isolation
D → Durability