postgres-database

Question 1

What is a database schema?

Answer 1

a collection of tables - defines how the data in a relational database should be organized. you typically have to deifne it up dront and database server will make sure that any data being written to the database conforms to that chema

Question 2

What is a table?

Answer 2

table is a list of rows each having the same attributtes - attributes are columns

Question 3

What is a row?

Answer 3

one horizontal line of the table with certain attribute fields