<p/>Appendix C: The Wrox United Database - Beginning ASP.NET 1.1 with Visual C# .NET 1002003 [Electronic resources] نسخه متنی

PlayerID

Integer / AutoNumber

Primary Key,

Unique Unique identifier for each row in the database, generated automatically by the database whenever a new row is inserted.

PlayerName

String / Text, 50 characters

The name of the player.

JoinDate

DateTime

The date that the player joined the club.

Status

Integer / Number

Foreign Key (to the

StatusID column on the

Status table)

A link to the

Status table, used for specifying whether a player is active, injured, or retired.

Profile

String / Text, 255 characters

A brief description of the player.

SiteLogin

String / Text, 20 characters

A login name used to access restricted parts of the site.

SitePassword

String / Text, 20 characters

A password used to access restricted parts of the site.

Primary key-foreign key one-to-many relationships are a core part of relational database design, and enable us to minimize repetition of data in the database. It also aids consistency, and avoids several different variations of the same data being stored.

For example, without this relationship, we could include a

Status column in the

Players table to store text describing the active status of a player. This is a fine solution if you have tight control over the data that's inserted into the database, but if you allow users to enter custom strings of text for the values in this column, you could end up describing a player as being injured using the text "injured", "Injured", "sick", or "ill" instead of simply selecting the

Injured status from the

Status table.

StatusID

Integer / AutoNumber

Primary Key,

Unique Unique identifier for each row in the database, generated automatically by the database whenever a new row is inserted.

Status

String / Text, 50 characters

Description of the status (injured, active, retired). Each player in the Players team has to select one of these values.

TeamID

Integer / AutoNumber

Primary Key, Unique Unique identifier for each row in the database, generated automatically by the database whenever a new row is inserted.

TeamName

String / Text, 50 characters

The name of the team.

Notes

String / Memo

Description of the team, plus any additional information that may be useful. This field is long enough to hold several thousand characters of data.

PlayerID

Integer / Number

Part of Primary Key

Link to the ID of the Player.

TeamID

Integer / Number

Part of Primary Key

Link to the ID of the Team. Used together with the

PlayerID column, the Primary Key constraint specifies that each combination of

PlayerID and

TeamID must be unique.

Position

Integer / Number

Foreign Key (to the

PositionID column on the

Position table)

Used to specify, for each combination of Player and Team, the position the player plays in on that team.

PositionID

Integer / AutoNumber Primary Key, Unique

Unique identifier for each row in the database, generated automatically by the database whenever a new row is inserted.

PositionName

String / Text, 50 characters

Name of a position (left wing, defence, and so on).

GameID

Integer / AutoNumber Primary Key, Unique

Unique identifier for each row in the database, generated automatically by the database whenever a new row is inserted.

Location

Integer / Number Foreign Key (to the

LocationID column on the

Locations table)

Used to choose a location for the game, from the list defined in the

Locations table (for example, home or away.)

WroxTeam

Integer / Number Foreign Key (to the

TeamID column on the

Teams table)

Link to the

Teams table to select which Wrox team is participating in the game.

OpposingTeam

Integer / Number Foreign Key (to the

OpponentID column on the

Opponents table)

Link to the

Opponents table to select which opposing team is participating in the game.

GameType

Integer / Number Foreign Key (to the

GameTypeID column on

GameTypes table)

Link to the

GameTypes table to select the type of game (for example, a friendly or league match.)

Date

DateTime

The date of the match.

WroxGoals

Integer / Number

The number of goals scored by the Wrox team.

GameTypeID

Integer / AutoNumber Primary Key, Unique

Unique identifier for each row in the database, generated automatically by the database whenever a new row is inserted.

GameType

String / Text, 50 characters

The type of a match, for example, friendly or league.

LocationID

Integer / AutoNumber Primary Key, Unique

Unique identifier for each row in the database, generated automatically by the database whenever a new row is inserted.

LocationType

String / Text, 50 characters

The type of location (for example, home or away.)

OpponentID

Integer / AutoNumber Primary Key, Unique

Unique identifier for each row in the database, generated automatically by the database whenever a new row is inserted.

OpponentName

String / Text, 50 characters

The name of the opponent.

OpponentDescription

String / Memo

A description of the opponent that could be used, for example, to describe their strengths and weaknesses.

OpponentLocation

String / Text, 50 characters

The name of the home location of the opponent.

FanEmail

String / Text, 255 characters Primary Key, Unique

The email address of a fan. Since email addresses are individual, this field can be given a unique constraint and assigned as a primary key for the table.