Correct option is C
In relational database models,
tables and columns are the core structures used to organize and manage data. Each table contains rows (records) and columns (fields) that define the data's organization, enabling efficient querying and data relationships.
Important Key Points:
1.
Tabular Structure: Tables are the primary organizational units in relational databases, with columns defining data attributes.
2.
Data Integrity: Using tables with columns helps maintain data integrity and supports relationships across the database.
3.
Efficient Querying: Structured tables allow for efficient querying through SQL, supporting large data operations.
Knowledge Booster:
·
Data Dictionary: Stores metadata and schema information, not directly used to organize data records.
·
Records and Fields: Refers to individual entries and attributes within tables, but "tables and columns" is the complete structure.
·
Foreign Keys: Used to link tables but are not primary structures for data organization.
·
Database Schema: Describes the database structure but is a broader term than tables and columns.