Develop an object-oriented model and map objects

Assignment Help Management Information Sys

Reference no: EM131741993

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.

Reference no: EM131741993

Questions Cloud

What is an advantage of point-to-point integration : 1. Another name for a configured HTTP callback initiated by an event within an application is a.

Audit team efficiency and slightly wacky sense of humor : Your audit client was thrilled with your audit team’s efficiency and slightly wacky sense of humor.

Set the background of the field to lightgreen : Validate that the user age field is between 18 and 100. If valid, set the background of the field to LightGreen and assign true to userNameValid.

What is meant by performance based logistics : What is meant by performance based logistics (PBL)?

Develop an object-oriented model and map objects : Develop a model for a graph database to depict the distances among the following cities: Rome, London, Paris, and Brussels.

Define what they do because of their various motivations : Characters do what they do because of their various motivations and desires. Often, their desires conflict with their ethical or moral responsibilities

Assessing the rating of reputation at each level of training : Catherine Ruby (2006), a doctoral student at New York University, conducted an online survey to ascertain the reasons that international students chose.

System or database that would not have all crud rights : Is it possible to have a system or database that would not have all CRUD rights? Why would you want to limit those rights?

Environment as regards to hiring employees is circumstance : One of the more interesting aspects of the legal environment as regards to hiring employees is the circumstance

User Account

All Pages