title: Simple entity relationship redundancy error
body: <p>I am using ER Assistant to create my first entity relationship diagram.  </p>
  
  <p>I have created an entity called Users which contains the following attributes</p>
  
  <pre><code>UserID (identity 1,1) PK 
  
  UserName  (varchar, 50)
  </code></pre>
  
  <p>I have created a second entity called Logs, its attributes are</p>
  
  <pre><code>LogID (Identity 1,1) PK
  
  LogEntry (varchar, 256)
  
  UserID FK
  </code></pre>
  
  <p>I have assigned it assertions as follows, </p>
  
  <ul>
  <li>A user can create many logs</li>
  <li>A log must be created by only one user</li>
  </ul>
  
  <p>The relationship is defined as one user to many logs with user being mandatory and the logs are optional</p>
  
  <p>The error I am getting is: </p>
  
  <blockquote>
    <p>"The 'UserID' attribute in the 'Logs' entity type is redundant with
    the 'Creates' relationship.  Because 'UserID' is the primary key of
    'Users' it should not be an attribute of 'logs'.</p>
  </blockquote>
  
  <p>So my question is, if I do not place the UserID as a foreign key in the Logs table, how do i properly associate the two?  I thought I had a decent understanding of how this works but this is definitely not making sense to me at the moment. I am unsure if this is an error in the validity checking or I am actually doing this incorrectly. </p>