OLTP Versus OLAP Servers

For each of the following processes, state whether OLTP or OLAP is appropriate and why.
An order entry system that retrieves customer infor- mation, invoice information, and inventory informa- tion for local sales.
An order entry system that retrieves customer infor- mation, invoice information, inventory information, and several years of sales information about both the customer and the inventory items.
An order entry system that retrieves customer infor- mation, invoice information, inventory information, and information to compare the current sale to sales across several geographic regions.
An order entry system that retrieves customer infor- mation, invoice information, inventory information, and accounts receivable information for sales within one marketing region.
An insurance company requires a system that will allow it to determine total claims by region, deter- mine whether a relationship exists between claims and meteorological phenomenon, and why one re- gion seems to be more profitable than another.
A manufacturing company has only one factory, but that factory employs several thousand people and has nearly $1 billion in revenue each year. The company has seen no reason to make comparisons about its operations from year to year or from process to pro- cess. Its information needs focus primarily on opera- tions, but it has maintained backup of prior-year operations activities. Examination of prior-year fi- nancial reports have shown that the company, while profitable, is not growing and return on investment is decreasing. The owners are not satisfied with this situation.