Learning relationships

모든 응답

• 2012년 2월 28일 화요일 오후 10:47

   

   
  

  0

  Here are a link for you to look at to start you off

  http://www.sqlteam.com/article/database-design-and-modeling-fundamentals

  I hope this helps

  ---

  Warwick Rudd
  MCT
  My SQL Server Blog
  Twitter
  -------------------------------------------------------
  Please mark as Answered if I have answered your question
  Please vote if this was useful
  -------------------------------------------------------
  

  • 응답
  • 인용

   
• 2012년 2월 29일 수요일 오전 6:45

  중재자

   

   
  

  0

  Hi Shan,

  What Warwick shared is a good start.There is also some online learning media you could refer to like http://learningsqlserver.wordpress.com/.

  If you have question about database design, you could make a post in Database Design forum.

  ---

  Best Regards,
  Peja
  
  Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

  • 응답
  • 인용

   
• 2012년 2월 29일 수요일 오전 9:07

   

   
  

  0

  Hi,

  Please go through the links below,

  http://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx

  http://www.informit.com/guides/content.aspx?g=sqlserver&seqNum=62

  http://www.mssqltips.com/sqlservertip/2380/sql-server-database-design-with-a-one-to-one-relationship/

  ---

  Thanks,
  Suresh
  Please use Mark or Propose as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

  • 응답
  • 인용

   
• 2012년 3월 12일 월요일 오후 6:36

  답변자

   

   
  

  0

  The following article has sample script to create a simple bank loan database. Cardinality of the relationships is indicated:

  http://www.sqlusa.com/bestpractices2005/bankdatabase/

  Celebrity table create with constraint:

  http://www.sqlusa.com/bestpractices2008/unique-constraint/

  ---

  Kalman Toth SQL SERVER & BI TRAINING

  
  
  
  

  • 편집됨 Kalman TothMicrosoft Community Contributor, Editor 2012년 3월 12일 월요일 오후 6:44
  • 답변으로 표시됨 Shan Khan 2012년 8월 29일 수요일 오전 8:33
  •  
  • 응답
  • 인용