-- this is an example

group: College

student=
{
 s_id:number,	s_name:string,	did:number
 1, aa, 11
 2, bb, 12
 3, cc, 13
 4, dd, 14
 5, ee, 11
 6, ff, 11
 7, gg, 13
 8, hh, 12
}

professor={
 pid:number, pname:string, did:number
 123, al, 11
 112, pha, 11
 134, beta, 12
 145, gama, 14
 157, row, 13
}

department={
	did:number,	dnmae:string
	11,	cise
	12,	ece
	13,	eee
	14,	chem
}

lecture={
	lid:number,	lname:string,	pid:number,	did:number
	90,	data,	134,	11
	91,	alg,	123,	11
	92,	ads,	145,	12
	93,	mis,	157,	13
	94,	ml,	145,	14
	95,	aml,	112,	11
}

register={
	sid:number, lid:number,	score:number,	sem:number
	1,90,100,1
	2,90,54,2
	1,90,91,3
	3,90,41,4
	4,91,61,1
	2,92,84,1
	5,93,83,2
	7,94,91,2
	8,95,95,3
	1,91,61,4
	2,93,79,1
	3,94,84,2
	4,93,86,1
	5,92,9,3
	5,91,91,2
	7,94,94,1
	6,91,80,3
}