PostgreSQL

Question 1

What is PostgreSQL and what are some alternative relational databases?

Answer 1

an open source Relational Database management system. it is the most advanced open source databased of its kind. MongoDB, Redis, Neo4j (nosql)

Question 2

What are some advantages of learning a relational database?

Answer 2

widely used (tim: they’re everywhere!) and make good data integrities (source: lecture)

when working with datas that are interconnected to each other. Something with relationship.

They provide good guarantees about data integrity.
Can store and modify data in a way that makes data corruption as unlikely as possible.

Question 3

What is one way to see if PostgreSQL is running?

Answer 3

sudo service postgresql status also in top

Question 4

What is a database schema?

Answer 4

defines how the data in a relational database should be organized. (collections of tables) => to build database (schema is like a blue print on how to make a table too)

Question 5

What is a table?

Answer 5

is a list of rows each having the same set of attributes

Question 6

What is a row?

Answer 6

row contains all the attributes/columns