What is the purpose of surrogate keys in fact tables?
- To establish foreign key relationships
- To improve query performance
- To provide a stable and unique identifier for each row in the fact table
- To replace natural keys in dimension tables
The purpose of surrogate keys in fact tables is to provide a stable and unique identifier for each row. Surrogate keys are often integers generated by the system and do not have any business meaning. They ensure data integrity and make it easier to manage relationships between tables.
Loading...
Related Quiz
- What does it mean for a table to be in Boyce-Codd Normal Form (BCNF)?
- _______ constraints are used to enforce business rules that cannot be expressed using other constraints.
- Scenario: A financial institution maintains a database for tracking transactions, accounts, and customers. They need to generate detailed financial reports quickly. How could denormalization be used to optimize reporting queries?
- Scenario: An online store has various types of products, including electronics and clothing. Each product has common attributes like name and price, but they also have specific attributes. How would you design the database schema for this scenario?
- An _______ relationship allows a single entity to inherit properties from multiple superclasses.