Skip to content

Latest commit

 

History

History
109 lines (72 loc) · 4.63 KB

readme.md

File metadata and controls

109 lines (72 loc) · 4.63 KB
Raw

The study of UDM

The study of UDM is guided by ideas discussed in the book Data Model Resource Book by Len Silverston and our experience with it in Apache OFBiz.

Book Link: Data Model Resource Book, Volume 1

Required reading: The first five chapters of Data Model book.

Chapter 1: Introduction

Key Takeaways:

  • What Is the Intent of This Book and These Models?
  • Conventions and Standards Used in This Book
  • Naming Conventions for an Entity
  • Role of Entity with the Suffix TYPE in their Name
  • Subtypes and Supertypes: Subtypes Represent Possible Classifications
  • Non-Mutually Exclusive Sets of Subtypes
  • Conventions Used in Attribute Naming
  • Intersection or Association Entities to Handle Many-to-Many Relationships (also known as associative or cross-reference entities)
  • Data Model Patterns
  • General Entity Overview
  • Design a Taxonomy

Chapter 2: People and Organizations

Prerequisite: Prepare a dataset based on the following prompts:

  • What are the attributes or characteristics of the people (students and college staff) and organizations (university/college, its departments) involved in college education?
  • What relationships exist between various people, between various organizations, and between people and organizations?
  • What are the addresses, phone numbers, and other contact mechanisms of people and organizations, and how can they be contacted?
  • What types of communication or contacts have occurred between various parties, and what is necessary to effectively follow up on these communications?

Activity:

Chapter 3: Products

Prerequisite: Prepare a dataset based on the following prompts:

  • Visit your online shopping account history.
  • Prepare a list of products.
  • Add pricing and category details for each product.
  • Lookup product bundles on Amazon and take note of the bundle product name and the names of products included in the bundle.

Activity:

Chapter 4: Ordering Products

Activity:

Chapter 5: Shipments

Activity:

Complete the Following Activities

UDM Basics

  1. Party Data Model
  2. Contact Mechanism
  3. Party Activity
  4. Product Associations
  5. Product Types
  6. Product Feature
  7. Product Category Explained
  8. Setup Company Product Store and Catalog
  9. Order
  10. Order Activity
  11. Shipment

UDM Intermediate

  1. Design CDP
  2. Design PIM
  3. Design OMS

SQL Intermediate

  1. SQL Assignment 1
  2. SQL Assignment 2
  3. SQL Assignment 3