group: branyi

/* -------- Sz Szm -------------------------------- */
Sz = {
n:string, gy:string
'Füles','málna'
'Füles','körte'
'Füles','alma'
'Micimackó','málna'
'Micimackó','körte'
'Micimackó','dió'
'Kanga','körte'
'Nyuszi','eper'
'Malacka','körte'
'Malacka','alma'
'Malacka','eper'
'Malacka','málna'
'Malacka','dió'
'Tigris','körte'
'Tigris','málna'
} 
Szeret = {
nev:string, gyumolcs:string
'Füles','málna'
'Füles','körte'
'Füles','alma'
'Micimackó','málna'
'Micimackó','körte'
'Micimackó','dió'
'Kanga','körte'
'Nyuszi','eper'
'Malacka','körte'
'Malacka','alma'
'Malacka','eper'
'Malacka','málna'
'Malacka','dió'
'Tigris','körte'
'Tigris','málna'
}
Szm = { n:string, gy:string, m:number
'Füles','málna', 6
'Füles','körte', 9
'Füles','alma' , 7
'Micimackó','málna',10
'Micimackó','körte', 4
'Micimackó','dió'  , 2
'Kanga','körte',10
'Nyuszi','eper' , 6
'Malacka','körte', 5
'Malacka','alma' , 7
'Malacka','eper' , 3
'Malacka','málna', 2
'Malacka','dió'  , 5
'Tigris','körte', 7
'Tigris','málna', 3
}

/* -------Emp Dept Salgrade ---------------------------- */
Dept = {deptno:number, dname:string, loc:string
10,'ACCOUNTING','NEW YORK'
20,'RESEARCH','DALLAS'
30,'SALES','CHICAGO'
40,'OPERATIONS','BOSTON'
}

Emp = {empno:number, ename:string, job:string, mgr:number, hiredate:string, sal:number, comm:number, deptno:number
7839,'KING','PRESIDENT',NULL,'1981-11-17',5000,NULL,10
7698,'BLAKE','MANAGER',7839,'1981-05-01',2850,NULL,30
7782,'CLARK','MANAGER',7839,'1981-06-09',2450,NULL,10
7566,'JONES','MANAGER',7839,'1981-04-02',2975,NULL,20
7654,'MARTIN','SALESMAN',7698,'1981-09-28',1250,1400,30
7499,'ALLEN','SALESMAN',7698,'1981-02-20',1600,300,30
7844,'TURNER','SALESMAN',7698,'1981-09-08',1500,0,30
7900,'JAMES','CLERK',7698,'1981-12-03',950,NULL,30
7521,'WARD','SALESMAN',7698,'1981-02-22',1250,500,30
7902,'FORD','ANALYST',7566,'1981-12-03',3000,NULL,20
7369,'SMITH','CLERK',7902,'1980-12-17',800,NULL,20
7788,'SCOTT','ANALYST',7566,'1982-12-09',3000,NULL,20
7876,'ADAMS','CLERK',7788,'1983-01-12',1100,NULL,20
7934,'MILLER','CLERK',7782,'1982-01-23',1300,NULL,10
8000,'PROBA','DOLGOZO',NULL,'1980-11-27',6000,NULL,50
}

Salgrade = {grade:number, losal:number, hisal:number
1,  700, 1200
2, 1201, 1400
3, 1401, 2000
4, 2001, 3000
5, 3001, 9999
}

/* --------- Osztaly Dolgozo Fiz_kategoria ---------- */
Osztaly = {ozaon:number, onev:string,telephely:string
10,'ACCOUNTING','NEW YORK'
20,'RESEARCH','DALLAS'
30,'SALES','CHICAGO'
40,'OPERATIONS','BOSTON'
}

Dolgozo = {dkod:number, dnev:string, foglalkozas:string, fonoke:number, belepes:string, fizetes:number, jutalek:number, oazon:number
7839,'KING','PRESIDENT',NULL,'1981-11-17',5000,NULL,10
7698,'BLAKE','MANAGER',7839,'1981-05-01',2850,NULL,30
7782,'CLARK','MANAGER',7839,'1981-06-09',2450,NULL,10
7566,'JONES','MANAGER',7839,'1981-04-02',2975,NULL,20
7654,'MARTIN','SALESMAN',7698,'1981-09-28',1250,1400,30
7499,'ALLEN','SALESMAN',7698,'1981-02-20',1600,300,30
7844,'TURNER','SALESMAN',7698,'1981-09-08',1500,0,30
7900,'JAMES','CLERK',7698,'1981-12-03',950,NULL,30
7521,'WARD','SALESMAN',7698,'1981-02-22',1250,500,30
7902,'FORD','ANALYST',7566,'1981-12-03',3000,NULL,20
7369,'SMITH','CLERK',7902,'1980-12-17',800,NULL,20
7788,'SCOTT','ANALYST',7566,'1982-12-09',3000,NULL,20
7876,'ADAMS','CLERK',7788,'1983-01-12',1100,NULL,20
7934,'MILLER','CLERK',7782,'1982-01-23',1300,NULL,10
7877,'LOLA','CLERK',7902,'1981-01-12',800,NULL,NULL
7878,'BLACK',NULL,7902,'1987-05-01',1800,300,NULL
}

Fiz_kategoria = {kategoria:number, also:number, felso:number
1,700,1200
2,1201,1400
3,1401,2000
4,2001,3000
5,3001,9999
}

/* ------- Hajoosztalyok Csatak Kimenetelek Hajok ----- */
Hajoosztalyok = {osztaly:string, tipus:string, orszag:string, agyukszama:number, kaliber:number, vizkiszoritas:number
'Bismark','bb','Németország',8,15,42000
'Iowa','bb','USA',9,16,46000
'Kongo','bc','Japán',8,14,32000
'North Carolina','bb','USA',9,16,37000
'Renown','bc','Nagy Britannia',6,15,32000
'Revenge','bb','Nagy Britannia',8,15,29000
'Tennessee','bb','USA',12,14,32000
'Yamato','bb','Japán',9,18,65000
}

Csatak = { csatanev:string, datum:string
'Denmark Strait','5/24-27/41'
'Guadalcanal','11/15/42'
'North Cape','12/26/43'
'Suriago Strait','10/25/44'
}

Kimenetelek = {hajonev:string,csatanev:string,eredmeny:string
'Arizona','Pearl Harbour','elsüllyedt'
'Bismark','Denmark Strait','elsüllyedt'
'California','Surigao Strait','ok'
'Duke of York','North Cape','ok'
'Fuso','Surigao Strait','elsüllyedt'
'Hood','Denmark Strait','elsüllyedt'
'King George V','Denmark Strait','ok'
'Kirishima','Guadalcanal','elsüllyedt'
'Prince of Wales','Denmark Strait','sérült'
'Rodney','Denmark Strait','ok'
'Scharnhorst','North Cape','elsüllyedt'
'South of Dakota','Guadalcanal','sérült'
'Tennessee','Surigao Strait','Ok'
'Washington','Guadalcanal','ok'
'West Wirginia','Surigao Strait','ok'
'Yamashiro','Surigao Strait','elsüllyedt'
}

Hajok = { hajonev:string, osztaly:string, felavatva:number 
'California','Tennessee',1921
'Haruna','Kongo',1915
'Hiei','Kongo',1914
'Iowa','Iowa',1943
'Kirishima','Kongo',1915
'Kongo','Kongo',1913
'Missuri','Iowa',1944
'Musashi','Yamato',1942
'New Jersey','Iowa',1943
'North Carolina','North Carolina',1941
'Ramillies','Revenge',1917
'Renown','Renown',1916
'Repulse','Renown',1916
'Resolution','Revenge',1916
'Revenge','Revenge',1916
'Royal Oak','Revenge',1916
'Royal Sovereign','Revenge',1916
'Tennesse','Tenesse',1920
'Washington','North Carolina',1941
'Wisconsin','Iowa',1944
'Yamato','Yamato',1941
}
/* --------- Termek Pc Laptop Nyomtato -------------- */

Termek = {gyarto:string, modell:number, tipus:string
'A',1001,'pc'
'A',1002,'pc'
'A',1003,'pc'
'A',2004,'laptop'
'A',2005,'laptop'
'A',2006,'laptop'
'B',1004,'pc'
'B',1005,'pc'
'B',1006,'pc'
'B',2007,'laptop'
'C',1007,'pc'
'D',1008,'pc'
'D',1009,'pc'
'D',1010,'pc'
'D',3004,'nyomtató'
'D',3005,'nyomtató'
'E',1011,'pc'
'E',1012,'pc'
'E',1013,'pc'
'E',2001,'laptop'
'E',2002,'laptop'
'E',2003,'laptop'
'E',3001,'nyomtató'
'E',3002,'nyomtató'
'E',3003,'nyomtató'
'F',2008,'laptop'
'F',2009,'laptop'
'G',2010,'laptop'
'H',3006,'nyomtató'
'H',3007,'nyomtató'
}


Pc = { modell:number, sebesseg:number, memoria:number, merevlemez:number,ar:number
1001,2.66,1024,250,2114
1002,2.10,512,250,995
1003,1.42,512,80,478
1004,2.80,1024,250,649
1005,3.20,512,250,630
1006,3.20,1024,320,1049
1007,2.20,1024,200,510
1008,2.20,2048,250,770
1009,2.00,1024,250,650
1010,2.80,2048,300,770
1011,1.86,2048,160,959
1012,2.80,1024,160,649
1013,3.06,512,80,529
}


Laptop = {modell:number, sebesseg:number, memoria:number,merevlemez:number, kepernyo:number,ar:number
2001,2.00,2048,240,20.1,3673
2002,1.73,1024,80,17.0,949
2003,1.80,512,60,15.4,549
2004,2.00,512,60,13.3,1150
2005,2.16,1024,120,17.0,2500
2006,2.00,2048,80,15.4,1700
2007,1.83,1024,120,13.3,1429
2008,1.60,1024,100,15.4,900
2009,1.60,512,80,14.1,680
2010,2.00,2048,160,15.4,2300
}

Nyomtato = {modell:number, szines:string, tipus:string,ar:number
3001,'igen','tintasugaras',3673
3002,'nem','lézer',949
3003,'igen','lézer',549
3004,'igen','tintasugaras',1150
3005,'nem','lézer',2500
3006,'igen','tintasugaras',1700
3007,'igen','lézer',1429
}

/* ---- Pizza Pizzarendeles Fogyaszt Hozzavalo ------------ */
Pizza = { psorszam:number, pnev:string, ar:number
1,'Rodrigo',1000
2,'Fitt',2000
3,'Nevada',990
4,'Hawaii',2000
5,'Sonkás',2500
6,'Brutal',990
7,'Remete',1500
8,'Barbecue csirke',1730
9,'Makó',1740
10,'Colorado',1740
11,'Sanda Banya',1740
12,'Drakula',1740
13,'Salami',1740
14,'Sonkás gombás',1750
15,'Calzone',1750
16,'Jenki',1750
17,'Mexikói csirke',1750
18,'Barbecue',1750
19,'Vámpír csók',1750
20,'Hombre',1750
21,'King Kong',1750
22,'Milánói',1770
23,'Vendetta',1770
24,'Zorro',1770
25,'Bohém',1770
26,'Kamikaze',1770
27,'Tonno',1810
28,'Matróz',1810
29,'Kapitány',1810
30,'Húsimádó',1830
31,'Sombrero',1830
32,'Kaliforniai',1830
33,'Capone',1830
34,'Monaco',1830
35,'Johanna',1830
36,'Macopa',1830
37,'Corleone',1830
38,'Ínyenc',1840
39,'Magyaros',1840
40,'Csülkös',1880
41,'Mexikói',1910
42,'Tengerész',1910
43,'Kalóz',1910
44,'PRÓBA',1660
}

Pizzarendeles = {szemelyazon:number, psorszam:number, datum:string 
16,'1','2019-04-28'
2420,'17','2021-01-01'
2420,'31','2021-01-19'
2,'42','2021-01-20'
2,'43','2021-02-14'
3,'3','2021-02-27'
7,'3','2021-02-28'
9,'3','2021-03-15'
9,'4','2021-03-06'
9,'13','2021-03-22'
10,'43','2021-03-29'
12,'5','2021-03-31'
12,'13','2021-02-17'
14,'13','2021-02-20'
14,'16','2021-03-05'
15,'8','2021-02-20'
15,'9','2021-04-02'
2415,'3','2021-03-06'
2415,'42','2021-03-23'
2415,'43','2021-04-01'
16,'8','2021-02-14'
16,'9','2021-03-27'
2419,'2','2021-01-26'
2419,'3','2021-02-15'
2419,'4','2021-03-23'
2419,'8','2021-01-02'
2419,'12','2021-01-31'
2419,'14','2021-03-22'
2419,'25','2021-02-21'
2419,'31','2021-04-02'
20,'8','2021-02-22'
23,'5','2021-03-31'
23,'10','2021-02-27'
23,'19','2021-03-06'
23,'31','2021-03-20'
23,'32','2021-04-03'
25,'22','2021-03-18'
30,'1','2019-04-29'
03,'44','2019-04-30'
30,'1','2019-04-30'
30,'1','2021-03-18'
30,'1','2021-02-15'
}

Fogyaszt = { szemely:string, psorszam:number, darab:number  pizzazo:string
'Zénó' 1 3 'Pizzéria1'
'Zénó' 4 5 'Pizzéria2'
'Zénó' 3 2 'Pizzéria3'
Alfonz 2 2 'Pizzéria2'
Alfonz 6 4 'Pizzéria5'
S2 6 2 'Pizzéria2'
S3 6 4 'Pizzéria3'
'Zénó' 6 1 'Pizzéria5'
S4 6 2 'Pizzéria2'
S5 6 3 'Pizzéria5'
S1 6 2 'Pizzéria5'
S4 4 1 'Pizzéria4'
S5 7 2 'Pizzéria5'
S1 5 5 'Pizzéria1'
S3 5 5 'Pizzéria6'
'Zabagép' 1 1 'Pizzéria1'
'Zabagép' 2 1 'Pizzéria2'
'Zabagép' 3 1 'Pizzéria3'
'Zabagép' 4 1 'Pizzéria4'
'Zabagép' 5 1 'Pizzéria3'
'Zabagép' 6 1 'Pizzéria2'
'Zabagép' 7 1 'Pizzéria1'
}

Hozzavalo = { psorszam:number, alapanyag:string, mennyiseg:number
1 kukorica 3
1 'oregánó' 1
2 'oregánó' 2
2 sajt 2
3 kukorica 1
3 sajt 2
4 'oregánó' 1
5 kukorica 2
7 sajt 1
7 sonka 1}

/* ------------ Szemely Hasznal Okoseszkoz -------------- */
Szemely = {azon:number, vnev:string, knev:string, eletkor:number
1,'Acél','Azár',34
2,'Acél','István',37
3,'Acél','Kürt',41
4,'Acél','Tarcsa',54
5,'Acél','Titán',25
6,'Acél','Üllő',75
7,'Ács','Milán',93
8,'Agyalá','Gyula',91
9,'Akciós','Áron',41
10,'Akó','Bora',85
11,'Akó','Ivó',71
12,'Alapi','Csaba',86
13,'Áldott','Aura',55
14,'Alföldi','Aura',94
15,'Alföldi','Délibáb',48
16,'Alfréd','Béni',74
17,'Alka','Ida',21
18,'Alle','Glória',97
19,'Álló','Csillag',51
20,'Álló','Ella',91
21,'Álló','Farkas',80
22,'Alma','Bora',84
23,'Alma','Itala',27
24,'Alma','Tea',63
25,'Álmos','Előd',72
26,'Álmos','Kürt',71
27,'Aloe','Vera',87
28,'Alsó','Örs',74
29,'Am','Erika',51
30,'Andriska','Kálmán',39
31,'Angyal','Alett',26
100,'Bak','Ancsa',59
101,'Bak','Tas',51
998,'Hájas','Nimfa',54
999,'Hájas','Szirén',82
1000,'Hájas','Vitéz',92
2371,'Pokoli','Tormás',68
2372,'Pokoli','Zizi',21
2373,'Polgár','Örs',51
2374,'Polgár','Örsi',51
2375,'Pop','Csillag',76
2376,'Pop','Kornél',48
2377,'Pop','Rokkó',65
2378,'Pop','Simon',25
2379,'Popp','Simon',73
2390,'Pót','Napóleon',93
2391,'Pót','Szilveszter',36
2392,'Pötsch','Andrea',31
2393,'Próba','Alfonz',35
2394,'Próba','Anita',80
2395,'Próba','Anna',50
2396,'Próba','Balázs',67
2397,'Próba','Beáta',89
2398,'Próba','Bence',88
2399,'Próba','Benedek',67
2400,'Próba','Dezső',68
2401,'Próba','Emese',35
2402,'Próba','Ervin',52
2403,'Próba','Ferenc',84
2404,'Próba','Gábor',35
2405,'Próba','János',87
2406,'Próba','József',90
2407,'Próba','Lajos',87
2408,'Próba','László',24
2409,'Próba','Ottó',74
2410,'Próba','Ödön',100
2411,'Próba','Pál',45
2412,'Próba','Panna',60
2413,'Próba','Péter',55
2414,'Próba','Próba',73
2415,'Próba','Sándor',32
2416,'Próba','Sári',59
2417,'Próba','Tamás',33
2418,'Próba','Tibor',58
2419,'Próba','Zabagép',73
2420,'Próba','Zénó',73
2421,'Próba','Zsófia',79
2422,'Próba','Zsuzsanna',43
2120,'Ó','Pió',39
2121,'Ó','Piusz',63
2122,'Ó','Rómeó',86
2123,'Ó','Tünde',59
2124,'Ó','Virág',84
2125,'Oda','Buda',53
2126,'Odor','Bodor',95
2127,'Odor','Fodor',94
2128,'Odor','Teodor',32
2129,'Ódor','Tódor',63
2130,'Oguz','Bán',79
2131,'Okos','Antal',23
2132,'Okos','Tóbiás',91
2133,'Okos','Tóni',58
2134,'Okos','Zseni',44
2135,'Oktob','Ernő',98
2136,'Oláh','Jolán',86
2137,'Olaj','Alett',58
2138,'Olaj','Ivó',68
2139,'Olaj','Sugár',93
}

Hasznal = {szemelyazon:number , okosazon:number
2131 1
2131 2
2131 3
2132 1
2132 4
2132 2
1000 2
2134 2
2393 6
2384 7
2394 2
2395 4
2395 2
2133 1
2133 2
2133 3
2133 4
2133 5
2133 6
2133 7
1 1
1 2
1 3
}

Okoseszkoz = {okosazon:number, eszkoztipus:string, marka:string, vetelar:number
1 'okosóra' Samsung 50000
2 okostelefon Xiaomi 80000
3 'okoseszköz' M1 100000
4 'okosóra' Samsung 600000
5 okosvalami M2 71111
6 'okoskészülék' Xiaomi 111111
7 'okosdrága' Samsung 543210}

/* ----------- Hotel Szoba Foglalas ---------------------- */
Hotel = {hotelazon hotelnev:string, varos:string, telefonszam:string
1 Hilton Budapest T1
2 'The Grand Budapest' Budapest T2
3 Marriott Budapest T3
4 Clark Budapest T9
5 Novotel Budapest T12
6 Novotel Szeged T4
7 Tisza Szeged T5
8 Sport Debrecen T6
9 Corso 'Pécs' T7
10 Bellevue 'Esztergom' T8
11 Wellness 'Gyula' T10
12 Park 'Eger' T11
13 Park 'Gyula' T12
}

Szoba = {szobaszam:number, hotelazon:number, tipus:string, ar:number
314 1 single 123
543 1 family 987
314 2 family 234
314 3 single 345
543 3 family 456
314 4 single 324
543 4 family 567
123 8 'kétágyas' 543
314 9 single 876
1 10 family 200
2 4 single 300
3 11 family 400
4 13 single 500
5 5 'egyéb' 678
10 6 single 444
50 10 single 300
60 10 'kétágyas' 500
70 10 'egyéb' 800
}

Foglalas = {fazon:number, ugyfelnev:string, hotelazon:number, szobaszam:number, erkezes:date, ejszakak:number
1 U1 1 314 2020-01-01 5
2 U1 3 314 2020-02-01 3
3 U1 7 123 2020-02-15 1
4 U2 2 543 2020-03-01 2
5 U2 6 123 2020-04-01 4
6 U2 5 543 2020-01-15 6
7 U3 6 543 2019-10-10 2
8 U4 1 314 2019-01-01 5
9 U4 2 543 2019-03-01 2
10 U4 3 314 2019-02-01 3
11 U4 7 123 2019-02-15 1
12 U4 6 123 2019-04-01 4
13 U4 7 314 2019-04-01 4
14 U4 10 1 2019-04-01 4 
15 U4 4 2 2019-04-01 4
16 U4 10 3 2019-04-01 4
17 U4 11 4 2019-04-01 4
18 U4 5 678 2019-04-01 4
}

/* --------------------Olimpia Sportolo Eredmeny */

Olimpia = {ev:number, varos:string, osszkoltseg:number
1996,'Atlanta',1900
2000,'Sydney',2500
2004,'Athén',2000
2008,'Peking',4000
2012,'London',3270
}

Sportolo = {nev:string, orszag:string, szuldatum:string
'Rózsa Norbert','Magyarország','1972-02-09'
'Egerszegi Krisztina','Magyarország','1974-08-16'
'Czene Attila','Magyarország','1974-06-20'
'Márkus Erzsébet','Magyarország','1969-08-23'
'Massimiliano Rosolino','olasz',null
'Michael Phelps','Egyesült Államok',null
'Güttler Károly','Magyarország',null
'Gyurta Dániel','Magyarország',null
}

Eredmeny = { nev:string, ev:number, versenyszam:string, helyezes:number
'Rózsa Norbert',1996,'200m-es mellúszás',1
'Egerszegi Krisztina',1996,'200m-es hátúszás',1
'Egerszegi Krisztina',1996,'400m-es vegyesúszás',3
'Czene Attila',1996,'200m-es vegyesúszás',1
'Márkus Erzsébet',2000,'súlyemelés',2
'Massimiliano Rosolino',2000,'200m-es vegyesúszás',1
'Michael Phelps',2004,'200m-es vegyesúszás',1
'Michael Phelps',2004,'400m-es vegyesúszás',1
'Rózsa Norbert',1996,'200m-es mellúszás',1
'Güttler Károly',1996,'200m-es mellúszás',2
'Gyurta Dániel',2004,'200m-es mellúszás',2
'Gyurta Dániel',2012,'200m-es mellúszás',1
}

Bars = {name:string, addr:string, license:string
'Australia Hotel','The Rocks','123456'
'Coogee Bay Hotel','Coogee','966500'
'Lord Nelson','The Rocks','123888'
'Marble Bar','Sydney','122123'
'Regent Hotel','Kingsford','987654'
'Royal Hotel','Randwick','938500'
'Joe`s','Maple St.','938501'
'Sue`s','River Rd.','938502'
'Black Rock','9 Christopher St.','936107'
'Bob',' St Thomas St.','936123'
'Down Under Pub','802 W. Main Street','A1234'
'The Edge','108 Morris Street','A1235'
'James Joyce Pub','912 W. Main Street','B12300'
'Satisfaction','905 W. Main Street','C1111'
'Talk of the Town','108 E. Main Street','A1000'
}

Beer = {name:string , brewer:string
'Amstel','Amstel Brewery'
'Budweiser','Anheuser-Busch Inc.'
'Corona','Grupo Modelo'
'Dixie','Dixie Brewing'
'Erdinger','Erdinger Weissbrau'
'Full Sail','Full Sail Brewing'
'80/-','Caledonian'
'Bigfoot Barley Wine','Sierra Nevada'
'Burragorang Bock','George IV Inn'
'Crown Lager','Carlton'
'Fosters Lager','Carlton'
'Invalid Stout','Carlton'
'Melbourne Bitter','Carlton'
'New','Toohey`s'
'Old','Toohey`s'
'Old Admiral','Lord Nelson'
'Pale Ale','Sierra Nevada'
'Premium Lager','Cascade'
'Red','Toohey`s'
'Sheaf Stout','Toohey`s'
'Sparkling Ale','Cooper`s'
'Stout','Cooper`s'
'Three Sheets','Lord Nelson'
'Victoria Bitter','Carlton'
'Bud','Anheuser-Busch'
'Bud Lite','Anheuser-Busch'
'Michelob','Anheuser-Busch'
'Spotted cow','New Glarus Brewing Company'
'Spotted badger','New Glarus Brewing Company'
'Spotted deer','New Glarus Brewing Company'
}

Drinker = {name:string ,address:string
'Amy','100 W. Main Street'
'Ben','101 W. Main Street'
'Coy','200 S. Duke Street'
'Dan','300 N. Duke Street'
'Eve','100 W. Main Street'
}

Drinkers = {name:string ,addr:string,phone:string 
'Adam','Randwick','9385-4444'
'Gernot','Newtown','9415-3378'
'John','Clovelly','9665-1234'
'Justin','Mosman','9845-4321'
}

Frequent = {drinker:string, bar:string,times_a_week
'Amy','James Joyce Pub', 2
'Ben','James Joyce Pub', 1
'Ben','Satisfaction', 2
'Ben','Talk of the Town', 1
'Coy','Down Under Pub', 1
'Coy','The Edge', 1
'Dan','Down Under Pub', 2
'Dan','The Edge', 1
'Dan','James Joyce Pub', 1
'Dan','Satisfaction', 2
'Dan','Talk of the Town', 2
'Eve','James Joyce Pub', 2
}

Frequents = {drinker:string,bar:string
'Adam','Coogee Bay Hotel'
'Gernot','Lord Nelson'
'John','Coogee Bay Hotel'
'John','Lord Nelson'
'John','Australia Hotel'
'Justin','Regent Hotel'
'Justin','Marble Bar'
}

Serves = {bar:string , beer:string, price:number
'Down Under Pub','Amstel', 2.75
'Down Under Pub','Budweiser', 2.25
'Down Under Pub','Corona', 3.00
'The Edge','Amstel', 2.75
'The Edge','Budweiser', 2.50
'The Edge','Corona', 3.00
'James Joyce Pub','Amstel', 3.00
'James Joyce Pub','Corona', 3.25
'James Joyce Pub','Dixie', 3.00
'James Joyce Pub','Erdinger', 3.50
'Satisfaction','Amstel', 2.75
'Satisfaction','Budweiser', 2.25
'Satisfaction','Corona', 2.75
'Satisfaction','Dixie', 2.75
'Satisfaction','Full Sail', 2.75
'Talk of the Town','Amstel', 2.50
'Talk of the Town','Budweiser', 2.20
}

Likes = {drinker:string, beer:string
'Amy','Amstel'
'Amy','Corona'
'Ben','Amstel'
'Ben','Budweiser'
'Coy','Dixie'
'Dan','Amstel'
'Dan','Budweiser'
'Dan','Corona'
'Dan','Dixie'
'Dan','Erdinger'
'Eve','Amstel'
'Eve','Corona'
'Adam','Crown Lager'
'Adam','Fosters Lager'
'Adam','New'
'Gernot','Premium Lager'
'Gernot','Sparkling Ale'
'John','80/-'
'John','Bigfoot Barley Wine'
'John','Pale Ale'
'John','Three Sheets'
'Justin','Sparkling Ale'
'Justin','Victoria Bitter'
'Sally','Bud'
'Fred','Bud'
'Jan','Heineke'
'Jan','Cheers'
'Jan','Grolsch'
'Jan','California'
'Jan','Amstel'
'Jaap','California'
'Jan','Leffe'
'Jaap','Rock cafe'
'Cheers','Amstel'
'Jan','Duvel'
'Peter','Cheers'
'Cheers','Leffe'
'Jaap','Grolsch'
'Peter','Rock cafe'
'Jaap','Duvel'
'Paul','Cheers'
'Peter','Koning'
'Paul','Flamingo'
'Peter','Duvel'
'Mary','California'
'Peter','Heineken'
'Mary','Flamingo'
'Peter','Leffe'
'Sue','Rock cafe'
'Paul','Heineken'
'Jolande','California'
'Paul','Duvel'
'Jolande','Cheers'
'Paul','Grolsch'
'Susan','Cheers'
'Mary','Grolsch'
'Susan','Old dutch'
'Sue','Amster'
'Sue','Koning'
'Sue','Duvel'
'Jolande','Heineken'
'Jolande','Grolsch'
'Jolande','Amstel'
'Susan','Duvel'
'Susan','Koning'
}

Sells = {bar:string, beer:string, price:number
'Australia Hotel','Burragorang Bock',3.50
'Coogee Bay Hotel','New',2.25
'Coogee Bay Hotel','Old',2.50
'Coogee Bay Hotel','Sparkling Ale',2.80
'Coogee Bay Hotel','Victoria Bitter',2.30
'Lord Nelson','Three Sheets',3.75
'Lord Nelson','Old Admiral',3.75
'Marble Bar','New',2.80
'Marble Bar','Old',2.80
'Marble Bar','Victoria Bitter',2.80
'Regent Hotel','New',2.20
'Regent Hotel','Victoria Bitter',2.20
'Royal Hotel','New',2.30
'Royal Hotel','Old',2.30
'Royal Hotel','Victoria Bitter',2.30
'Joe`s','Bud',2.5
'Joe`s','Miller',2.75
'Sue`s','Bud',2.5
'Sue`s','Coors',3
'Sue`s','Miller',3
}

Menu = {beer:string, price:number
}

Sor = {nev:string, orszag:string, gyarto:string
'Soproni 1895','magyar','Heineken'
'Soproni Fekete Démon','magyar','Heineken'
'Soproni Szűz','magyar','Heineken'
'Soproni Citrom','magyar','Heineken'
'Soproni Narancs','magyar','Heineken'
'Soproni Körte','magyar','Heineken'
'Soproni Grapefuit','magyar','Heineken'
'Soproni Zéró Narancs','magyar','Heineken'
'Soproni Zéró Grapefruit','magyar','Heineken'
'Gösser Spezial','magyar','Heineken'
'Gösser NaturZitrone','magyar','Heineken'
'Gösser Alkoholfreies Naturbier','magyar',' Heineken'
'Gösser NaturZitrone 0,0%','magyar','Heineken'
'Amstel','magyar','Heineken'
'Zlaty Bazant','magyar','Heineken'
'Kaiser','magyar','Heineken'
'Edelweiss','magyar','Heineken'
'Steffl','magyar','Heineken'
'Edelweiss','magyar','Heineken'
'Buckler','magyar','Heineken'
'Storngbow Gold','magyar','Heineken'
'Kozel','cseh','Kozel'
'Dreher Classic','magyar','Dreher'
'Dreher Bak barna','magyar','Dreher'
'Dreher 24','magyar','Dreher'
'Arany Ászok világos','magyar','Dreher'
'Arany Ászok félbarna','magyar','Dreher'
'Arany Ászok alkoholmentes','magyar','Dreher'
'Pilsner Urquell','magyar','Dreher'
'Miller Genuine Draft','magyar','Dreher'
'Kőbányai Sör','magyar','Dreher'
'Kanizsai','magyar','Dreher'
'Rocky Cellar','magyar','Dreher'
'Goldberger','magyar','Dreher'
'Hofbräu Lager','magyar','Dreher'
'Nimród','magyar','Dreher'
'Dreher','német','Dreher'
'Borsodi Sör','magyar','Borsodi'
'Borsodi Póló','magyar','Borsodi'
'Borsodi Bivaly','magyar','Borsodi'
'Borostyán','magyar','Borsodi'
'Rákóczi sör','magyar','Borsodi'
}

-- Neuberg, Kewer, Waldert, Ritterhof 	Dreher Sörgyárak Zrt.
-- Szalon (világos, barna, alkoholmentes), Ottakringer Spezial, Paulaner Hefe-Weissbier Naturtrüb, 
-- Paulaner Original Münchner Hell, Radler (bodza, lemon, málna, meggy, szeder) 	Pécsi Sörfőzde Zrt.

Bar = {nev:string, varos:string, tulaj:string
'Makk 7-es','Budapest','Géza'
'Lórúgás','Győr','Ica'
'Bob','Budapest','Bob'
}

Felszolgal = {sor:string, bar:string, ar:number
'Kozel','Makk 7-es',320
'Dreher','Makk 7-es',400
'Soproni','Lórúgás',280
}
/* ---------------- */

Filmek = { cim:string,  ev:number,  hossz:number,  mufaj:string,  studionev:string,  producerazon:number
'Csillagok háborúja',1977,124,'Sci-fi','Fox',12345
'Galaktikus kaland',1999,104,'vígjáték','DreamWorks',67890
'Wayne világa',1992,195,'vígjáték','Paramount',99999
'Elfújta a szél',1939,231,'dráma',null,null
}

Filmszinesz = { nev:string,  cim:string,  nem:string,  szuletesidatum:string
'Carrie Fisher','123 Maple St., Hollywood','N','9/9/99'
'Mark Hamill','456 Oak Rd., Brentwood','F','8/8/88'
'Harrison Ford','789 Palm Dr., Beverly Hills','F','7/7/77'
}


Szerepelbenne = {filmcim:string,filmev:number,szinesznev:string}

Gyartasiranyito = {nev:string,cim:string,azon:number,nettobevetel:number}

Studio = {nev:string, cim:string, elnokazon:number}

-- --------------------------------------------------------
-- megadja a mesehősök azonosítóját, nevét, címét és egyenlegét

Mesehos = {azon:string, nev:string, cim:string, egyenleg:number
'M01','Vasorrú Bába','Mézeskalács Ház',2500
'M02','Vadász','Vadászles',0
'M03','Micimackó','Százholdas Pagony',-1000
'M04','Maci Laci','Hollywood', 5030
'M05','Törpilla','Gombaház',null
'M06','Hétfejű sárkány','Sárkánybarlang', 700
'M07','A három nyúl','Nyusziház', -3400
'M08','Okoska','Gombaház',null
'M09','Piroska','Erdőszéli házikó', 6700
'M10','Tapsi Hapsi','Hollywood',9920
'M11','Süsü','Sárkánybarlang', 1130
'M12','Vuk','Rókalyuk', -250
'M13','Törpapa','Gombaház', 400
}

-- megadja, hogy az adott cikknek mekkora az egységára

Cikk = {cikknev:string ,egysegar:number
'répa',20
'mágnespor', 20
'cipő', 300
'puskagolyó', 50
'mézesbödön', 60
'kalács', 90
'sütőlapát', 150
'kosár', 200
'szemfesték', 150
'puska', 300
'smirgli', 20
'saláta', 100
'rókacsapda', 300
'pipihús', 200
'erős paprika', 20
'élesztő', 15
}

-- megadja, hogy az adott rendelési számú rendelést
-- mikor adta fel az adott azonosítójú mesehős


Rendeles = {rendszam:number, mazon:string, datum:string
6,'M07','2014-10-07'
13,'M05','2013-01-01'
16,'M02','2014-03-15'
17,'M07','2012-01-21'
22,'M01','2014-08-25'
23,'M02','2016-10-12'
25,'M02','2017-02-28'
34,'M05','2015-12-03'
37,'M01','2020-01-12'
46,'M01','2016-07-21'
49,'M02','2018-03-05'
53,'M03','2021-06-02'
61,'M09','2003-04-05'
66,'M07','2013-10-30'
78,'M01','2015-07-02'
80,'M02','2014-11-18'
97,'M09','2016-10-20'
}

-- megadja, hogy az adott rendelési számon az adott cikkből mekkora mennyiségben rendeltek

Tartalmaz = {  rendszam:number, cikknev:string, mennyiseg:number
6,'cipő',6
13,'szemfesték', 12
16,'rókacsapda', 3
17,'répa', 200
22,'mágnespor', 319
23,'szemfesték', 4
23,'saláta', 6
25,'puska', 2
34,'cipő', 2
37,'smirgli', 17
37,'mézesbödön', 3
37,'élesztő', 20
46,'szemfesték', 8
49,'puskagolyó', 56
53,'mézesbödön', 5
61,'kalács', 1
66,'saláta', 12
78,'sütőlapát', 1
80,'cipő', 2
97,'kosár', 1
}
/* ------------------- */
Jaratok = {szam:number, indulas:number, erkezes:number, honkod:string hovkod:string, napok:string
123 1152 1436 001 002 'hksc-sv'
111 1023 1145 002 001 'hkscp-v'
112 1535 1643 001 003 'hkscpsv'
113 2032 2115 003 001 'hks-psv'
114 1322 1423 003 004 '-ks-p—'
115 1415 1510 001 003 'hkscpsv'
}

Repter = {kod:string, varos:string, checkin:number, illetek:number
'001','Budapest Ferihegy 1',1,5000
'002','Praha',2,5000
'003','Warszawa Internacionalna',1,8000
'004','Paris Orly',2,10000
'005','London Heathrow',null,12000
}

Szamlak = {rkod:string, osszeg:number, kelt:string, rogz:string, szla:string
001 10000 '2020-10-08' 'Kovács' '99/M182'
003 30000 '2020-10-08' 'Nagy' '99/R436'
001 11328 '2020-12-28' 'Virág' '99/M183'
002 23560 '2020-01-13' 'Lakatos A.' '00/M182'
002 2356 '2021-02-09' 'Virág' '00/M011'
002 48000 '2021-04-11' 'Hegyi' '00/M032'
003 42000 '2020-06-12' 'Magyar Béla' '01/R136'
004 9364 '2020-07-30' 'Kiss Edit' '01/R658'
004 12000 '2020-08-28' 'Tóth Ádám' '01/R200'
}

/* --------Employees ---------*/
Employees = {employee_id:number,first_name:string,last_name:string,email:string,phone_number:string,hire_date:string,job_id:string,salary:number,commission:number,manager_id:number,department_id:number
100,'Steven','King','SKING','515.123.4567','1987-06-17','AD_PRES',24000,null,null,90
101,'Neena','Kochhar','NKOCHHAR','515.123.4568',1989-09-21,'AD_VP',17000,null,100,90
102,'Lex','De Haan','LDEHAAN','515.123.4569',1993-01-13,'AD_VP',17000,null,100,90
103,'Alexander','Hunold','AHUNOLD','590.423.4567',1990-01-03,'IT_PROG',9000,null,102,60
104,'Bruce','Ernst','BERNST','590.423.4568',1991-05-21,'IT_PROG',6000,null,103,60
105,'David','Austin','DAUSTIN','590.423.4569',1997-06-25,'IT_PROG',4800,null,103,60
106,'Valli','Pataballa','VPATABAL','590.423.4560',1998-02-05,'IT_PROG',4800,null,103,60
107,'Diana','Lorentz','DLORENTZ','590.423.5567',1999-02-07,'IT_PROG',4200,null,103,60
108,'Nancy','Greenberg','NGREENBE','515.124.4569',1994-08-17,'FI_MGR',12000,null,101,100
109,'Daniel','Faviet','DFAVIET','515.124.4169',1994-08-16,'FI_ACCOUNT',9000,null,108,100
110,'John','Chen','JCHEN','515.124.4269',1997-09-28,'FI_ACCOUNT',8200,null,108,100
111,'Ismael','Sciarra','ISCIARRA','515.124.4369',1997-09-30,'FI_ACCOUNT',7700,null,108,100
112,'Jose Manuel','Urman','JMURMAN','515.124.4469',1998-03-07,'FI_ACCOUNT',7800,null,108,100
113,'Luis','Popp','LPOPP','515.124.4567',1999-12-07,'FI_ACCOUNT',6900,null,108,100
114,'Den','Raphaely','DRAPHEAL','515.127.4561',1994-12-07,'PU_MAN',11000,null,100,30
115,'Alexander','Khoo','AKHOO','515.127.4562',1995-05-18,'PU_CLERK',3100,null,114,30
116,'Shelli','Baida','SBAIDA','515.127.4563',1997-12-24,'PU_CLERK',2900,null,114,30
117,'Sigal','Tobias','STOBIAS','515.127.4564',1997-07-24,'PU_CLERK',2800,null,114,30
118,'Guy','Himuro','GHIMURO','515.127.4565',1998-NOV-15,'PU_CLERK',2600,null,114,30
119,'Karen','Colmenares','KCOLMENA','515.127.4566',1999-08-10,'PU_CLERK',2500,null,114,30
120,'Matthew','Weiss','MWEISS','650.123.1234',1996-07-18,'ST_MAN',8000,null,100,50
121,'Adam','Fripp','AFRIPP','650.123.2234',1997-04-10,'ST_MAN',8200,null,100,50
122,'Payam','Kaufling','PKAUFLIN','650.123.3234',1995-05-01,'ST_MAN',7900,null,100,50
123,'Shanta','Vollman','SVOLLMAN','650.123.4234',1997-OCT-10,'ST_MAN',6500,null,100,50
124,'Kevin','Mourgos','KMOURGOS','650.123.5234',1999-NOV-16,'ST_MAN',5800,null,100,50
125,'Julia','Nayer','JNAYER','650.124.1214',1997-07-16,'ST_CLERK',3200,null,120,50
126,'Irene','Mikkilineni','IMIKKILI','650.124.1224',1998-09-28,'ST_CLERK',2700,null,120,50
127,'James','Landry','JLANDRY','650.124.1334',1999-01-14,'ST_CLERK',2400,null,120,50
128,'Steven','Markle','SMARKLE','650.124.1434',2000-03-08,'ST_CLERK',2200,null,120,50
129,'Laura','Bissot','LBISSOT','650.124.5234',1997-08-20,'ST_CLERK',3300,null,121,50
130,'Mozhe','Atkinson','MATKINSO','650.124.6234',1997-OCT-30,'ST_CLERK',2800,null,121,50
131,'James','Marlow','JAMRLOW','650.124.7234',1997-02-16,'ST_CLERK',2500,null,121,50
132,'TJ','Olson','TJOLSON','650.124.8234',1999-04-10,'ST_CLERK',2100,null,121,50
133,'Jason','Mallin','JMALLIN','650.127.1934',1996-06-14,'ST_CLERK',3300,null,122,50
134,'Michael','Rogers','MROGERS','650.127.1834',1998-08-26,'ST_CLERK',2900,null,122,50
135,'Ki','Gee','KGEE','650.127.1734',1999-12-12,'ST_CLERK',2400,null,122,50
136,'Hazel','Philtanker','HPHILTAN','650.127.1634',2000-02-06,'ST_CLERK',2200,null,122,50
137,'Renske','Ladwig','RLADWIG','650.121.1234',1995-07-14,'ST_CLERK',3600,null,123,50
138,'Stephen','Stiles','SSTILES','650.121.2034',1997-OCT-26,'ST_CLERK',3200,null,123,50
139,'John','Seo','JSEO','650.121.2019',1998-02-12,'ST_CLERK',2700,null,123,50
140,'Joshua','Patel','JPATEL','650.121.1834',1998-04-06,'ST_CLERK',2500,null,123,50
141,'Trenna','Rajs','TRAJS','650.121.8009',1995-OCT-17,'ST_CLERK',3500,null,124,50
142,'Curtis','Davies','CDAVIES','650.121.2994',1997-01-29,'ST_CLERK',3100,null,124,50
143,'Randall','Matos','RMATOS','650.121.2874',1998-03-15,'ST_CLERK',2600,null,124,50
144,'Peter','Vargas','PVARGAS','650.121.2004',1998-07-09,'ST_CLERK',2500,null,124,50
145,'John','Russell','JRUSSEL','011.44.1344.429268',1996-OCT-01,'SA_MAN',14000,0.4,100,80
146,'Karen','Partners','KPARTNER','011.44.1344.467268',1997-01-05,'SA_MAN',13500,0.3,100,80
147,'Alberto','Errazuriz','AERRAZUR','011.44.1344.429278',1997-03-10,'SA_MAN',12000,0.3,100,80
148,'Gerald','Cambrault','GCAMBRAU','011.44.1344.619268',1999-OCT-15,'SA_MAN',11000,0.3,100,80
149,'Eleni','Zlotkey','EZLOTKEY','011.44.1344.429018',2000-01-29,'SA_MAN',10500,0.2,100,80
150,'Peter','Tucker','PTUCKER','011.44.1344.129268',1997-01-30,'SA_REP',10000,0.3,145,80
151,'David','Bernstein','DBERNSTE','011.44.1344.345268',1997-03-24,'SA_REP',9500,0.25,145,80
152,'Peter','Hall','PHALL','011.44.1344.478968',1997-08-20,'SA_REP',9000,0.25,145,80
153,'Christopher','Olsen','COLSEN','011.44.1344.498718',1998-03-30,'SA_REP',8000,0.2,145,80
154,'Nanette','Cambrault','NCAMBRAU','011.44.1344.987668',1998-12-09,'SA_REP',7500,0.2,145,80
155,'Oliver','Tuvault','OTUVAULT','011.44.1344.486508',1999-NOV-23,'SA_REP',7000,0.15,145,80
156,'Janette','King','JKING','011.44.1345.429268',1996-01-30,'SA_REP',10000,0.35,146,80
157,'Patrick','Sully','PSULLY','011.44.1345.929268',1996-03-04,'SA_REP',9500,0.35,146,80
158,'Allan','McEwen','AMCEWEN','011.44.1345.829268',1996-08-01,'SA_REP',9000,0.35,146,80
159,'Lindsey','Smith','LSMITH','011.44.1345.729268',1997-03-10,'SA_REP',8000,0.3,146,80
160,'Louise','Doran','LDORAN','011.44.1345.629268',1997-12-15,'SA_REP',7500,0.3,146,80
161,'Sarath','Sewall','SSEWALL','011.44.1345.529268',1998-NOV-03,'SA_REP',7000,0.25,146,80
162,'Clara','Vishney','CVISHNEY','011.44.1346.129268',1997-NOV-11,'SA_REP',10500,0.25,147,80
163,'Danielle','Greene','DGREENE','011.44.1346.229268',1999-03-19,'SA_REP',9500,0.15,147,80
164,'Mattea','Marvins','MMARVINS','011.44.1346.329268',2000-01-24,'SA_REP',7200,0.1,147,80
165,'David','Lee','DLEE','011.44.1346.529268',2000-02-23,'SA_REP',6800,0.1,147,80
166,'Sundar','Ande','SANDE','011.44.1346.629268',2000-03-24,'SA_REP',6400,0.1,147,80
167,'Amit','Banda','ABANDA','011.44.1346.729268',2000-04-21,'SA_REP',6200,0.1,147,80
168,'Lisa','Ozer','LOZER','011.44.1343.929268',1997-03-11,'SA_REP',11500,0.25,148,80
169,'Harrison','Bloom','HBLOOM','011.44.1343.829268',1998-03-23,'SA_REP',10000,0.2,148,80
170,'Tayler','Fox','TFOX','011.44.1343.729268',1998-01-24,'SA_REP',9600,0.2,148,80
171,'William','Smith','WSMITH','011.44.1343.629268',1999-02-23,'SA_REP',7400,0.15,148,80
172,'Elizabeth','Bates','EBATES','011.44.1343.529268',1999-03-24,'SA_REP',7300,0.15,148,80
173,'Sundita','Kumar','SKUMAR','011.44.1343.329268',2000-04-21,'SA_REP',6100,0.1,148,80
174,'Ellen','Abel','EABEL','011.44.1644.429267',1996-05-11,'SA_REP',11000,0.3,149,80
175,'Alyssa','Hutton','AHUTTON','011.44.1644.429266',1997-03-19,'SA_REP',8800,0.25,149,80
176,'Jonathon','Taylor','JTAYLOR','011.44.1644.429265','1998-03-24','SA_REP',8600,0.2,149,80
177,'Jack','Livingston','JLIVINGS','011.44.1644.429264','1998-04-23','SA_REP',8400,0.2,149,80
178,'Kimberely','Grant','KGRANT','011.44.1644.429263','1999-05-24','SA_REP',7000,0.15,149,null
179,'Charles','Johnson','CJOHNSON','011.44.1644.429262','2000-01-04','SA_REP',6200,0.1,149,80
180,'Winston','Taylor','WTAYLOR','650.507.9876',1998-01-24,'SH_CLERK',3200,null,120,50
181,'Jean','Fleaur','JFLEAUR','650.507.9877',1998-02-23,'SH_CLERK',3100,null,120,50
182,'Martha','Sullivan','MSULLIVA','650.507.9878',1999-06-21,'SH_CLERK',2500,null,120,50
183,'Girard','Geoni','GGEONI','650.507.9879',2000-02-03,'SH_CLERK',2800,null,120,50
184,'Nandita','Sarchand','NSARCHAN','650.509.1876',1996-01-27,'SH_CLERK',4200,null,121,50
185,'Alexis','Bull','ABULL','650.509.2876',1997-02-20,'SH_CLERK',4100,null,121,50
186,'Julia','Dellinger','JDELLING','650.509.3876',1998-06-24,'SH_CLERK',3400,null,121,50
187,'Anthony','Cabrio','ACABRIO','650.509.4876',1999-02-07,'SH_CLERK',3000,null,121,50
188,'Kelly','Chung','KCHUNG','650.505.1876',1997-06-14,'SH_CLERK',3800,null,122,50
189,'Jennifer','Dilly','JDILLY','650.505.2876',1997-08-13,'SH_CLERK',3600,null,122,50
190,'Timothy','Gates','TGATES','650.505.3876',1998-07-11,'SH_CLERK',2900,null,122,50
191,'Randall','Perkins','RPERKINS','650.505.4876',1999-12-19,'SH_CLERK',2500,null,122,50
192,'Sarah','Bell','SBELL','650.501.1876',1996-02-04,'SH_CLERK',4000,null,123,50
193,'Britney','Everett','BEVERETT','650.501.2876',1997-03-03,'SH_CLERK',3900,null,123,50
194,'Samuel','McCain','SMCCAIN','650.501.3876',1998-07-01,'SH_CLERK',3200,null,123,50
195,'Vance','Jones','VJONES','650.501.4876',1999-03-17,'SH_CLERK',2800,null,123,50
196,'Alana','Walsh','AWALSH','650.507.9811',1998-04-24,'SH_CLERK',3100,null,124,50
197,'Kevin','Feeney','KFEENEY','650.507.9822',1998-05-23,'SH_CLERK',3000,null,124,50
198,'Donald','OConnell','DOCONNEL','650.507.9833',99-06-21,'SH_CLERK',2600,null,124,50
199,'Douglas','Grant','DGRANT','650.507.9844',00-01-13,'SH_CLERK',2600,null,124,50
200,'Jennifer','Whalen','JWHALEN','515.123.4444',87-09-17,'AD_ASST',4400,null,101,10
201,'Michael','Hartstein','MHARTSTE','515.123.5555',1996-02-17,'MK_MAN',13000,null,100,20
202,'Pat','Fay','PFAY','603.123.6666',1997-08-17,'MK_REP',6000,null,201,20
203,'Susan','Mavris','SMAVRIS','515.123.7777',1994-06-07,'HR_REP',6500,null,101,40
204,'Hermann','Baer','HBAER','515.123.8888',1994-06-07,'PR_REP',10000,null,101,70
205,'Shelley','Higgins','SHIGGINS','515.123.8080',1994-06-07,'AC_MGR',12000,null,101,110
206,'William','Gietz','WGIETZ','515.123.8181',1994-06-07,'AC_ACCOUNT',8300,null,205,110
}

Jobs = {job_id:string, job_title:string, min_salary:number, max_salary:number
AD_PRES	President	20000	40000
AD_VP	'Administration Vice President'	15000	30000
AD_ASST	'Administration Assistant'	3000	6000
FI_MGR	'Finance Manager'	8200	16000
FI_ACCOUNT	Accountant	4200	9000
AC_MGR	'Accounting Manager'	8200	16000
AC_ACCOUNT	'Public Accountant'	4200	9000
SA_MAN	'Sales Manager'	10000	20000
SA_REP	'Sales Representative'	6000	12000
PU_MAN	'Purchasing Manager'	8000	15000
PU_CLERK	'Purchasing Clerk'	2500	5500
ST_MAN	'Stock Manager'	5500	8500
ST_CLERK	'Stock Clerk'	2000	5000
SH_CLERK	'Shipping Clerk'	2500	5500
IT_PROG	Programmer	4000	10000
MK_MAN	'Marketing Manager'	9000	15000
MK_REP	'Marketing Representative'	4000	9000
HR_REP	'Human Resources Representative'	4000	9000
PR_REP	'Public Relations Representative'	4500	10500
}

Departments = {department_id:number, department_name:string, manager_id:number, location_id:number
10	Administration	200	1700
20	Marketing	201	1800
30	Purchasing	114	1700
40	'Human Resources'	203	2400
50	Shipping	121	1500
60	IT	103	1400
70	'Public Relations'	204	2700
80	Sales	145	2500
90	Executive	100	1700
100	Finance	108	1700
110	Accounting	205	1700
120	Treasury null 1700
130	'Corporate Tax' null 1700
140	'Control And Credit' null 1700
150	'Shareholder Services' null 1700
160	Benefits null 1700
170	Manufacturing null 1700
180	Construction null 1700
190	Contracting null 1700
200	Operations null 1700
210	'IT Support' null 1700
220	NOC null 1700
230	'IT Helpdesk' null 1700
240	'Government Sales' null 1700
}

Countries = {country_id:string, country_name:string, region_id:number
AR	Argentina	2
AU	Australia	3
BE	Belgium	1
BR	Brazil	2
CA	Canada	2
CH	Switzerland	1
CN	China	3
DE	Germany	1
DK	Denmark	1
EG	Egypt	4
FR	France	1
HK	HongKong	3
HU	Hungary 1
IL	Israel	4
IN	India	3
IT	Italy	1
JP	Japan	3
KW	Kuwait	4
MX	Mexico	2
NG	Nigeria	4
NL	Netherlands	1
SG	Singapore	3
UK	'United Kingdom'	1
US	'United States of America'	2
ZM	Zambia	4
ZW	Zimbabwe	4
}

Regions = {region_id:number, region_name:string
1	Europe
2	Americas
3	Asia
4	'Middle East and Africa'
}

Locations = {location_id:number, street_address:string, postal_code:string, city:string, state_providence:string, country_id:string
1000	'1297 Via Cola di Rie'	00989	Roma	null	IT
1100	'93091 Calle della Testa'	10934	Venice	null	IT
1200	'2017 Shinjuku-ku'	1689	Tokyo	'Tokyo Prefecture'	JP
1300	'9450 Kamiya-cho'	6823	Hiroshima	null	JP
1400	'2014 Jabberwocky Rd'	26192	Southlake	Texas	US
1500	'2011 Interiors Blvd'	99236	'South San Francisco'	California	US
1600	'2007 Zagora St'	50090	'South Brunswick'	'New Jersey'	US
1700	'2004 Charade Rd'	98199	Seattle	Washington	US
1800	'147 Spadina Ave'	'M5V 2L7'	Toronto	Ontario	CA
1900	'6092 Boxwood St'	'YSW 9T2'	Whitehorse	Yukon	CA
2000	'40-5-12 Laogianggen'	190518	Beijing	null	CN
2100	'1298 Vileparle (E)'	490231	Bombay	Maharashtra	IN
2200	'12-98 Victoria Street'	2901	Sydney	'New South Wales'	AU
2300	'198 Clementi North'	540198	Singapore	null	SG
2400	'8204 Arthur St'	null	London	null	UK
2500	'Magdalen Centre, The Oxford Science Park'	'OX9 9ZB'	Oxford	Oxford	UK
2600	'9702 Chester Road'	09629850293	Stretford	Manchester	UK
2700	'Schwanthalerstr. 7031'	80925	Munich	Bavaria	DE
2800	'Rua Frei Caneca 1360'	01307-002	'Sao Paulo'	'Sao Paulo'	BR
2900	'20 Rue des Corps-Saints'	1730	Geneva	Geneve	CH
3000	'Murtenstrasse 921'	3095	Bern	BE	CH
3100	'Pieter Breughelstraat 837'	3029SK	Utrecht	Utrecht	NL
3200	'Mariano Escobedo 9991'	11932	'Mexico City'	'Distrito Federal'	MX
}