Mastering Object-Role Modeling

Course Curriculum

Chapter 1: Introduction

Lecture 1: Welcome

Lecture 2: Course Overview – Mastering Object-Role Modeling

Lecture 3: What you'll need

Lecture 4: What you'll learn

Chapter 2: Software for the course

Lecture 1: Download and install the Boston Student Object-Role Modeling software

Lecture 2: NORMA Object-Role Modeling software

Chapter 3: Object-Role Modeling – Introduction

Lecture 1: What is Object-Role Modeling

Lecture 2: The benefits of Object-Role Modeling

Lecture 3: The Uses of Object-Role Modeling

Lecture 4: Object-Role Modeling Made Easy – Bonus Video

Chapter 4: Database Design and Conceptual Modeling

Lecture 1: Database Design and Conceptual Modelling

Chapter 5: Business Rule Capturing

Lecture 1: Business Rules and Object-Role Modeling

Lecture 2: Verbalisations – Rules in Natural Business Language

Lecture 3: Introduction to the Practical Sessions

Lecture 4: Practical Session – Capturing Business Rules using Boston

Lecture 5: Practical Session – Verbalisations

Chapter 6: Fact-Based Modeling and Object-Role Modeling

Lecture 1: Object-Role Modeling is a type of Fact-Based Modeling

Chapter 7: The Object Types of Object-Role Modeling

Lecture 1: The Object-Types of Object-Role Modeling

Chapter 8: Value Types

Lecture 1: Value Types in Object-Role Modeling

Lecture 2: Practical Session – Adding a Value Type to a Model using the Toolbox – Boston

Lecture 3: Practical Session – Adding a Value Type to a Model using the Virtual Analyst

Lecture 4: Practical Session – Adding a Value Type to a Model using the Virtual Analyst 2

Chapter 9: Entity Types

Lecture 1: Entity Types in Object-Role Modeling

Lecture 2: Subtype Relationships

Lecture 3: Practical Session – Adding an Entity Type to a Model using the Toolbox – Boston

Lecture 4: Practical Session – Adding a Reference Mode to an Entity Type – Boston

Lecture 5: Practical Session – Reference Schemes and Entity Types

Chapter 10: Fact Types

Lecture 1: Fact Types – The basics

Lecture 2: Objectified Fact Types

Lecture 3: Fact Types and Internal Uniqueness Constraints

Lecture 4: Preferred Identifiers – Constraints

Lecture 5: Derived Fact Types

Lecture 6: Practical Session – Adding a Fact Type to a Model using the Toolbox – Boston

Lecture 7: Adding a Ternary Fact Type to a Model in Boston

Lecture 8: Practical Session – Objectifying a Fact Type – Boston

Lecture 9: Practical Session – Creating Fact Types using the Virtual Analyst – Boston

Lecture 10: Practical Session – Internal Uniqueness Constraints – Boston

Lecture 11: Practical Session – Internal Uniqueness Constraints – Advanced

Chapter 11: Constraints

Lecture 1: Constraints in Object-Role Modeling

Lecture 2: Internal Uniqueness Constraints

Lecture 3: External Uniqueness Constraints

Lecture 4: Ring Constraints

Lecture 5: Role Value Constraints

Lecture 6: Equality Constraints

Lecture 7: Value Range Constraints

Lecture 8: Internal Frequency Constraints

Lecture 9: Subset Constraints

Lecture 10: Exclusion Constraints

Lecture 11: Practical Session – Internal Uniqueness Constraints

Lecture 12: Practical Session – Internal Uniqueness Constraints – Advanced – Boston

Lecture 13: Practical Session – External Uniqueness Constraints – Boston

Lecture 14: Practical Session – Ring Constraints – Boston

Lecture 15: Practical Session – Role Value Constraints – Boston

Lecture 16: Practical Session – Equality Constraints – Boston

Lecture 17: Practical Session – Subset Constraints – Boston

Lecture 18: Practical Session – Join Subset Constraints – Boston

Chapter 12: Transforming ORM Diagrams to Database Schema

Lecture 1: Introduction to transformation rules

Lecture 2: Transforming ORM diagrams to Relational Schema for Relational Databases