An e-health startup stores doctor, patient, and appointment information in separate tables. Which approach ensures valid associations among these data sets?
Column partitioning for storing data by column
Denormalization merging data from multiple tables
Foreign keys referencing records in other tables
Primary indexing that organizes data in each table
Foreign keys referencing records in other tables enforce consistent relationships. Primary indexing organizes records in a single table, but does not confirm valid cross-table connections. Column partitioning focuses on dividing data by columns, not on verifying data consistency among tables. Denormalization combines redundant data fields, which may cause contradictions unless designed very carefully.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What are foreign keys and how do they work?
Open an interactive chat with Bash
Why are foreign keys important in a relational database?
Open an interactive chat with Bash
What are some alternatives to using foreign keys for data associations?