SQL Server Interview Question #5

What is an RDBMS?

SQL Server Fundamentals Junior Beginner

Detailed Explanation

RDBMS stands for Relational Database Management System. It primarily stores data in tables made of rows and columns and allows relationships to be established between tables.

Relationships are normally enforced using keys. For example, Products.CategoryId can reference Categories.Id through a foreign-key constraint. SQL Server, PostgreSQL, MySQL, and Oracle Database are examples of relational database systems.

Code Example

ALTER TABLE Products
ADD CONSTRAINT FK_Products_Categories
FOREIGN KEY (CategoryId)
REFERENCES Categories(Id);