Relational Databases Flashcards
What is a good example of a relational database?
In a store’s database, one table might store customer information, & another might store order details. These tables can be linked using customer IDs.
What is a relational database?
organizes data into tables that can be linked (or related) to each other.
What is the purpose of relational databases?
are used in systems that require structured data, like banking, e-commerce, & healthcare system.
What is a database management system? (DBMS)?
is software that allows users to create, manage, & interact with databases.
What does DBMS stands for?
Database Management System
What are some key terms of database management system (DBMS)?
- Database: A colection of data
- Query: A request for data from a database.
- Schema: The structure of a database.
What is a relational database management system (RDBMS)?
- 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.
What does RDBMS stands for?
Relational Database Management System
What are some (popular examples) TYPES of RDBMS (Relational Database Management System)?
POPULAR TYPES INCLUDES:
1. MySQL,
2. PostgreSQL,
3. Oracle
What are Codd’s Twelve Rules?
- Define what is required for a system to be considered a true relational database.
- They include concepts like data independence & integrity.
What are some key terms (Rules) for Codd’s Twelve Rules?
- RULE 1: Data should be represented as tables.
- RULE 2: Data should be accessed through SQL queries.
What is a relational database? (in more detail)
- Define:
- Example:
- Purpose:
- Define: A relational database organizes data into tables that can be linked (or related) to each other.
- 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.
- Purpose: Relational databases are used in systems that require structured data, like banking, e-commerce, and healthcare systems.
What is a database management system (DBMS)? (In more Detail)
- Define:
- Key Terms
- Key Terms define:
- Define: is software that allows users to create, manage, and interact with databases.
- Key Terms: 1. Database, Query, Schema
- Database: A collection of data.
- Query: A request for data from a database.
- Schema: The structure of a database.
What is a relational database management system (RDBMS)? (In more Detail)
- Define:
- Example:
- Define: is a type of DBMS explicitly designed for relational databases. It allows users to manage the relationships between data tables using SQL.
- Example: Popular RDBMS include MySQL, PostgreSQL, and Oracle.
What are Codd’s Twelve Rules? (In more Detail)
- Define:
- Key Terms (RULES) & defines them:
- Define:
- Key Terms (RULES):
- RULE 1: Data should be represented as tables
- RULE 2: Data should be accessed through SQL queries