X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Closed TopicStart new topic
> ACCGeneral Primary Keys - Natural vs Surrogate    
post Feb 13 2005, 06:28 PM

Posts: 14,079
Joined: 26-September 02
From: Sudbury, Ontario, Canada

Title: ACCGeneral Primary Keys: Surrogate or Natural
Symptom: You want to use a consistent approach to creating primary keys in your databases. You are aware of a debate concerning whether natural keys or surrogates are generally preferable.
Subject: This tutorial discusses the theoretical background that should inform the choice of natural or surrogate keys to be used as primary keys.
Applies to: all versions of Access and databases generally Tested in: n/a
Skill level: basic knowledge for intermediate and advanced users
Author: Glenn Lloyd Date: February 12, 2005
Credits: Utter Access members who have contributed to forum discussions on the topic, Microsoft-AccessSolutions.co.uk (now www.databasedev.co.uk), and an article by Michelle A. Poolet in SQL Server Magazine (http://www.win2000mag.com/SQLServer/Article/ArticleID/23449/23449.html)

Keywords: keys, primary keys, surrogate keys, natural keys, candidate keys, database development standards

Edited to correct typo on page 5 of the attachement "may NOT contain null values"

Edited to up date reference to article that first appeared on Microsoft-AccessSolutions.co.uk. Article link in the tutorial also changed. (sept '06)

Edited by: argeedblu on Sun Feb 13 20:12:53 EST 2005.
Edited by: argeedblu on Mon Sep 11 6:20:42 EDT 2006.
Attached File(s)
Attached File  ACCGeneralPrimaryKeys.zip ( 23.33K )Number of downloads: 2446
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    5th June 2020 - 01:10 PM