• What fundamental differences exist between object-oriented and object-relational database systems and Web-based database systems?
• Would these differences impact retail store?
• Include details of what changes would need to be introduced to the database if it was used to build a data mart or a data warehouse.
• Include details of what considerations would need to be made if the database were to become a distributed database.
• What specific types of business intelligence could be gathered from the database?
• How would this information assist in the decision-making process for retail store?
• How would retail store benefit from data warehousing in the following areas? Return on investment on business intelligence initiatives (Provide a 3-year estimate.)
• Competitive advantage (based on local or target area)
• Increased productivity of decision-makers (related to business process decision-making)
• How would you address the following data warehousing problems if they occurred in your retail store?
• Required data were never captured.
• There is a high demand for disk space and other resources.
• There are hidden problems with source systems.
• Provide your analysis as to how this part of the project fulfills the mission and 1 or more goals of the case study organization.