Track and Field Database

Answers

• 

  

  0

  Sign in to vote

  Create table Athlets contain all info about them, last name, first name, address and etc. Also you have to add teamid references to teams table

  Create table teams contain info about the teams , teamid, teamname

  Create table events,....

  ---

  Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
  
  MS SQL optimization: MS SQL Development and Optimization
  MS SQL Consulting: Large scale of database and data cleansing
  Remote DBA Services: Improves MS SQL Database Performance
  SQL Server Integration Services: Business Intelligence
  

  • Proposed as answer by Lydia ZhangMicrosoft contingent staff Thursday, December 24, 2015 2:50 AM
  • Marked as answer by Lydia ZhangMicrosoft contingent staff Thursday, December 31, 2015 6:56 AM

  Wednesday, December 23, 2015 7:41 AM
• 

  

  0

  Sign in to vote

  Hi DCToronto,

  Adding to other post, you need to create foreign fey relationships among these tables in order to associate rows of one table with rows of another. For more details about how to create foreign fey, please review the examples in  the following articles.

  Create Foreign Key Relationships
  https://msdn.microsoft.com/en-us/library/ms189049(v=sql.120).aspx

  SQL SERVER – 2008 – Creating Primary Key, Foreign Key and Default Constraint
  http://blog.sqlauthority.com/2008/09/08/sql-server-%E2%80%93-2008-creating-primary-key-foreign-key-and-default-constraint/

  Thanks,
  Lydia Zhang

  ---

  Lydia Zhang
  TechNet Community Support

  
  

  • Proposed as answer by Lydia ZhangMicrosoft contingent staff Wednesday, December 30, 2015 6:11 AM
  • Marked as answer by Lydia ZhangMicrosoft contingent staff Thursday, December 31, 2015 6:56 AM

  Thursday, December 24, 2015 2:58 AM