Explain tables, rows, columns, and schemas with an example.

Relational model

For Explain tables, rows, columns, and schemas with an example., interviewers listen for a crisp definition, how the pieces interact in a real system, and one trade-off or failure mode you have seen or would guard against.

CREATE TABLE students (
  id INT PRIMARY KEY,
  name VARCHAR(100) NOT NULL,
  dept VARCHAR(50)
);
-- row = one student record; column = attribute