EDM Assignment 2.pdf - Dhananjay Shinkar UCID dps48 A dependency diagram for the 1st normal form showing the primary key and all transitive and partial

EDM Assignment 2.pdf - Dhananjay Shinkar UCID dps48 A...

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

Dhananjay Shinkar UCID : dps48 A dependency diagram for the 1st normal form showing the primary key and all transitive and partial dependencies 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 Partial Dependencies Partial Dependencies Partial Dependencies Transitive Dependencies
Image of page 1
Dhananjay Shinkar UCID : dps48 Relational Schemas 1 St Normal Form: BASEBALL_INFO(playerid, Player Name, birthCity, birthState, birthCountry, HallOfFame Year, schoolID, College Year, College Name, lgID, Team Name, Stadium Name, teamid, Year Played, Park key, Position, Assist, Errors, Put Outs, Hits, Base of Balls, Home Runs, Earned Run Average, Games managed, Wins Managed, Losses managed, Rank of teams Managed)
Image of page 2

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture