Modern Database Management: Chapter 11 Problem and Exercise 18

How would Fitchwood’s security have to be different if the data mart were made available to customers via the Internet?

The Solution to the Problem

The main work of Fitchwood insurance company is selling annuity products, which requires designing a data mart. While designing the data mart involves the data transaction process (involves files extraction) to move its data to the warehouse. The data transaction process has to deal with some security issues.

The difference in Fitchwood’s security when the data marts were made available to customers

On the off chance that Fitchwood's data mart was made accessible to clients through the Internet, security techniques might need to be set up to protect that clients could go just to information on their approaches. If Internet access was made accessible to operators, then an alternate security layer might be required. One may address the value of permitting any client to get to the data mart through the Internet. It bodes well for a client to get to record data in an online transaction handling framework.

Next: MDM Chapter 11 Problem and Exercise 22