1. What defines a relational table in a database compared to a simple spreadsheet?
- Spreadsheets can contain millions of rows while relational tables cannot.
- Relational tables enforce strict schema validation, column datatypes, and integrity constraints.
- Spreadsheets allow relations to be established using foreign keys natively.
- Relational tables store data in cell formulas instead of raw values.
Hint: Relational databases use a defined schema, enforcing strict datatypes for each column, and constraints (like foreign keys and unique indexes) to maintain data consistency.