Normalization Assignment - Copy.docx - Partial Dependency Partial Dependency TD Partial Dependency Baseball Data playerid Player Name birthCity

Normalization Assignment - Copy.docx - Partial Dependency...

This preview shows page 1 - 3 out of 3 pages.

FIRST NORMAL FORM PRIMARY KEY : Player_ID , College Year , Year Played, Park Key, Position Partial Dependency – noted in Transition Dependency – noted in Transition Dependency Partial Dependency Partial Dependency Partial Dependency Partial Dependency T D Transition Dependency Baseball Data playerid Player Name birthCity birthState birthCountry HallofFame Year schoolID College Year College Name lgID Team Name Stadium Name teamid Year Played Park Key Position Assists Errors Put Outs Hits Base of Balls Home Runs Earned Run Average Games Managed Wins Managed Losses Managed Rank of Team Managed
Image of page 1
SECOND Normal Form In order to remove the Partial Dependency, Creating new tables for all the Partial dependency. Table Name : Player playerID Player Name Birth city Birth state Country Halloffameyear Table Name : Player_Academics playerID College year School ID College name Table Name : Team Player ID
Image of page 2
Image of page 3

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture