|If the composite primary key of a table is always an identifying type, should we have an identifying type relation in a database?|
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
Already have an account? Log In
Don't have an account? Register for Free Unlimited Access