Sample data for the the Q4 of Relational Algebra Assignment for CS340

sample_data_q4.txt

-- this is for the Q4 of Relational Algebra Assignment for CS340

group: PlayerTeamCities 

Player = {
	id:number, score:number, team_id:number
	1,  100, 1
	2,	200, 2
	3,  99, 1
	4,	100, 2
	5,	150, 3
	6,  400, 4
}

Team = {
	id:number, name:string, city_id:number
	1,  'Team1', 3
	2,	'Team2', 1
	3,  'Team3', 4
	4,	'Team4', 1
	5,	'Team5', 2
	6,  'Team6', 1
}

City = {
	id:number, name:string
	1, 'St Petersburg'
	2, 'New York'
	3, 'London'
	4, 'Ontario'
}