The Dreaded “One to One” Relationship, or Why “Boaring” Movies Are Best

Another Example of “Relationship May Be Needed” When You Do, In Fact, Have a Relationship

Let’s pick up the topic from last week and examine another instance where you might encounter the dreaded warning message above.

Let’s start with this simple pivot:


Which is a column from the Years table and a column from the Movies table:


But now I have a new table:  Animals, which simply lists, for each year, which Animal is specified by the Chinese Zodiac:


Hollywood Insiders Know That the Animals of the Chinese Zodiac Are
Incredibly Important to Box Office Revenues


Read the Rest