This entity describes a match between two teams. Candidate keys: gameID Primary key: gameID Strong/Weak Entity: Weak Fields to be indexed: gameID, Date Name gameID homeScore awayScore time date gameType weather Description An A positive A positive Time of Date of What Weather number number bet bet type of forcast for value. game is the game this? Domain/Type 32 bit 32 bit 32 bit Time Date String String Unsigned Unsigned Unsigned Integer Integer Integer Range 0 2^32 0 999 0 999 Current Current Any char … … … time only Date only season, array regular playoff, Default Value None null null Current Current None null time Date No Yes Yes No No No Yes Nullable? Unique? Yes No No No No No No Single or Single Multiple Multiple Multiple Multiple Multiple Multiple Multiple Value Simple or Simple Simple Simple Composite Composite Simple Composite Composite Team
This entity describes a match between two teams. Candidate keys: gameID Primary key: gameID Strong/Weak Entity: Weak Fields to be indexed: gameID, Date Name gameID homeScore awayScore time date gameType weather Description An value. A positive number A positive number Time of bet Date of bet What type of game is this? Weather forcast for the game Domain/Type 32 bit Unsigned Integer 32 bit Unsigned Integer 32 bit Unsigned Integer Time Date String String Range 0 … 2^32 0 … 999 0 … 999 Current time only Current Date only regular season, playoff, Any char array Default Value None null null Current time Current Date None null Nullable? No Yes Yes No No No Yes Unique? Yes No No No No No No Single or Multiple Value Single Multiple Multiple Multiple Multiple Multiple Multiple Simple or Composite Simple Simple Simple Composite Composite Simple Composite Team
Nick%20Kott%20Phase%20V.docx