Postgres

Question 1

Why do we ie databases in Web Development?

Answer 1

When you’re handling complex data its better to have it in a data base due to the simplicity to how easy it is to access. As well as it being reliable

Question 2

What is PostgreSQL and what are some alternative relational databases?

Answer 2

An open source relational database. MySQL, SQL Server by Microsoft

Question 3

What are some advantages of learning a relational database?

Answer 3

To be able to reference datasets, to be able to store and access data

Question 4

What is one way to see if PostgreSQL is running?

Answer 4

with the ‘sudo service postgresql status’ command (sudo stands for super user do , it allows you to run as an admin)

Question 5

What is a database schema?

Answer 5

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. The definition of the structure of everything included in the database.

Question 6

What is a table?

Answer 6

A table is a list of rows each having the same set of attributes. Every row in a table must have the same column

Question 7

What is a row?

Answer 7

A row is an object, instance of the data or an item.

Question 8

What is an attribute and what other names are used to describe them?

Answer 8

Attributes are commonly referred to as columns. Property, key

Question 9

How do you create a database?

Answer 9

with the ‘ $ createdb “mydb” ‘ command ,
another way is including an absolute path, ex:
‘ $ /usr/local/pgsql/bin/createdb “mydb” ‘

Question 10

How do you remove a database?

Answer 10

With the ‘ $ dropdb “mydb” ‘ command