Hello
I’m lost in the forest of data and can’t see the order for the trees. I have been playing with the data to setup importing, which is causing changes to my proposed data tree. (All VERY GOOD, Thanks Orange and Neil for the ideas, readings and the thoughts).
A typical data fragment is like “A” Company, 3rd Battalion, 502nd Parachute Infantry Regiment, was in Bastogne Belgium on Dec 1944. This statement has Unit, Title (“A”), Size (Company), Command (3rd Battalion), Family (502nd Regiment), Branch (inferred Infantry), Type (Parachute Infantry). This units’ Lineage is unstated but it was mobilized as infantry and converted in 1942. This whole fragment can also be shown as a graphic.
This data wants to break down (as I understand normalization) into following statement, a Unit has a Title, Lineage, Family, Command, Branch, Type, Size, and is in a Place. All of these things occurred because an Orders had been issued. An Order has a Working date, Date Range, Raw Date, Action, and if known the Authority, Effective date and Issued date. From this I’m getting a triple star data tree (Unit, Title, and Order) with repetitive table structure (UnitID, TitleID, OrderID, Note, and type filed or two).
So my question is multiple stars and repetitive table structures normal for a good database design?
Tree, data and order sample can be posted latter