Relational Databases Flashcards

1
Q

What is a good example of a relational database?

A

In a store’s database, one table might store customer information, & another might store order details. These tables can be linked using customer IDs.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is a relational database?

A

organizes data into tables that can be linked (or related) to each other.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is the purpose of relational databases?

A

are used in systems that require structured data, like banking, e-commerce, & healthcare system.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is a database management system? (DBMS)?

A

is software that allows users to create, manage, & interact with databases.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What does DBMS stands for?

A

Database Management System

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What are some key terms of database management system (DBMS)?

A
  1. Database: A colection of data
  2. Query: A request for data from a database.
  3. Schema: The structure of a database.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is a relational database management system (RDBMS)?

A
  • is a type of DBMS (Database Management System) designed specifically for relational databases.
  • It allows users to manage the relationships between data tables using SQL.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What does RDBMS stands for?

A

Relational Database Management System

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What are some (popular examples) TYPES of RDBMS (Relational Database Management System)?

A

POPULAR TYPES INCLUDES:
1. MySQL,
2. PostgreSQL,
3. Oracle

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What are Codd’s Twelve Rules?

A
  • Define what is required for a system to be considered a true relational database.
  • They include concepts like data independence & integrity.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What are some key terms (Rules) for Codd’s Twelve Rules?

A
  1. RULE 1: Data should be represented as tables.
  2. RULE 2: Data should be accessed through SQL queries.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is a relational database? (in more detail)
- Define:
- Example:
- Purpose:

A
  1. Define: A relational database organizes data into tables that can be linked (or related) to each other.
  2. Example: In a store’s database, one table might store customer information, and another might store order details. These tables can be linked using customer IDs.
  3. Purpose: Relational databases are used in systems that require structured data, like banking, e-commerce, and healthcare systems.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is a database management system (DBMS)? (In more Detail)
- Define:
- Key Terms
- Key Terms define:

A
  1. Define: is software that allows users to create, manage, and interact with databases.
  2. Key Terms: 1. Database, Query, Schema
    1. Database: A collection of data.
    1. Query: A request for data from a database.
    1. Schema: The structure of a database.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is a relational database management system (RDBMS)? (In more Detail)
- Define:
- Example:

A
  1. Define: is a type of DBMS explicitly designed for relational databases. It allows users to manage the relationships between data tables using SQL.
  2. Example: Popular RDBMS include MySQL, PostgreSQL, and Oracle.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What are Codd’s Twelve Rules? (In more Detail)
- Define:
- Key Terms (RULES) & defines them:

A
  1. Define:
  2. Key Terms (RULES):
    1. RULE 1: Data should be represented as tables
    1. RULE 2: Data should be accessed through SQL queries
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q
A