Database Concepts and Data Management: Relational Databases, DBMS, Big Data, and Data Storage

What are foreign keys?

Fields that reference a primary key in a related table.

What are the advantages of databases over spreadsheets?

Good for storing and organizing information, and good for analyzing and displaying information visually.

What is the difference between NAS and DAS?

NAS uses a series of file servers for scalability, while DAS keeps data centralized for faster access.

What are online databases used for?

Performing research and containing pointers to sources of information.

What is a database?

An organized collection of data.

What is data analytics?

The interpretation of data regardless of how it is stored.

What is a composite primary key?

A primary key made up of more than one field.

What is a one-to-many relationship in databases?

A relationship where a specific row can be related to multiple rows in a related table.

What is a many-to-many relationship?

A relationship where a specific row can be related to multiple rows in another table, requiring a linking table.

What is a data lake?

A repository that stores huge volumes of data in its original format with unique identifiers and tags.

What is a record in a relational database?

A set of fields that all pertain to the same thing.

What is a linking or intersection table?

A table created to manage many-to-many relationships between two related tables.

What is a primary key (PK)?

A unique identifier for each table in a database.

What is big data?

A vast amount of data created and stored that has grown beyond the capabilities of traditional data processing tools.

What is the ETL process?

Extract, Transform, Load; a process used in big data to integrate data from various sources.

What is the purpose of a DBMS?

To provide means for creating, maintaining, and using databases.

What are common issues with spreadsheets?

Unnecessary duplication, inconsistent data, difficulty in data retrieval, poor data integrity, and errors.

What do normal forms in databases ensure?

Data consistency by eliminating unnecessary redundancy.

What does DBMS stand for?

Database Management System.

What is an entity-relationship diagram (ERD)?

A diagram that shows the structure of a database.

What is a field in a relational database?

A characteristic of the thing being recorded.

What is NoSQL?

A database system designed for unstructured data, allowing greater scalability and efficiency.

What is a relational database?

A database that organizes data in connected two-dimensional tables; the dominant type of database for business.

What are some challenges of big data?

How to store data, integrate data from various sources, and retrieve and disseminate data.

What is SQL used for?

Retrieving structured data from a database.