postgres-database

Question 1

What is a database schema?

Answer 1

A collection of inter-linked tables is called a schema. A schema defines how the data in a relational database should be organized. In relational databases, you typically have to define your schema up front and the database server will make sure that any data being written to the database conforms to that schema.

Question 2

What is a table?

Answer 2

A table is a list of rows each having the same set of attributes. Attributes are commonly referred to as columns. You might visualize a database table as a sort of spreadsheet where each row is a record in that spreadsheet.

Question 3

What is a row?

Answer 3

Each entry for the table.