oracle user conference is data modeling dead
Download
Skip this Video
Download Presentation
Oracle User Conference Is Data Modeling Dead?

Loading in 2 Seconds...

play fullscreen
1 / 22

Oracle User Conference Is Data Modeling Dead? - PowerPoint PPT Presentation


  • 102 Views
  • Uploaded on

Oracle User Conference Is Data Modeling Dead?. DeVRY University March 20, 2006 Professor Tanya Cannon. Presentation Agenda. Introduction to System Development Life Cycle (SDLC) Process Modeling vs. Data Modeling Data Oriented Approach

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Oracle User Conference Is Data Modeling Dead?' - burton


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
oracle user conference is data modeling dead

Oracle User ConferenceIs Data Modeling Dead?

DeVRY University

March 20, 2006

Professor Tanya Cannon

presentation agenda
Presentation Agenda
  • Introduction to System Development Life Cycle (SDLC)
  • Process Modeling vs. Data Modeling
    • Data Oriented Approach
    • Automobile Insurance Application (AIA) - Context Data Flow Diagram
  • Purpose of Data Modeling
    • Normalization Steps
    • Normalization Student Example (Physical ERD)
  • AIA Data Model Example
    • Logical ERD Example
    • Physical ERD Example
  • Is Data Modeling Dead?
    • Open Discussion!
sdlc overview
SDLC Overview

SDLC – Work Breakdown Structure (WBS)

why follow a sdlc
Why Follow a SDLC?

The cost of finding errors increase exponentially as you go through the life cycle.

traditional vs modern approach
Traditional vs. Modern Approach

Model Driven Approaches (SA&D, IE, OOAD, etc…)

process model vs data model
Process Model vs. Data Model

John Zachman Information System Framework

(Knowledge is the data oriented approach)

http://members.ozemail.com.au/~ieinfo/zachman.htm#WhatisFramework

purpose of data modeling
Purpose of Data Modeling

Brief Data Modeling Background:

  • Developed by Boyce Codd (IBM) in 1970
  • Considered ingenious but impractical in 1970
  • Conceptually simple
  • Computers lacked power to implement the relational model
  • Today, microcomputers can run sophisticated relational database software
purpose of data modeling1
Purpose of Data Modeling
  • To document the business information requirements
  • To identify reuse requirements and opportunities
  • To document data requirements based functional activity and/or business rules
  • To assist in identification of redundant processes
  • To guide and support consistent data administration
normalization
Normalization
  • Process for evaluating and correcting table structures to minimize data redundancies.
  • It helps eliminate data anomalies.

The three steps of data normalization.

normalization1
Normalization

“All non-key attributes must depend on the entire primary key, and nothing but the primary key, so help me CODD.”

The three steps of data normalization are:

  • 1NF - All repeating groups are removed
  • 2NF - All Partial dependencies are removed
  • 3NF - All Transitive dependencies are removed
aia data model example
AIA – Data Model Example
  • AIA – Logical ERD Example
  • Normalization Occurred

(Moving from Logical to Physical Model)

  • AIA – Physical ERD Example
is data modeling dead
Is Data Modeling Dead?

Some reasons for the question:

  • Failure of enterprise data models?
  • RAD/Prototyping Techniques?
  • Object Oriented Analysis & Design?
is data modeling dead1
Is Data Modeling Dead?

Open Discussion !!!

ad