Continue in 2 seconds

If the composite primary key of a table is always an identifying type, should we have an identifying type relation in a database?

Published
  • December 09 2003, 1:00am EST
More in

Q:

If the composite primary key of a table is always an identifying type, should we have an identifying type relation in a database?

A:

Chuck Kelley’s Answer: I will assume that your definition of relation is table. It is not to everyone. If you are using a dimensional model, then I would use a surrogate key in the table as opposed to a new table.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access