Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Mastering Object-Role Modeling

Name: Mastering Object-Role Modeling
Rating: 4.6 (8 reviews)

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

Created byVictor Morgante

Last updated 11/2023

English

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

Course content

12 sections • 58 lectures • 6h 22m total length

Welcome0:48
Course Overview - Mastering Object-Role Modeling3:58
What you'll need0:48
Access the online course with internet, practice object role models with pen and paper, and use the provided ORM software (Boston on Windows)—you can complete the course without practical exercises.
What you'll learn0:15

What is Object-Role Modeling5:56
Explore object role modeling as a graphical, fact-based approach to conceptual modeling and database structures across universes of discourse, linking to entity relationship diagrams and property graph schemas.
The benefits of Object-Role Modeling4:20
Object role modeling clarifies the universe of discourse using natural language, reduces ambiguity, and enables rule-based transformations to third normal form for relational databases, ER diagrams, and property graph schemas.
The Uses of Object-Role Modeling7:45
Object-Role Modeling Made Easy - Bonus Video1:08:19
In this lecture I make Object-Role Modeling easy to understand. As an instructor I'd like you to get the most value out of this course. So I've made a video that will make your journey of learning ORM that much simpler. If there is a way to flick a switch and disambiguate a methodology that may otherwise seem complex, I hope this is it for you.

Business Rules and Object-Role Modeling2:46
Verbalisations - Rules in Natural Business Language3:52
Explore verbalizations in object role modeling and learn how natural language explanations illuminate a cinema seat booking model, capturing seats, rows, cinemas, sessions, and bookings as business rules.
Introduction to the Practical Sessions1:47
Explore object role modeling with the Boston conceptual modeling software, starting with a top-down overview and quickly moving to bottom-up techniques, while you can rewind and replay as needed.
Practical Session - Capturing Business Rules using Boston9:56
Explore how object role modeling captures business rules for university information systems, using the Boston ORM tool, glossary view, verbalization view, and documentation generator.
Practical Session - Verbalisations6:02
Explore verbalizations in object role modeling using the Boston conceptual modeling software to translate model elements into natural language, including external and internal uniqueness constraints and fact types.

Entity Types in Object-Role Modeling4:52
Explore how object role modeling uses rounded rectangles to define entity types, identify them by reference schemes, and distinguish simple and compound identities through roles in relationships.
Subtype Relationships8:16
Practical Session - Adding an Entity Type to a Model using the Toolbox - Boston1:25
Add an entity type to a Boston conceptual model using the shapes toolbox, drag it onto the page, then rename it with a capital first letter per the naming convention.
Practical Session - Adding a Reference Mode to an Entity Type - Boston4:29
Practical Session - Reference Schemes and Entity Types12:30

Fact Types - The basics5:27
Objectified Fact Types4:59
Explore objectified fact types in object role modeling by examining a part in a bin in a warehouse as a stocked item with unique part, bin, and warehouse identification.
Fact Types and Internal Uniqueness Constraints11:15
Learn internal uniqueness constraints in object role modeling, where horizontal bars over fact-type roles enforce unique values and define one-to-many, many-to-one, or many-to-many associations in sample data.
Preferred Identifiers - Constraints7:55
Derived Fact Types6:58
Practical Session - Adding a Fact Type to a Model using the Toolbox - Boston4:11
Watch the video for the practical session.
Download and double-click on the attached resource FBM model to load it into Boston for the session.
Adding a Ternary Fact Type to a Model in Boston4:23
Watch the video for the practical session.
Download and double-click on the attached resource FBM model to load it into Boston for the session.
Practical Session - Objectifying a Fact Type - Boston6:52
Watch the video for the practical session.
Download and double-click on the attached resource FBM model to load it into Boston for the session.

Image via Dreamstime.com under license to Victor Morgante. ID 102810076 © Seventyfourimages | Dreamstime.com
Practical Session - Creating Fact Types using the Virtual Analyst - Boston6:34
Learn to create binary fact types with mandatory and optional roles in Boston using the virtual analyst, including internal uniqueness constraints for first and last names and optional middle name.
Practical Session - Internal Uniqueness Constraints - Boston7:28
Watch the video for the practical session.
Download and double-click on the attached resource FBM model to load it into Boston for the session.
Practical Session - Internal Uniqueness Constraints - Advanced11:07

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

Who this course is for:

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

Mastering Object-Role Modeling

What you'll learn

Explore related topics

Course content

Introduction4 lectures • 6min

Software for the course2 lectures • 1min

Object-Role Modeling - Introduction4 lectures • 1hr 26min

Database Design and Conceptual Modeling1 lecture • 13min

Business Rule Capturing5 lectures • 24min

Fact-Based Modeling and Object-Role Modeling1 lecture • 3min

The Object Types of Object-Role Modeling1 lecture • 4min

Value Types4 lectures • 18min

Entity Types5 lectures • 32min

Fact Types11 lectures • 1hr 17min

Requirements

Description

Who this course is for: