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

June 4, 2013

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:

image

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

image

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

image

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

 

Read the rest of this entry »