I was just playing around with the ABCD Database and I realized that you can have duplicate records.
I tried a few combinations of composite keys, but that doesn't work either because of the blank fields.
- Combined FirstName & LastName Composite Key - Combined FirstName & LastName & Organization Composite Key - But not every record has an organization & - Not every record has a FirstName LastName
I love the idea of the Entity table for both People and Organizations together, but I don't want to have duplicate records.
And I realize you can use the groups, but you can still end up with duplicate records in the EntityT
Is the only way to ensure that there is no exact duplicates, is to have separate Person and Organization tables?
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
ABCD Core Part 6.
