Mastering Object-Role Modeling

Learn conceptual modelling and database design using Object-Role Modeling to boost your IT and business analysis career.

What you'll learn

Learn the fundamentals of Object-Role Modeling

Learn how to design databases using Object-Role Modeling

Learn the terms and techniques used in Object-Role Modeling

Learn the essence of Fact-Based Modelling

Learn database normalisation with Object-Role Modeling

Requirements

No prior conceptual modelling experience is required

Introductory knowledge of databases is useful

No software is required for this course - however the Boston Object-Role Modeling (Student version) software is supplied with this course.

Description

Learn how to do conceptual modelling with Object-Role Modeling with this course!This course will teach you how to create Object-Role Models and be able to converse about Object-Role Modeling at a professional level.Object-Role Modeling helps in the database design process for graph and relational databases and captures business domain rules using natural business language that third-parties can understand.This course is for you if you want to improve your conceptual modelling skills, enhance your job opportunity prospects in database design or business analysis of if you want to find out more about Object-Role Modeling.This course starts with the basics and works its way through advanced topics and techniques in Object-Role Modeling.This course includes:- Over two hours of video lessons;- Explanation of nearly all the key elements of Object-Role Modelling;- Object-Role Modeling software to do practical exercises;- Included sample Object-Role Models to load into software;- Theoretical and practical lectures/sessions; and- How to transform Object-Role Models to relational database schema;The topics covered in this course are:- A introduction to Object-Role Modeling and what it is used for;- The benefits of Object-Role Modeling; and- Details explanation of Value Types, Entity Types, Fact Types and Constraints in Object-Role Modeling;You'll learn what you need to know to be able to speak fluently about Object-Role Modeling with database design professionals!Who this course is for:- Data and Information Modellers;- Database Administrators and Database Designers;- Business Analysts and Solution Architects;- Students wishing to know more about database design;- Those wanting to know more about Object-Role Modeling; and- Those wanting to secure IT and Business Analysis employment opportunities

Overview

Section 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

Section 2: Software for the course

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

Lecture 6 NORMA Object-Role Modeling software

Section 3: Object-Role Modeling - Introduction

Lecture 7 What is Object-Role Modeling

Lecture 8 The benefits of Object-Role Modeling

Lecture 9 The Uses of Object-Role Modeling

Section 4: Database Design and Conceptual Modeling

Lecture 10 Database Design and Conceptual Modelling

Section 5: Business Rule Capturing

Lecture 11 Business Rules and Object-Role Modeling

Lecture 12 Verbalisations - Rules in Natural Business Language

Lecture 13 Introduction to the Practical Sessions

Lecture 14 Practical Session - Capturing Business Rules using Boston

Lecture 15 Practical Session - Verbalisations

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

Lecture 16 Object-Role Modeling is a type of Fact-Based Modeling

Section 7: The Object Types of Object-Role Modeling

Lecture 17 The Object-Types of Object-Role Modeling

Section 8: Value Types

Lecture 18 Value Types in Object-Role Modeling

Lecture 19 Practical Session - Adding a Value Type to a Model using the Toolbox - Boston

Lecture 20 Practical Session - Adding a Value Type to a Model using the Virtual Analyst

Lecture 21 Practical Session - Adding a Value Type to a Model using the Virtual Analyst 2

Section 9: Entity Types

Lecture 22 Entity Types in Object-Role Modeling

Lecture 23 Subtype Relationships

Lecture 24 Practical Session - Adding an Entity Type to a Model using the Toolbox - Boston

Lecture 25 Practical Session - Adding a Reference Mode to an Entity Type - Boston

Lecture 26 Practical Session - Reference Schemes and Entity Types

Section 10: Fact Types

Lecture 27 Fact Types - The basics

Lecture 28 Objectified Fact Types

Lecture 29 Fact Types and Internal Uniqueness Constraints

Lecture 30 Preferred Identifiers - Constraints

Lecture 31 Derived Fact Types

Lecture 32 Practical Session - Adding a Fact Type to a Model using the Toolbox - Boston

Lecture 33 Adding a Ternary Fact Type to a Model in Boston

Lecture 34 Practical Session - Objectifying a Fact Type - Boston

Lecture 35 Practical Session - Creating Fact Types using the Virtual Analyst - Boston

Lecture 36 Practical Session - Internal Uniqueness Constraints - Boston

Lecture 37 Practical Session - Internal Uniqueness Constraints - Advanced

Section 11: Constraints

Lecture 38 Constraints in Object-Role Modeling

Lecture 39 Internal Uniqueness Constraints

Lecture 40 External Uniqueness Constraints

Lecture 41 Ring Constraints

Lecture 42 Role Value Constraints

Lecture 43 Equality Constraints

Lecture 44 Value Range Constraints

Lecture 45 Internal Frequency Constraints

Lecture 46 Subset Constraints

Lecture 47 Exclusion Constraints

Lecture 48 Practical Session - Internal Uniqueness Constraints

Lecture 49 Practical Session - Internal Uniqueness Constraints - Advanced - Boston

Lecture 50 Practical Session - External Uniqueness Constraints - Boston

Lecture 51 Practical Session - Ring Constraints - Boston

Lecture 52 Practical Session - Role Value Constraints - Boston

Lecture 53 Practical Session - Equality Constraints - Boston

Lecture 54 Practical Session - Subset Constraints - Boston

Lecture 55 Practical Session - Join Subset Constraints - Boston

Section 12: Transforming ORM Diagrams to Database Schema

Lecture 56 Introduction to transformation rules

Lecture 57 Transforming ORM diagrams to Relational Schema for Relational Databases

You want to learn how to design databases using Object-Role Modeling (ORM),You want to know the details of how ORM diagrams are constructed,You need to refresh your skills on ORM and conceptual modelling,You want to learn how to use ORM for relational and graph databases,You are a business analyst who wants to use ORM in your analysis