Answer it
Data warehouse or transactional database for a shop chain
5 marksYou mark it yourself against the marking points
A chain of 40 bookshops records every sale at the tills in a relational database in each shop. Head office also has an online shop with its own database and a spreadsheet of customer survey results. The managers want to compare sales across all the shops over the last five years, so they plan to build a data warehouse.
(a) Distinguish between the tills' transactional database and the planned data warehouse. [2]
(b) Describe how the data from the shops, the online shop and the survey could be brought together into one consistent view in the warehouse. [3]
[5]