db

group: nameOfTheNewGroup 

Country = {
	country_id:number,country_name:string
	1, US
	2, CAN
	3, CHINA
}

city = {
	city_id:number, city_name:string, population:number, country_id:number
	1, LA, 80000, 1
	1, ON, 100000, 2
	1, QC, 50000, 2
	2, GD, 100000000, 3
}

language = {
	lang_id:number, lang_name:string
	1, CN
	2, EN
	3, OMG
}

countrylanguage = {
	country_id:number, lang_id:number, percentage:number
	1, 2, 100
	2, 2, 80
	2, 1, 20
	3, 1, 100
}