DAMA - Puget Sound
 
 
The Premier Organization for Data Management Professionals in the Northwest
 
 

 

DAMA-PS Upcoming events

October 14, 2016 8:30 AM (PDT) • Sila Solutions Group, 6840 Fort Dent Way Suite 375 Seattle, WA 98188

Follow us on    

Sign Up for Our Monthly Newsletter

 Check the link to view a
 current listing of companies  with Corporate Memberships


Recent Community Updates

 

Upcoming Puget Sound Area events

November 07, 2016 12:00 AM (UTC-00:00) • London
December 08, 2016 8:30 AM (PST) • Washington State Convention Center, 800 Convention Pl, Seattle, WA 98101

October 1/2 Day Workshop

Data Modeling Constructs

with Subtypes & Supertypes

Friday, October 14, 2016

6840 Fort Dent Way, Suite 375, Seattle

8:30 - 12:30 p.m.

Summary

Subtypes & Supertypes offer a means to formally represent overlapping entity/object populations at the very beginning of the design process. If you are not using Subtypes & Supertypes in your data modeling, or want to deepen your understanding of these constructs, this session is for you. Knowledge and use of Subtypes/Supertypes should be in every data modeler's toolkit.


What You Will Learn:

  • “Abstractions” v. Collections  v. Generalization
  • Attribute, Relationship & Entity Generalization
  • Subtypes and Supertypes (Entity Generalization)
  •      Underlying assumptions; conditions
  •      Generalizations vs. Specialization
  •      Diagramming – Graphical Representations
  • Subtype / Supertype Constraints
  • Subtype Definition – distinguishing attribute
  • Sub/Supertype Hierarchy / Partial Lattice
  •      -The Universal Relation
  • Inheritance (single; multiple) & Reuse
  • Comparison of Modeling Schemes
  • Mapping to (Relational) Tables
  • Benefits of Subtype / Supertype

Speaker Profile

Dr. Gordon Everest is Professor Emeritus of MIS and Database in the Carlson School of Management at the University of Minnesota. With early "retirement," he continues to teach as an adjunct. 

His Ph.D. dissertation at the Univ of Pennsylvania Wharton School entitled "Managing Corporate Data Resources" became the text from McGraw-Hill, "Database Management: Objectives, System Functions, and Administration".  

Gordon has been teaching all about databases, data modeling, database management systems, database administration, and data warehousing since he joined the University in 1970. Students learn the theory of databases, gain practical experience with real data modeling projects, and with hands-on use of data modeling tools and DBMSs. Besides teaching about databases, he has helped many organizations and government agencies design their databases. Gordon is the recipient of the DAMA-I Academic Achievement Award, 2006 and again in 2011.

Event Schedule:

8:30 - 9:00 AM - Registration and Networking 

 (Light Continental Breakfast Provided)

9:00 - 12:00 PM - Intro & Presentation

12:00 - 12:30 PM - Q&As

Free parking available in front of the venue.


TO REGISTER CLICK HERE


Thanks to the 2016 Sponsors of DAMA Day!

                                          

                                                

                                                        


                   


                            

    








© DAMA Puget Sound 2013

Powered by Wild Apricot Membership Software