postgres

Question 1

What is PostgreSQL and what are some alternative relational databases?

Answer 1

PostgreSQL is a Relational Database Management System (RDBMS)

MySQL(free), SQL Server by Microsoft, Oracle by Oracle corporation

Question 2

What are some advantages of learning a relational database?

Answer 2

domains can be modeled well using a relational database. They 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

while using two terminals. one using top

and one starting the sql process sudo service postgresql start or using

Question 4

What is a database schema?

Answer 4

a collection of tables. defines how the data in a relational database should be organized

Question 5

What is a table?

Answer 5

A table is a list of rows each having a same set of attributes.

it is also called a relation

Question 6

What is a row?

Answer 6

a single structured item in a data structure.