title: sql server - library management system design
body: <p>I'm designing a library database schema, let's say there is a book, it belongs to several subjects, how to design the column to store those subjects? use nvarchar to store the subjectId(s)? <br></p>
  
  <pre><code>---------
  Book
  ---------
  id    ----- int 
  title ----- nvarchar(50)
  subjectId ----- int (foreign key to Subject table)
  
  ---------
  Subject
  ---------
  id    ----- int 
  name ----- nvarchar(50)
  </code></pre>