Return to Answer

Both are correct in the sense that both are normalized, based on your question. It seems like there isn't a strong consensus on whether to use natural keys or surrogate keys (the ids). Here are a couple of stackexchange questions on the subject:

• Surrogate vs. natural/business keys [closed]
• Should every table have a single-field surrogate/artificial primary key?

Both are correct in the sense that both are normalized, based on your question. It seems like there isn't a strong consensus on whether to use natural keys or surrogate keys (the ids). Here are a couple of stackexchange questions on the subject:

• Surrogate vs. natural/business keys [closed]
• Should every table have a single-field surrogate/artificial primary key?

Both are correct in the sense that both are normalized, based on your question. It seems like there isn't a strong consensus on whether to use natural keys or surrogate keys (the ids). Here are a couple of stackexchange questions on the subject:

• Surrogate vs. natural/business keys [closed]
• Should every table have a single-field surrogate/artificial primary key?

Both are correct in the sense that both are normalized, based on your question. It seems like there isn't a strong consensus on whether to use natural keys or surrogate keys (the ids). Here are a couple of stackexchange questions on the subject:

• Surrogate vs. natural/business keys [closed]
• Should every table have a single-field surrogate/artificial primary key?

Both are correct in the sense that both are normalized, based on your question. It seems like there isn't a strong consensus on whether to use natural keys or surrogate keys (the ids). Here are a couple of stackexchange questions on the subject:

• http://stackoverflow.com/questions/63090/surrogate-vs-natural-business-keys
• Should every table have a single-field surrogate/artificial primary key?

Both are correct in the sense that both are normalized, based on your question. It seems like there isn't a strong consensus on whether to use natural keys or surrogate keys (the ids). Here are a couple of stackexchange questions on the subject:

• Surrogate vs. natural/business keys [closed]
• Should every table have a single-field surrogate/artificial primary key?