Home‎ > ‎Data Modeling course‎ > ‎

Class Schedule

Readings, both assigned and supplemental, are listed with each lecture topic   
- Suggested readings are on the web, or from the text or other books.
- Read selectively; see priorities marked (*) in this Class Schedule or the Table of Contents of the readings list.
- Some are for class discussion, others are included to give a good summary/overview, a tutorial, or more depth.
LEGEND:   §ection number within a chapter.     * priority;   [optional]
                Summaries in HALPIN08, not assigned but do read.

W1 COURSE INTRODUCTION and OVERVIEW  [ 1 ]      LectureNotes 1-Intro (parts 1 and 2)
- conduct of the course, expectations and requirements.
- Pretest and Preassessment Survey 
- Data:  mapping the terrain
- Why learn Object-Role Modeling (ORM)?
- assumed semantics of a simple ER diagram:    Handout ===>[H1]
HALPIN08: Forewords
[HALPIN+HALLOCK-MSoft Data Modeling Tool]

W2 ENTITY RELATIONSHIP (ER) MODELING             LectureNotes 2-ERel (part 1)
- clustered data modeling schemes: from least restrictive to relational
- Entities, Attributes, and Relationships - types, characteristics

W3 RELATIONAL DATA MODELING                          LectureNotes 2-ERel (part 2)
- restricting the general ER model
- Codd’s 12 Rules for being relational 
- Representing M:N and ternary relationships
- Logical Database Design guidelines, rules,
- Encoding “data” semantics in a relational model:  Handout==>[H2]
Handout-Design Guidelines, Rules, Notation
HALPIN08: §12.2
**CODD-12 Rules . . . . . . .                                        Lecture Video on Codd.
DATE-Relational is Different

W4 HIERARCHICAL and (CODASYL) NETWORK MODELING LectureNotes 2-ERel (part 3)
- hierarchical data structures - modeling one-to-many relationships
- CODASYL network;
- Foreign keys and referential integrity
- various notations for ER/Relational Diagrams: 
     Chen, Barker, IE, IDEF1X, UML, ANSI SQL
GORMAN-Relational is Dead [structural part]
DATE-Relational is Alive
[HALPIN08: ch.8 (ER), Ch.9 (UML), (p.903f)]

W5 NORMALIZATION   [2]                                            LectureNotes 3-Norm (parts 1 and 2)
- functional dependencies in relationships;  anomalies
- examples of: 1NF, 2NF (partial), 3NF (transitive), 4NF, 5NF
- Denormalization
- Dimensional models: Star/Snowflake schemas (normalized?)
- Exercises   Handout ===> [H3]
HALPIN08: §14.6, 14.7
*KENT-Normal Forms

W6 INTRODUCTION TO DATA MODELING   [ 1 ]        LectureNotes 4-DMod
- the general modeling process: What is a model?
  Choosing Scope, Focus, & Depth
Abstraction > Representation > Realization
- Modeling: the WHAT (objective), the WHY (purpose),
- the HOW - data modeling schemes; evaluation criteria
- taxonomy of data structures / modeling schemes: 
- levels of data modeling; representation stages
HALPIN08:  §1.1, §1.3 (preview rest of chapter)
HALPIN08:  §2.1, 2.3 (preview rest of chapter), [2.4]
HALPIN08:  §3.1 (modeling language criteria)
*KEUFFEL-Modeling Techniques, & Letter
*HAY-What is a Data Model? *Video

W7 OBJECT-ROLE MODELING   [ 1 ]                      LectureNotes 5-ORMod (part 1)
- Problems with ERel modeling, transition to ORM
  - limitations of record-based (ER) data modeling schemes
          TABLE THINK leads to “tableitis,” a serious malady 
- history and evolution of NIAM, ORM
- Overview of NIAM/ORM design methodology
- ORM apologetics: why, why not, and the future
- Steps in the OR Modeling methodology (CSDP)
- a look at the ORM data modeling tool - NORMA. . . . . .     (VIDEO:  NORMA demo)
HALPIN08: Forewords (revisit), preface, §1.2
HALPIN08: §2.2, §3.2 (CSDP);   ORM glossary (p.893f)
FRANK-Halpin Interview
HAY-ORM
BECKER-Arguments

W8 ORM:  BASIC CONSTRUCTS   [1]                                 LectureNotes 5-ORMod (part 2)
- elementary fact sentences - subjects (objects) and predicates
    - diagrammatic representation;   arity of predicates
- Lexical Object Types (LOTs) and  reference modes (identifiers)
- nested object type (objectified predicate) vs. ternary fact type
*HALPIN08: §3.3 - §3.6 

SPRING BREAK

W9 ORM: CONSTRAINTS   [ 1+ ] LectureNotes 6-ORMconstr
- Uniqueness constraint (multiplicity/exclusivity characteristic)
- Mandatory Role constraint
- Value constraints and independent objects (on object populations)
- Set constraints:  subset, equality, exclusion (on role populations)
- Frequency constraints (on objects and predicates)
- Ring constraints (on homogeneous/ring fact type)
*HALPIN08: ch.4
*HALPIN08: ch.5
*HALPIN08: §6.1-6.4, review 6.2 if you need.
*HALPIN08: §7.1-7.4
 and HALPIN08: p.86f

W10 SUBTYPES/SUPERTYPES    [1]                     LectureNotes 7-SStype
-populations, additional descriptors/relationships, inheritance 
- contrast with notions of inheritance and reuse 
      in Object-Oriented design and development
- Notations in Barker, IE, IDEF1X, UML
- mapping to relational tables
HALPIN08: §6.5 - 6.6,
*DATE-Subtypes & Supertypes
HALPIN08: Ch. 8 (p.316-318, 322, 333-4), §9.6
HALPIN08: ch.11 (pages 497-99)

W11 DATA MODEL PRESENTATION and VALIDATION   [1+] LectureNotes 8-DModPre
- to management and to end users, for understanding and validation 
- internal vs. external validation
- natural language verbalization
- visualization in data model diagrams
- scoping/partitioning, levels of abstraction
HALPIN08: §16.4 (abstraction)
HAY-Data Model Views
HAY-Making Data Models Readable 

W12 CONDUCTING DATA MODELING PROJECTS  [ 1 ] LectureNotes 9-DModProj
- Objectives, Benefits, Gathering requirements; data planning
- Process, Product, and user experiences.
- Conducting database design projects/meetings
- Rapid development (JAD) session vs. Extended project meetings
- Documenting a logical database design -- guidelines.
*EVEREST-Users Do
*SIMSION-Data Modeling(2)
EVEREST-Wiki
*PELKKI+EVEREST+ROSE

W13 MAPPING ORM TO RELATIONAL MODEL  [ 1- ]              LectureNotes 10-ORMap
- conceptual schema transformations
- Generating the logical (record-based, table) data model
- Generating the DDL script for a target DBMS
HALPIN08: §11.1-11.3, [§11.4]
HALPIN08: §14.1-14.3

W13'd  COMPREHENSIVE DATA MODEL SEMANTICS   [1-] LectureNotes 11-BusnRules
- What are business rules?  Anything new?
- Capturing, expressing, and enforcing business rules
*VonHALLE+PLOTKIN
HALPIN-Business Rules & ORM

W14 P1 REVIEW
*EVEREST-Solutions (separate handout)

W15 COURSE REVIEW
Bring your questions to class.

FINAL EXAM - Must be completed by end of exam week.
COMPLETE your Course Feedback & Evaluation Survey
SUBMIT your Vendor Feedback Memo