I have read through all of the documentation extensively and now have a nice chat system setup for my home automation system which I am now expanding.
I cant seem to find a nice way to store the following information.
Example: Bob has a cat named Fluffy.
Normally the fact would just be Cat, Name and Fluffy. But adding in who owns the cat is where I am having problems.
Should I be sorting 2 seperate facts of Bob has a cat, and cat named fluffy. If so how do I link those 2 facts together? Or should I be storing this some how in a fact table?
Hope you can help. Thanks.