You are designing a database for a retail company that wants to keep track of daily price changes for products. What type of SCD would be most appropriate to capture this requirement?

For capturing daily price changes in a retail database, the most appropriate choice would be SCD Type 2, which allows for the historical tracking of changes to product prices. This type maintains a history of changes, making it ideal for scenarios where you need to preserve historical data. SCD Type 1 overwrites existing data, SCD Type 3 adds new records for changes, and SCD Type 4 is more complex and less commonly used.