Database Technologies, Relational Model, and Data Modeling

Front

What is a Database?

Back

An organized collection of data that allows for efficient storage, retrieval, and management of information.

Front

What are the types of Database Technologies?

Back

1. Relational Databases (RDBMS) 2. NoSQL Databases 3. NewSQL Databases 4. In-Memory Databases

Front

What is a Relational Database (RDBMS)?

Back

Data is stored in tables with rows and columns and uses SQL for managing data.

Front

What is NoSQL Database?

Back

Suitable for unstructured or semi-structured data, including Document Stores, Key-Value Stores, Graph Databases, and Column-Family Stores.

Front

What is NewSQL Database?

Back

Combines the scalability of NoSQL with the structure of RDBMS.

Front

What is In-Memory Database?

Back

Stores data in main memory for fast access.

Front

What is the Relational Model?

Back

A method of organizing data into tables (relations), proposed by Edgar F. Codd in 1970.

Front

What are the key components of the Relational Model?

Back

1. Tables (Relations) 2. Rows (Tuples) 3. Columns (Attributes) 4. Primary Key 5. Foreign Key

Front

What is a Primary Key?

Back

A unique identifier for each record in a table.

Front

What is a Foreign Key?

Back

Links data between two tables, establishing a relationship.