Term Paper of advance data Modelling
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.
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.
