PostreSQL Databases

Question 1

What is a database schema?

Answer 1

A schema is a collection of tables. 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

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. Rows are called “records” or “tuples”. A row is a record in the spreadsheet.

Question 4

What is a column?

Answer 4

A column is an attribute. Columns represent values attributed to a record/row.