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