Sure:CREATE TABLE Teams( TeamID int PRIMARY KEY IDENTITY(1,1) NOT NULL, TeamName varchar(64) NOT NULL, TeamIndex smallint NOT NULL UNIQUE)CREATE TABLE Members( MemberID int PRIMARY KEY IDENTITY(1,1) NOT NULL, FirstName varchar(128) NOT NULL, LastName varchar(128) NOT NULL, PersNr varchar(10) NOT NULL, OriginalClub varchar(128), SeasonNr varchar(4), BirthYear varchar(4))CREATE TABLE TeamMembers( TeamMemberID int PRIMARY KEY IDENTITY(1,1) NOT NULL, TeamID int NOT NULL REFERENCES Teams(TeamID), MemberID int NOT NULL REFERENCES Members(MemberID), TypeID int NOT NULL REFERENCES MemberTypes(TypeID), MemberImageID int REFERENCES MemberImages(MemberImageID), SpecificType varchar(128), Number varchar(4), Nickname varchar(32), Presentation text)
As you can see there are other things in the tables but I didnt think they were interesting in this case.