1 / 29

Oracle User Conference

Oracle User Conference. Data Modeling Basics DeVry University March 5, 2007 Professor Tanya Cannon. Presentation Agenda. System Development Life Cycle (SDLC) Overview Model Driven Approaches Structured Analysis and Design Example Object Oriented Analysis Example Comparison Summary

bela
Download Presentation

Oracle User Conference

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle User Conference Data Modeling Basics DeVry University March 5, 2007 Professor Tanya Cannon

  2. Presentation Agenda • System Development Life Cycle (SDLC) Overview • Model Driven Approaches • Structured Analysis and Design Example • Object Oriented Analysis Example • Comparison Summary • Data Modeling Basics • Purpose of Data Modeling • Logical Data Model (Analysis Phase) • Basic Symbols • Basic Relationships Examples • Transition to the next phase • Physical Data Model (Design Phase) • Normalization Steps • Normalization Student Example (Physical ERD) • Open Discussion • Questions? • Share real world examples?

  3. SDLC Overview

  4. Structured Analysis & Design (SA&D) Example • Context Data Flow Diagram (CDFD) • Decomposition Diagram • Diagram 0 – Exploded DFD • Logical Entity Relationship Diagram (LERD) • Physical Entity Relationship Diagram (PERD)

  5. Context Data Flow Diagram (CDFD)

  6. Decomposition Diagram

  7. Exploded DFD

  8. Logical ERD

  9. Physical ERD

  10. Object Oriented Analysis Design (OOAD) Example • Use Case Diagram • Class Diagram • Sequence Diagram • Statechart Diagram

  11. Use Case Diagram

  12. Partial Class Diagram

  13. Object Oriented Analysis Design (OOAD) Example

  14. Object Oriented Analysis Design (OOAD) Example

  15. Comparison Summary

  16. Data Modeling Basics 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

  17. Data Modeling Basics Logical Data Model Basic Symbols: (three basic relationships)

  18. Data Modeling Basics Logical Data Model Basic Relationships: (business rules)

  19. Data Modeling Basics Logical Data Model • Basic Relationships: (resolving many to many)

  20. Normalization • Process for evaluating and correcting table structures to minimize data redundancies. • It helps eliminate data anomalies. The three steps of data normalization.

  21. Transition

  22. 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

  23. NormalizationUn-normalized Data

  24. Normalization – 1NF

  25. Normalization – 2NF

  26. Normalization – 3NF

  27. Normalization Results Summary

  28. Normalization - Physical ERD

  29. Questions ?

More Related