Last active
November 5, 2020 01:31
-
-
Save JoaoFelipe/483e5f736efd9fb44dd73536624e74f2 to your computer and use it in GitHub Desktop.
CEDERJ - Algebra Relacional - Aula 16
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- this is an example | |
| group: empresa | |
| Empregado = { | |
| pnome minicial unome ssn datanasc endereco sexo salario superssn dno | |
| John B Smith 123456789 1965-01-09 "731 Fondren, Houston, TX" M 30000 333445555 5 | |
| Frankin T Wong 333445555 1955-12-08 "658 Voss, Houston, TX" M 40000 888665555 5 | |
| Alicia J Zelaya 99988777 1968-01-19 "3321 Castle, Soring, TX" F 25000 987654321 4 | |
| Jennifer S Wallace 987654321 1941-06-20 "291 Berry, Bellaire, TX" F 43000 8886655555 4 | |
| Ramesh K Narayan 666884444 1962-09-15 "975 Fire Oak, Humble, TX" M 38000 333445555 5 | |
| Joyce A English 453453453 1972-07-31 "5631 Rice, Houston, TX" F 25000 333445555 5 | |
| Ahmad V Jabbar 987987987 1969-03-29 "980 Dallas, Houston, TX" M 25000 987654321 4 | |
| James E Borg 8888665555 1937-11-10 "450 Stone, Houston, TX" M 55000 null 1 | |
| } | |
| Departamento = { | |
| dnome dnumero gerssn gerdatainicio | |
| Pesquisa 5 333445555 1988-05-22 | |
| Administracao 4 967654321 1995-01-01 | |
| "Sede administrativa" 1 888665555 1981-06-19 | |
| } | |
| Depto_Localizacoes = { | |
| dnumero dlocalizacao | |
| 1 Houston | |
| 4 Stafford | |
| 5 Bellaire | |
| 5 Sugarland | |
| 5 Houston | |
| } | |
| Projeto = { | |
| pjnome pnumero plocalizacao dnum | |
| ProdutoX 1 Bellaire 5 | |
| ProdutoY 2 Sugarland 5 | |
| ProdutoZ 3 Houston 5 | |
| Automatizacao 10 Stafford 4 | |
| Reorganizacao 20 Houston 1 | |
| "Novos Beneficios" 30 Stafford 4 | |
| } | |
| Trabalha_Em = { | |
| essn pno horas | |
| 123456789 1 32.5 | |
| 123456789 2 7.5 | |
| 666884444 3 40.0 | |
| 453453453 1 20.0 | |
| 453453453 2 20.0 | |
| 333445555 2 10.0 | |
| 333445555 3 10.0 | |
| 333445555 10 10.0 | |
| 333445555 20 10.0 | |
| 999887777 30 30.0 | |
| 999887777 10 10.0 | |
| 987987987 10 35.0 | |
| 987987987 30 5.0 | |
| 987654321 30 20.0 | |
| 987654321 20 15.0 | |
| } | |
| Dependente = { | |
| essn nome_dependente sexo datanasc parentesco | |
| 333445555 Alice F 1986-04-05 FILHA | |
| 333445555 Theodore M 1983-10-25 FILHO | |
| 333445555 Joy F 1958-05-03 CONJUGE | |
| 987654321 Abner M 1942-02-28 CONJUGE | |
| 123456789 Michael M 1988-01-04 FILHO | |
| 123456789 Alice F 1988-12-30 FILHA | |
| 123456789 Elizabeth F 1967-05-05 CONJUGE | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment