Skip to content

Instantly share code, notes, and snippets.

@gomes-fdr
Last active November 15, 2015 15:10
Show Gist options
  • Select an option

  • Save gomes-fdr/2d191edd6faac4c170f3 to your computer and use it in GitHub Desktop.

Select an option

Save gomes-fdr/2d191edd6faac4c170f3 to your computer and use it in GitHub Desktop.
relax-data-set
group: Sistema Acadêmico
DEPTO = {
CodDepto:string, NomeDepto:string
'ADS' , 'Analise e desenvolvimento de sistemas'
'REDES' , 'Redes'
'MODA' , 'Moda'
'MKT' , 'Marketing'
'INFO1' , 'Informatica'
}
DISCIPLINA = {
CodDepto:string, NumDisc:number, NomeDisc:string , CreditosDisc:number
'ADS' , 1 , 'Banco de dados 1', 4
'ADS' , 2 , 'Banco de dados 2', 4
'INFO1' , 3 , 'Algoritmo 1' , 4
}
PREREQ = {
CodDepto:string, NumDisc:number, CodDeptoPreReq:number, NumDiscPreReq:number
'1' , 2 , 1 , 1
}
TURMA = {
AnoSem:string, CodDepto:string, NumDisc:number, SiglaTur:string, CapacTur:number
'2002/1' , '1' , 1 , 'BD-1' , 50
'2002/1' , '1' , 2 , 'BD-2' , 50
'2003/1' , '1' , 1 , 'BD-1' , 30
'2003/1' , '1' , 2 , 'BD-2' , 30
}
HORARIO = {
AnoSem:string, CodDepto:string, NumDisc:number, SiglaTur:string, DiaSem:string, HoraInicio:string, NumHoras:number, CodPred:number, NumSala:number
'2002/1' , '1' , 1 , 'BD-1' , 'QUA' , '19:00' , 100 , 25 , 101
'2002/1' , '1' , 2 , 'BD-2' , 'SEX' , '19:00' , 100 , 3 , 101
}
PREDIO = {
CodPred:number, NomePred:string
1 , 'CENTRAL'
2 , 'UNIDADE 2'
3, 'Informática - Salas de Aula'
25, 'UNIDADE 3'
}
SALA = {
CodPred:number, NumSala:number, CapacSala:number
1 , 301 , 50
2 , 604 , 70
3, 101, 30
}
PROFESSOR = {
CodProf:number, NomeProf:string, CodTit:number, CodDepto:string
100 , 'Antonio Santos' , 1 , '1'
102 , 'Fábio' , 2 , '1'
103 , 'Jeffman' , 1 , 'INFO1'
}
PROFTURMA = {
AnoSem:string, CodDepto:string, NumDisc:number, SiglaTur:string, CodProf:number
'2002/1' , 1 , 1 , 'BD-1' , 100
'2002/2' , 1 , 2 , 'BD-2' , 102
'2002/1' , 1 , 3 , 'INFO1' , 103
}
TITULACAO = {
CodTit:number, NomeTit:string
1 , 'MESTRE'
2 , 'DOUTOR'
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment