Assignment:

While working as a database analyst for a national sales organization, you are asked to be part of its data warehouse project team.

1. Prepare a high-level summary of the main requirements to evaluate DBMS products for data warehousing.

2. Your data warehousing project group is debating whether to prototype a data warehouse before its implementation.

The project group members are especially concerned about the need to acquire some data warehousing skills before implementing the enterprise-wide data warehouse. What would you recommend? Explain your recommendations.

3. Suppose you are selling the data warehouse idea to your users. How would you explain to them what multidimensional data analysis is and explain its advantages?

4. Before making a commitment, the data warehousing project group has invited you to provide an OLAP overview.

The group's members are particularly concerned about the OLAP client/server architecture requirements and how OLAP will fit the existing environment. Your job is to explain to them the main OLAP client/server components and architectures.

5. One of your vendors recommends using an MDBMS. How would you explain this recommendation to your project leader?

6. The data warehouse project is in the design phase. Explain to your fellow designers how you would use a star schema in the design.

Instructions:

• Your essay should be approximately 500 words. Insure all responses are within one single Word document.

• Be sure to use proper APA punctuation, spelling and grammar; points will be deducted accordingly.