Member 10865129 wrote:more importantly HOW you got
* Remove all calculated facts
* Assign a key
* Move repeating groups to their own table
(key is underlined)
* Find the attributes that are not "functionally dependent" on the entire key
That means that we look at each non-key field and ask ourselves whether or not it is depending on the entire key, or whether it can be identified with a part of that key.
The only non-key field in "Meetings" is called "Duration". The duration "2" belongs to the meeting that's identified with all three fields, so there's no functional dependency there. In the original table the duration could depend on a part of the key; my mistake.
* Find non-key fields that depend on other non-key fields.
One might argue that the Attorney is also a repeating group, and put it in it's own table with an artificial key.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]