Skip to content

Instantly share code, notes, and snippets.

@isti03

isti03/AB1.txt

Last active February 22, 2025 16:04
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save isti03/dd2430e965c5cedcc19e4a1a927bfbfb to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save isti03/dd2430e965c5cedcc19e4a1a927bfbfb to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. isti03 revised this gist Feb 22, 2025. 1 changed file with 1 addition and 4 deletions.
    5 changes: 1 addition & 4 deletions AB1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -1,5 +1,4 @@
    group: AB1 Szeret
    description[[ Szeret(nev, gyumolcs) relacio ]]
    group: AB1

    Szeret = {
    nev:string, gyumolcs:string
    @@ -16,8 +15,6 @@ nev:string, gyumolcs:string
    'Füles', 'alma'
    }

    group: AB1 Dolgozo
    description[[ Dolgozo(dkod, dnev, foglalkozas, fonoke, belepes, fizetes, jutalek, oazon) relation ]]
    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
  2. isti03 created this gist Feb 22, 2025.
    58 changes: 58 additions & 0 deletions AB1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,58 @@
    group: AB1 Szeret
    description[[ Szeret(nev, gyumolcs) relacio ]]

    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'
    }

    group: AB1 Dolgozo
    description[[ Dolgozo(dkod, dnev, foglalkozas, fonoke, belepes, fizetes, jutalek, oazon) relation ]]
    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
    }