You will be presented with a scenario $($described below$)$ as part of a university system$$s efforts to build a data warehousing environment.

Based on the details of the scenario, you will draw diagrams to specify two different architectural alternatives that could be used.

For purposes of this assessment, each of your alternatives will be a component$-$based approach using data marts rather than a centralized, single$-$database data warehouse.

$\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

The scenario:

A large state university system has four different campuses located all across the state. Each of these campuses operates as$,$ essentially, its own self$-$contained university, which means:

Each campus has its own IT organization that operates and maintains its own applications for that campus only

Each campus' applications include the following key software systems for:

Faculty management

Student admissions, grading, and administration

Facilities management $($e$.$g$.,$ buildings and classrooms$)$

The state university's "main campus" is one of the four individual campuses, and is located in a small town in the center of the state

The main campus IT organization has responsibilities for not only that campus, but also support for the entire state university system as a whole

The main campus IT organization is just starting on a data warehousing initiative that is intended to serve the needs of $1)$ individual campuses as well as $2)$ the state university system as a whole.

$\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

The start of the architecture, which will include data from the key systems on each campus being brought into a data warehouse:

Questions for this assignment

Draw $($on paper, or in PowerPoint or another drawing program$)$ two different approaches to building the data marts for this scenario.

Hint $1$: You would not have $1$ data mart for each of your source systems

Hint $2$: Think of the types of analysis that university personnel would want to on data from the identified source systems

Hint $3$: Think in terms of $$boundaries$$ i$.$e$.,$ what data would be likely included versus excluded for someone doing different types of analysis