Database Concepts Flashcards

Front

What is a database?

Back

An organized collection of data, typically stored in electronic format, allowing for quick input and retrieval.

Front

What is a Database Management System (DBMS)?

Back

A collection of programs that enables you to enter, organize, and select data in a database.

Front

What are the types of databases?

Back

Flat-type, Hierarchical, and Relational.

Front

What is a flat-type database?

Back

A simplistic design consisting of two-dimensional tables with rows and columns.

Front

What is a hierarchical database?

Back

A design that uses a one-to-many relationship for data elements, structured like a tree.

Front

What is a relational database?

Back

A database that can have multiple parents, storing data in tables where new information is automatically added.

Front

What is normalization in databases?

Back

A design technique that reduces data redundancy and eliminates undesirable characteristics like insertion, update, and deletion anomalies.

Front

What is a primary key?

Back

A unique identifier for a database record that must contain unique values and cannot contain NULL values.

Front

What is a foreign key?

Back

A field in one table that links to the primary key in another table, establishing a relationship between the two.

Front

What is a composite key?

Back

A primary key consisting of two or more columns used to uniquely identify each row in a table.