gistfile1.txt

group: UIBK - R, S, T
description: Tables from and for the lecture [Databases: Foundations, Data Models and System Concepts - University of Innsbruck](http://dbis-informatik.uibk.ac.at/249-0-VO-Datenbanksysteme.html) chapter 3 
category@de:Universität Innsbruck
category@en:University of Innsbruck

empregado = {
	pnome:string, ssn:string,salario:number,superssn:string,dno:number
	
	John,1234,30000,3334,5
	Frank,3334,4000,8886,5
	Alicia,9998,25000,9876,4
	Jenifer,9876,43000,8886,4
	Ramesh,6668,38000,3334,5
	Joice,4534,25000,3334,5
	Ahmad,9879,25000,9876,4
	James,8886,55000,null,1

}

departamento = {

dnome:string,dnumero:number,gerssn:string,gerdatainicio:string

pesquisa,5,3334,1988-05-22
adm,4,9876,1995-01-01
sedeAdm,1,8886,1981-06-19

}

dept_localizacoes = {

dnumero:string,dlocalizacao:string

1,houston
4,staford
5,bellare
5,suga

}

trabalha_em ={

essn:string,pno:number,horas:number

1234,1,32.5
1234,2,7.5
6668,3,40.0
4534,1,20.0
4534,2,20.0
3334,2,10.0
3334,3,10.0
3334,10,10.0
3334,20,10.0
9998,30,30.0
9998,10,10.0
9879,10,35.0
9879,30,5.0
9876,30,20.0
9876,20,15.0
8886,20,null

}

projeto =  {

pnome:string,pnumero:number,plocalizacao:string,dnum:number

produtox,1,bellare,5
produtoy,2,sufa,5
produtoz,3,houston,5
automa,10,staford,4
reorga,20,houston,1
novos_bene,30,staford,4


}

dependente = {
essn:string,nome_dependente:string,sexo:string,datanasc:string,parentesco:string

3334,alice,f,1988-04-05,filha
3334,theof,m,1983-10-25,filho
3334,joy,f,1958-05-03,conjuge
9876,abner,m,1942-02-06,conjuge
1234,michael,m,1988-01-04,filho
1234,alice,f,1988-12-30,filha
1234,eliza,f,1967-05-05,conjuge

}