Direction: Choose the correct option
Q1.
What is denormalization?
Direction: Choose the correct option
Q2.
CREATE TABLE order_summary AS SELECT o.order_id, o.order_date, c.name, c.email FROM orders o JOIN customers c ON o.customer_id = c.id;What is this an example of?Direction: Choose the correct option
Q3.
ALTER TABLE customers ADD total_spent DECIMAL;Why add this column?Direction: Choose the correct option
Q4.
What are risks of denormalization?
Direction: Choose the correct option
Q5.
When is denormalization appropriate?
