What are the core components described for a table in a relational database?

What are the core components described for a table in a relational database?

• A. Fields
• B. Keys
• C. Fields and Keys
• D. Rows and Columns

Answer: (C)

Fields and Keys describe what a relational table contains and how it can be connected to other tables. Fields are the columns that define each attribute and hold the actual data values. Keys, including the primary key that uniquely identifies each row and any foreign keys that link to other tables, ensure data integrity and enable relationships between tables. Together, they show both the data structure (what data is stored) and the relationships that give the relational model its power. Saying fields alone misses how rows are identified; saying keys alone misses what data is stored; and rows and columns describe layout without emphasizing the relational constraints provided by keys.

Fields and Keys describe what a relational table contains and how it can be connected to other tables. Fields are the columns that define each attribute and hold the actual data values. Keys, including the primary key that uniquely identifies each row and any foreign keys that link to other tables, ensure data integrity and enable relationships between tables. Together, they show both the data structure (what data is stored) and the relationships that give the relational model its power. Saying fields alone misses how rows are identified; saying keys alone misses what data is stored; and rows and columns describe layout without emphasizing the relational constraints provided by keys.