The answers to the following problems should only include:

Problem 1: OO model and database table (no SQL)

Problem 2: MDM (no tables or queries)

Problem 3: Graph Model

Problem 4: Tree

For Problems 5 and 6, answers should be single spaced, Arial 12 font and no more than one page for each problem (300-400 each question)

1. Develop an object-oriented model and map objects to relational database tables for an airport. Include the following objects, their attributes, and their relationships: reservations, passengers, planes, gates, times, destinations, and baggage.

Develop the resulting database tables.

2. Develop a multidimensional model for a data warehouse for a product-oriented business that will answer the following queries:

a. Orders or contracts by geographical location

b. Regional sales by quarter

c. Product orders by product line by year

d. Shipping costs by shipping method

e. Volume of shipments by destination by day

3. Develop a model for a graph database to depict the distances among the following cities: Rome, London, Paris, and Brussels.

4. Develop a two-level tree for an M:N relationship of doctors and patients.

5. Describe the process you would use to develop a data model and the decisions you would have to make.

6. Describe future challenges that Big Data will present to the data modeler.