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 / 10 MINAnalytics QueriesA CTE is a temporary named result set that exists only for the duration of a query.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 columns