The Key to Keys
Application & Database Development
So many of us have learned database design approaches from working with one database or data technology. We may have used only one data modeling or development tool. That means our vocabularies around identifiers and keys tend to be product specific. Do you know the difference between a unique index and a unique key? What about the difference between RI, FK and AK?
These concepts span data activities and it's important that your team understand each other and where they, their tools and approaches need to support these features.
We'll look at the generic and proprietary terms for these concepts, as well as where they fit in the database design process. We'll also look at implementation options in SQL Server and other DBMSs.
No material found.