Relational Databases

Question 1

What is a good example of a relational database?

Answer 1

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

Question 2

What is a relational database?

Answer 2

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

Question 3

What is the purpose of relational databases?

Answer 3

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

Question 4

What is a database management system? (DBMS)?

Answer 4

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

Question 5

What does DBMS stands for?

Answer 5

Database Management System

Question 6

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

Answer 6

1. Database: A colection of data
2. Query: A request for data from a database.
3. Schema: The structure of a database.

Question 7

What is a relational database management system (RDBMS)?

Answer 7

• 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.

Question 8

What does RDBMS stands for?

Answer 8

Relational Database Management System

Question 9

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

Answer 9

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

Question 10

What are Codd’s Twelve Rules?

Answer 10

• Define what is required for a system to be considered a true relational database.
• They include concepts like data independence & integrity.

Question 11

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

Answer 11

1. RULE 1: Data should be represented as tables.
2. RULE 2: Data should be accessed through SQL queries.

Question 12

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

Answer 12

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.

Question 13

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

Answer 13

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.
• 2. Query: A request for data from a database.
• 3. Schema: The structure of a database.

Question 14

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

Answer 14

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.

Question 15

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

Answer 15

1. Define:
2. Key Terms (RULES):

• 1. RULE 1: Data should be represented as tables
• 2. RULE 2: Data should be accessed through SQL queries