Surrogate Key Semantics

From: <jonshin2003_at_yahoo.com>
Date: 11 Nov 2005 09:10:47 -0800
Message-ID: <1131729046.993356.262540_at_g49g2000cwa.googlegroups.com>

I have two questions with regard to database semantics for surrogate keys. Thanks in advance. Jon

---

Question 1

---

Table A has a surrogate key called ID.

Table B has a 1:1 relationship with table A by way of A.ID. So, B.ID maps to A.ID to define the relationship.

Is B.ID called a surrogate key even though it is not made up for that table, but for A.ID originally?

---

Question 2

---

Table A has a surrogate key called ID.
Table B has a surrogate key called ID.
Table C's primary key is a composite key made up of A.ID and B.ID.

Are the two fields in C (A.ID and B.ID) still called surrogate keys when we are talking about table C, or are they only known as surrogate keys to the original tables? Received on Fri Nov 11 2005 - 18:10:47 CET