exam

db_exam

group: Exam
Branch = {
bcity, bcountry
'Moscu','Rusia'
'Berlin','Alemania'
'Paris','Francia'
'Roma','Italia'
'Bruselas','Belgica'
'Lyon','Francia'
'Hamburgo','Alemania'
'Lisboa','Portugal'
'Sevilla','Espanna'
'Barcelona','Espanna'
'Kiev','Ucrania'
'Estocolmo','Suecia'
'Madrid','Espanna'
'Milan','Italia'
'Amberes','Belgica'
'Atenas','Grecia'
}

Client = {
cname, ccity, ccountry
'Alphabet','Bucarest','Rumania'
'Amazon','Amsterdam','Paises Bajos'
'TSMC','Bruselas','Belgica'
'Visa','Praga','Republica Checa'
'Samsung','Estocolmo','Suecia'
'ICBC','Budapest','Hungria'
'Home Depot Inc','Minsk','Bielorrusia'
'Meituan','Viena','Austria'
'Roche','Berna','Suiza'
'Toyota','Sofia','Bulgaria'
'Exxon Mobil Corp','Belgrado','Serbia'
'Verizon','Copenhague','Dinamarca'
'Adobe','Helsinki','Finlandia'
'Nike','Oslo','Noruega'
'Coca-Cola','Londres','Reino Unido'
'Apple','Barcelona','Espanna'
'Mastercard','Berlin','Alemania'
'Novartis','Lisboa','Portugal'
'Chevron','Hamburgo','Alemania'
'Pepsico','Roma','Italia'
}



Product = {
sn, pname, unit, price
1,'Organizador','unidad',34
2,'Boligrafos','docena',10
3,'Lapices de grafito','docena',5
4,'Lapices de colores','docena',6
5,'Plumas','docena',8
6,'Rotuladores','docena',7
7,'Portalápices','unidad',15
8,'Libretas','caja',30
9,'Cuadernos','caja',25
10,'Papel','paquete500',14
11,'Pinzas','caja',18
12,'Clips','caja',17
13,'Portaclips','docena',15
14,'Goma de borrar','caja',32
15,'Calculadora','unidad',45
16,'Sellos','paquete500',24
17,'Agenda','docena',19
18,'Bloc de notas','caja',14
}

SalesPerson = {
eId, ename, bcity, bcountry
1,'Hugo','Moscu','Rusia'
2,'Liam','Sevilla','Espanna'
3,'Lucas','Atenas','Grecia'
4,'Martin','Berlin','Alemania'
5,'Pablo','Paris','Francia'
6,'Enzo','Lisboa','Portugal'
7,'Diego','Lisboa','Portugal'
8,'Marcos','Madrid','Espanna'
9,'Izan','Sevilla','Espanna'
10,'Javier','Amberes','Belgica'
11,'Bruno','Barcelona','Espanna'
12,'Thiago','Paris','Francia'
13,'Antonio','Hamburgo','Alemania'
14,'Carlos','Lyon','Francia'
15,'Marcos','Roma','Italia'
16,'David','Lyon','Francia'
17,'Juan','Roma','Italia'
18,'Carlos','Bruselas','Belgica'
19,'Gael','Bruselas','Belgica'
20,'Manuel','Roma','Italia'
21,'David','Estocolmo','Suecia'
22,'Diego','Milan','Italia'
23,'Iker','Kiev','Ucrania'
}

Sale = {
saleId, sn, cname, eId, date, numberUnit
1, 1,'Alphabet', 1, 2020-01-09, 10
2, 2,'Amazon', 2, 2021-02-09, 12
3, 3,'TSMC', 3, 2019-03-10, 9
4, 4,'Visa', 4, 2021-04-05, 24
5, 5,'Samsung', 5, 2020-05-09, 14
6, 6,'ICBC', 6, 2021-06-09, 20
7, 7,'Home Depot Inc', 7, 2019-07-10, 4
8, 8,'Chevron', 8, 2021-08-05, 19
9, 9,'Roche', 9, 2019-08-09, 20
10, 10,'Exxon Mobil Corp', 3, 2021-09-09, 30
11, 18,'Adobe', 10, 2019-10-10, 6
12, 1,'Nike', 13, 2021-12-05, 28
13, 2,'Coca-Cola', 11, 2020-11-09, 19
14, 3,'Apple', 12, 2021-12-09, 40
15, 4,'Novartis', 14, 2019-12-10, 23
16, 5,'Pepsico', 15, 2021-02-05, 47
17, 6,'Alphabet', 16, 2020-01-09, 29
18, 7,'Amazon', 17, 2021-03-09, 53
19, 8,'TSMC', 18, 2019-04-10, 21
20, 9,'Visa', 19, 2021-04-05, 16
21, 10,'Samsung', 20, 2020-05-09, 34
22, 12,'ICBC', 21, 2021-06-09, 56
23, 11,'Home Depot Inc', 22, 2019-07-10, 8
24, 17,'Chevron', 23, 2021-08-05, 4
25, 11,'Roche', 21, 2020-09-09, 23
26, 12,'Exxon Mobil Corp', 13, 2021-10-09, 54
27, 1,'Adobe', 11, 2019-11-10, 13
28, 2,'Nike', 2, 2021-12-05, 8
29, 3,'Coca-Cola', 4, 2020-04-09, 28
30, 4,'Apple', 3, 2021-02-09, 26
31, 5,'Novartis', 5, 2019-03-10, 15
32, 6,'Pepsico', 6, 2021-01-05, 18
33, 7,'Alphabet', 7, 2020-01-09, 36
34, 8,'Amazon', 8, 2021-02-09, 27
35, 9,'TSMC', 9, 2019-05-10, 20
36, 16,'Visa', 10, 2021-06-05, 37
37, 15,'Samsung', 11, 2020-09-09, 31
38, 3,'ICBC', 12, 2021-10-09, 18
39, 4,'Home Depot Inc', 21, 2019-08-10, 3
40, 5,'Chevron', 14, 2021-01-05, 72
41, 6,'Roche', 15, 2020-03-09, 19
42, 7,'Exxon Mobil Corp', 16, 2021-05-09, 28
43, 8,'Adobe', 17, 2019-01-10, 23
44, 9,'Nike', 18, 2021-02-05, 15
45, 10,'Coca-Cola', 19, 2020-03-09, 19
46, 12,'Apple', 23, 2021-09-09, 7
47, 11,'Novartis', 21, 2019-04-10, 24
48, 13,'Pepsico', 20, 2021-02-05, 32
49, 14,'Alphabet', 11, 2020-08-09, 46
50, 15,'Amazon', 2, 2021-07-09, 27
51, 16,'TSMC', 5, 2019-04-10, 11
52, 1,'Visa', 7, 2021-02-05, 12
53, 1,'Samsung', 8, 2020-08-09, 10
54, 2,'ICBC', 13, 2021-07-09, 25
55, 3,'Home Depot Inc', 2, 2019-04-10, 46
56, 4,'Chevron', 8, 2021-02-05, 58
57, 5,'Roche', 9, 2020-08-09, 25
58, 6,'Exxon Mobil Corp', 10, 2021-07-09, 76
59, 7,'Adobe', 18, 2019-04-10, 25
60, 10,'Nike', 19, 2021-02-05, 11
61, 11,'Coca-Cola', 21, 2020-08-09, 2
62, 12,'Apple', 4, 2021-07-09, 1
63, 1,'Novartis', 6, 2019-04-10, 26
64, 12,'Pepsico', 7, 2021-02-05, 34
}