A few thoughts:
Using a government assigned personal unique identifier is the way Celko's design uses the SSN is illegal in my part of the world so that is definitely something to watch out for.
While the DUNS system may be widely used there is certainly no requirement for a company to have such a number - I'd say that makes it unsuitable to use as a primary key.
I agree 70 characters is too few for the email address field, but in both designs the name fields are too short (in the case of the second far too short) and the case of the employee having only one name is not handled (depending on country this could be perfectly legitimate)
No comments:
Post a Comment