Unraveling the World of RDBMS: A Key Term Introduction
Learning objective
Unraveling the World of RDBMS: A Key Term Introduction
Learning objective
Learning Objective
Understand the key terms used in a RDBMS and their significance in database management.
What do you already know about RDBMS?
RDBMS
Relational Database Management System (RDBMS) is a database management system based on the relational model.
Table
A table is a collection of related data entries organized in rows and columns.
Schema
A schema is a logical collection of database objects, such as tables, views, and indexes.
Primary Key
A primary key is a unique identifier for each record in a table.
Foreign Key
A foreign key is a column or a group of columns in a table that references the primary key of another table.
Normalization
Normalization is the process of organizing data in a database to reduce redundancy and dependency.
SQL
Structured Query Language (SQL) is a standard language for managing and manipulating databases.
Write down 3 things you learned in this lesson.
Write down 2 things you want to know more about.
Ask 1 question about something you haven't quite understood yet.