postgres-database

Question 1

What is a database schema?

Answer 1

A collection of tables is called a schema. A schema defines how the data in a relational database should be organized.

Question 2

What is a table?

Answer 2

Relational databases store data in relations, commonly referred to as tables. A table is a list of rows each having the same set of attributes.

Question 3

What is a row?

Answer 3

A table is a list of rows each having the same set of attributes. For example, all students in a “students” table could have “firstName”, “lastName”, and “dateOfBirth” attributes. Attributes are commonly referred to as columns.