Learn T-SQL Commands with Samples
Skip Navigation Links
Skip Navigation Links.
Expand DatabaseDatabase
Expand TableTable
Expand ViewView
Expand Stored ProcedureStored Procedure
Expand Data FilteringData Filtering
Expand Data GroupingData Grouping
Expand JoinsJoins
Expand TriggerTrigger
Expand CursorCursor
Expand OperatorsOperators
Expand ConstraintsConstraints
Expand FunctionsFunctions
Expand Conditional ProcessingConditional Processing
Expand LoopingLooping
Expand Error HandlingError Handling
Expand v.IMP Queriesv.IMP Queries
Expand XMLXML
Expand Query PerformanceQuery Performance
Expand QueriesQueries
Collapse NormalizationNormalization
Expand CreateCreate
     

Second Normal Form

  
      

      
Unnormalized table


      

      ID
      Nation
      Capital
      Game1
      Game2
      Game3
      


      

      1
      India
      Delhi
      Hockey
      Cricket
      Boxing
      


      

      2
      USA
      Washington
      Baseball
      Swimming
      Cycling
      


      

    
      1. Create separate tables for sets of values that apply to multiple records.
      2. Relate these tables with a foreign key.



 ---- after dividing the data into 2 Tables using 2nd NF 

      

      

            

      
Nations


      

      ID  
      Nation  
      Capital
      


      

      1
      India
      Delhi
      


      

      2
      USA
      Washington
      


      

           
            

      
Games


      

      ID  
      Game
      


      

      1
      Hockey
      


      

      1
      Cricket
      


      

      1
      Boxing
      


      

      2
      Baseball
      


      

      2
      Swimming
      


      

      2
      Cycling