a db dataset sample for "dbis-uibk.github.io"

university-dataset.txt

group: university


stud = {
	sn:number, sname:string,city:string,avg:number,clgn:number
	71133848,mohammady,tehran,17.24,10
	72130502,vakili,isfahan,14.06,10
	72203305,alinaghizadeh,mashhad,16.42,1
	73120504,kamani,yazd,17.56,4
	73166801,ahmadi,kerman,15.44,5
	74182532,javadi,tehran,16.8,5
	74209836,hosseinzadeh,tabriz,12.2,6
	74209898,rashidi,isfahan,12.2,null
	71209415,rezaie,isfahan,15.2,null
	72541238,arefi,isfahan,11.2,null
	}
	
prof={
	pname:string,office:number,esp:string,degree:string,clgn:number
	shamsi,4,computer,master,10
	abootalebi,3,materials,doctor,6
	ghorbani,12,computer,doctor,10
	ashrafi,8,chemistry,doctor,5
	hashemi,10,computer,master,10
	jalali,5,electricity,doctor,7
	noghrekar,3,architecture,doctor,11
	hasani,2,math,doctor,1
	jahed,1,computer,doctor,10
	zaker,4,physics,doctor,2
	mafton,1,language,doctor,3
	sadeghi,3,industry,doctor,4
}

crs={
	cn:number,cname:string,unit:number,clgn:number
	10172,simulation,3,10
	10174,logic-circute,3,10
	12100,maref,2,12
	12564,calculus,4,1
	51516,chemistry,3,5
	71203,linear-control,3,7
	10183,database,3,10
	10542,algorithm,3,10
	51654,formalmethod,3,10
	}

sec={
	secn:number,cn:number,sn:number,term:number,pname:string,score:number
	1724,10172,71133848,761,hashemi,14.5
	1516,51516,74182532,752,ashrafi,17
	1747,10174,71133848,752,shamsi,15.75
	1747,10174,72130502,752,shamsi,12.5
	1748,10172,72203305,761,ghorbani,16.25
	1750,10183,72203305,963,jahed,12.75
	1751,10174,72130502,963,ghorbani,15.75
	1752,10172,73120504,963,sadeghi,17.2
}

clg={
	clgn:number,clgname:string,city:string,pname:string
	1,math,tehran,hasani
	10,computer,tehran,jahed
	11,architecture,yazd,noghrekar
	12,maref,tehran,khatami
	2,physics,mashhad,zaker
	3,language,mashhad,mafton
	4,industry,tehran,sadeghi
	5,chemistry,tehran,ashrafi
	6,materials,tabriz,abootalebi
	7,electricity,tehran,jalali
}