Scenario: A retail company has a database with separate tables for customers, orders, and products. They want to optimize query performance for generating sales reports. How could denormalization be applied in this scenario?
- Create indexed views for the sales reports
- Introduce redundancy by merging the tables to reduce JOIN operations
- Normalize the tables further to eliminate redundancy
- Split tables into smaller ones for better data distribution
Denormalization in this scenario involves introducing redundancy by merging the tables, reducing the need for JOIN operations. This can improve query performance for generating sales reports by minimizing the complexity of queries.
Loading...
Related Quiz
- Scenario: A university has students and courses. Each student can enroll in multiple courses, and each course can have multiple students enrolled in it. What type of entity would you introduce to represent the relationship between students and courses in an ERD?
- In Slowly Changing Dimensions (SCD), Type 1 only _______ existing records.
- Scenario: An online store has customers and orders. Each customer can place multiple orders, but an order must belong to one customer. What cardinality and modality does this scenario illustrate?
- How are relationships represented in an Entity-Relationship Diagram (ERD)?
- Which normalization form ensures that every determinant in a relation is a candidate key?