The three types of relationships between tables in a database: one to one, one to many, and many to many.
Types of Relations
RELATED
DATABASES / 01 MINACID PrinciplesSet of principles that ensure data integrity and consistency leveraging transactions.DATABASES / 01 MINConstraintsConstraints are of 5 Types, these set rules for data integrity, reliability and compliance to standard requirements. - Valid value, data type or data in a range - Applied to one or more columnsDATABASES / 02 MINHow to Query Hierarchical Data in SQL: Self Joins, Recursive CTEs, Nested QueriesThree approaches to fetching hierarchical data from a self-referencing table: multiple merged queries, recursive CTEs, and nested queries.