Components of RDBMS

Components of RDBMS:

• Tables: The fundamental structure for storing data. A table is a collection of related data entries and consists of columns and rows. Think of it like a spreadsheet.
• Fields (Columns): A column is a vertical entity in a table that contains all information associated with a specific field in a table. Each column has a specific data type (e.g., text, number, date).
• Records (Rows): A row, also called a record, is a single data item in a table. It represents a set of related data.
• Primary Key: A column (or set of columns) that uniquely identifies each row in a table. It must contain unique values and cannot have null values.
• Foreign Key: A key used to link two tables together. It is a field in one table that refers to the Primary Key in another table.
• Indexes: A special lookup table that the database search engine can use to speed up data retrieval.