A 3.2.7 Student Activity Answer
Denormalization Approach: To improve the performance of displaying a product list with category names, I could denormalize the database by adding the CategoryName column directly to the Products table. Application Benefit: This denormalization would be most beneficial in an online store application where displaying product lists with category names is a very frequent operation, while category name updates are...