So many of us have learned data modeling and database design approaches from working with one database or data technology. We may have used only one design tool.  That means our vocabularies around identifiers and keys tend to be product specfic.  Do you know the difference between a unique index and a unique key? What about the difference between RI, FK and AK? Do you know if your surrogate keys have their companion alternate keys?

In this session we’ll look at the generic and proprietary terms for these concepts, as well as where they fit in the data modeling and database design process.  We’ll also look at implementation options across a few commercial DBMSs and datastores. These concepts span data activities and it’s important that your team understand each other and where they, their tools and approaches fit to produce a succesful database design. 
Presented by Karen Lopez at SQLBits XV
Slide Deck 1.5 MB