I have kind of the same question as "greyline" : How to implement 3NF (third normal form) in ArcGIS attribute tables?
I need, among other things, to place foreign key in my tables to combine them and I don't know how to do it with ArcGIS. I tried at first with "New -> Relationship Class" but I didn't have control on my attributes to select properly and avoid redundant data (I don't know the equivalent of "distinct" in ArcGIS commands). I am now trying to create a model that could combine the tables, but I don't know how to specify that each row for my "Date-t" tab, has to be linked to a single proper table in my database?
"Add join" details:
I am ready to change all the method if mine is wrong. I just cannot use the PostGIS since I don't have it.
The aim of this operation is to be able to fetch data from my tables using Python, but I think it's an other question.