Unit 8

Database Management Systems (DBMS)

Software applications designed to manage large amounts of data.

What are the types of Database Management Systems (DBMS)?

Key-Value Database, Graph Database, Document Database, Search Database, Relational Database, Analytical Database, Column-oriented Database.

What do all databases perform?

Create new records, Read existing data, Update existing data, Delete records in the database.

What is a Table in a Relational DBMS?

A sequence of records, similar to a flat file or spreadsheet.

What is a Record in a Relational DBMS?

A collection of data fields (one row).

What does Cardinality refer to?

The number of associations that can exist between two records.

What is Structured Query Language (SQL)?

A declarative programming language for storing and processing information in a relational database.

What is a Join in SQL?

A way to collect records from two tables.

What does an INNER JOIN do in SQL?

Selects all rows from the tables as long as a join condition satisfies.

What is the purpose of GROUP BY in SQL?

To aggregate results on a particular field.

What are some aggregation functions in SQL?

COUNT(...), AVG(...), SUM(...), MAX(...), MIN(...), ROUND(...).

What is a Pivot Table?

A tool in Excel that aggregates records of one or more tables of a spreadsheet producing summarized results.

What is the most popular form of DBMS?

Relational databases.

What parts make up a Relational DBMS?

Table, Field, Record, Column.

What is an Entity-Relationship Diagram (ERD)?

A graphical depiction of the relationships between record types in a database.