Database Basics

Front

What is a database?

Back

An organized collection of structured information.

Front

How does a relational database organize data?

Back

Into tables with rows and columns, where tables are related to each other through shared columns.

Front

How does a non-relational database store data?

Back

In formats such as documents, key-value pairs, or graphs, instead of tables.

Front

What is a DBMS?

Back

A set of programs that allows us to create a database, fill it with new tables, display the content, and edit existing tables.

Front

Name some popular DBMS examples.

Back

PostgreSQL, Oracle, MySQL, Microsoft SQL Server.

Front

What do relational databases consist of?

Back

Tables, which are organized in rows and columns.

Front

What does each row in a table represent?

Back

Information about one person.

Front

What do columns in a table represent?

Back

Categories of information being tracked, with each field holding a specific type of information.

Front

What is a cell in a database table?

Back

The location where a specific piece of information lives.