Skip to content

Instantly share code, notes, and snippets.

@isti03
Last active February 22, 2025 16:04
Show Gist options
  • Select an option

  • Save isti03/dd2430e965c5cedcc19e4a1a927bfbfb to your computer and use it in GitHub Desktop.

Select an option

Save isti03/dd2430e965c5cedcc19e4a1a927bfbfb to your computer and use it in GitHub Desktop.
RelaX tables for AB1
group: AB1
Szeret = {
nev:string, gyumolcs:string
'Malacka', 'alma'
'Malacka', 'körte'
'Malacka', 'dinnye'
'Malacka', 'málna'
'Micimackó', 'alma'
'Micimackó', 'körte'
'Micimackó', 'dinnye'
'Kanga', 'alma'
'Tigris', 'alma'
'Tigris', 'körte'
'Füles', 'alma'
}
Dolgozo={
dkod:number, dnev:string, foglalkozas:string, fonoke:number, belepes:date, fizetes:number, jutalek:number, oazon:number
7369, SMITH, CLERK, 7902, 1980-12-17, 800, null, 20
7499, ALLEN, SALESMAN, 7698, 1981-02-20, 1600, 300, 30
7521, WARD, SALESMAN, 7698, 1981-02-22, 1250, 500, 30
7566, JONES, MANAGER, 7839, 1981-04-02, 2975, null, 20
7654, MARTIN, SALESMAN, 7698, 1981-09-28, 1250, 1400, 30
7698, BLAKE, MANAGER, 7839, 1981-05-01, 4250, null, 30
7782, CLARK, MANAGER, 7839, 1981-06-09, 2450, 200, 10
7788, SCOTT, ANALYST, 7566, 1982-12-09, 3000, null, 20
7839, KING, PRESIDENT, null, 1981-11-17, 5000, null, 10
7844, TURNER, SALESMAN, 7698, 1981-09-08, 1500, 10, 30
7876, ADAMS, CLERK, 7788, 1983-01-12, 1100, null, 20
7900, JAMES, CLERK, 7698, 1981-12-03, 950, null, 30
7902, FORD, ANALYST, 7566, 1981-12-03, 3000, 700, 20
7934, MILLER, CLERK, 7782, 1982-01-23, 1300, 600, 10
8001, COOK, MANAGER, 7839, 1981-06-09, 3800, null, 50
8002, HART, SALESMAN, 8001, 1982-05-09, 1600, 200, 50
8003, WOLF, CLERK, 8001, 1983-04-09, 1000, null, 50
}
Osztaly={
oazon:number, onev:string, telephely:string
10, ACCOUNTING, 'NEW YORK'
20, RESEARCH, 'DALLAS'
30, SALES, 'CHICAGO'
40, OPERATIONS, 'BOSTON'
50, MARKETING, 'DENVER'
}
Fiz_kategoria={
kategoria:number, also:number, felso:number
1, 700, 1200
2, 1201, 1400
3, 1401, 2000
4, 2001, 3000
5, 3001, 9999
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment