exam

db_exam2

group: ExamII
Tank = {
tname, capacity, numberSpecies
 'Tank1', 300, 40 
 'Tank2', 500, 90 
 'Tank3', 800, 80 
 'Tank4', 900, 50 
 'Tank5', 1200, 30  
 'Tank6', 2200, 140 
 'Tank7', 700, 90 
 'Tank8', 1000, 10 
 'Tank9', 1300, 20 
 'Tank10', 2300, 70 
}

Creature = {
sn, weight, length, sex, species, tname
 1, 10, 2000, TRUE, 'Bowhead whale', 'Tank6' 
 2, 15, 1000, TRUE, 'California sea lion', 'Tank1' 
 3, 20, 2000, FALSE, 'Fin whale', 'Tank2' 
 4, 25, 1000, FALSE, 'Guadalupe fur seal', 'Tank1' 
 5, 13, 2000, TRUE, 'Killer whale', 'Tank3' 
 6, 5, 1000, TRUE, 'Manatee', 'Tank4' 
 7, 50, 2000, TRUE, 'Northern elephant seal', 'Tank5' 
 8, 65, 1000, FALSE, 'Northern fur seal', 'Tank6' 
 9, 20, 2000, TRUE, 'Pacific harbor seal', 'Tank6' 
 10, 35, 1000, TRUE, 'Sea otter', 'Tank7' 
 11, 40, 2000, FALSE, 'Northern shrimp', 'Tank8' 
 12, 15, 1000, TRUE, 'Dungeness crab', 'Tank9' 
 13, 10, 2000, FALSE, 'Golden king crab', 'Tank10' 
 14, 15, 1000, FALSE, 'Red king crab', 'Tank10' 
 15, 10, 2000, TRUE, 'Arctic cod', 'Tank2' 
 16, 15, 1000, FALSE, 'Arrowtooth flounder', 'Tank3' 
 17, 20, 2000, TRUE, 'Atka mackerel', 'Tank4' 
 18, 35, 1000, TRUE, 'Black rockfish', 'Tank5' 
 19, 40, 2000, TRUE, 'Blue rockfish', 'Tank6' 
 20, 55, 1000, TRUE, 'Capelin', 'Tank7' 
 21, 60, 2000, FALSE, 'Chinook salmon', 'Tank2' 
 22, 75, 1000, FALSE, 'Chum salmon', 'Tank2' 
 23, 80, 2000, TRUE, 'Coho salmon', 'Tank3' 
 24, 9, 1000, FALSE, 'Greenland halibut', 'Tank8' 
 25, 16, 2000, TRUE, 'Lingcod', 'Tank4' 
 26, 18, 1000, FALSE, 'Pacific cod', 'Tank9' 
 27, 40, 2000, TRUE, 'Pacific halibut', 'Tank5' 
 28, 35, 1000, TRUE, 'Pacific herring', 'Tank10' 
 29, 10, 2000, TRUE, 'Pacific ocean perch', 'Tank2' 
 30, 15, 1000, FALSE, 'Yellowfin sole', 'Tank3' 
 31, 20, 2000, TRUE, 'Walleye pollock', 'Tank4' 
 32, 35, 1000, TRUE, 'Yellowfin sole', 'Tank5' 
 33, 40, 2000, TRUE, 'Walleye pollock', 'Tank6' 
 34, 55, 1000, TRUE, 'Yellowfin sole', 'Tank7' 
 35, 60, 2000, FALSE, 'Sockeye salmon', 'Tank2' 
 36, 75, 1000, FALSE, 'Salmon shark', 'Tank2' 
 37, 80, 2000, TRUE, 'Sablefish', 'Tank3' 
 38, 9, 1000, FALSE, 'Rock sole', 'Tank8' 
 39, 16, 2000, TRUE, 'Pink salmon', 'Tank4' 
 40, 18, 1000, FALSE, 'Pacific sleeper shark', 'Tank9' 
 41, 40, 2000, TRUE, 'Pacific sandfish', 'Tank5' 
 42, 35, 1000, TRUE, 'Pacific sand lance', 'Tank10' 
 43, 10, 2000, TRUE, 'Bowhead whale', 'Tank10' 
 44, 15, 1000, TRUE, 'California sea lion', 'Tank9' 
 45, 20, 2000, FALSE, 'Fin whale', 'Tank8' 
 46, 25, 1000, FALSE, 'Guadalupe fur seal', 'Tank2' 
 47, 13, 2000, TRUE, 'Killer whale', 'Tank7' 
 48, 5, 1000, TRUE, 'Manatee', 'Tank3' 
 49, 50, 2000, TRUE, 'Northern elephant seal', 'Tank4' 
 50, 65, 1000, FALSE, 'Northern fur seal', 'Tank1' 
 51, 20, 2000, TRUE, 'Pacific harbor seal', 'Tank2' 
 52, 35, 1000, TRUE, 'Sea otter', 'Tank5' 
 53, 40, 2000, FALSE, 'Northern shrimp', 'Tank3' 
 54, 15, 1000, TRUE, 'Dungeness crab', 'Tank10' 
 55, 10, 2000, FALSE, 'Golden king crab', 'Tank9' 
 56, 15, 1000, FALSE, 'Red king crab', 'Tank9' 
 57, 10, 2000, TRUE, 'Arctic cod', 'Tank3' 
 58, 15, 1000, FALSE, 'Arrowtooth flounder', 'Tank1' 
 59, 20, 2000, TRUE, 'Atka mackerel', 'Tank2' 
 60, 35, 1000, TRUE, 'Black rockfish', 'Tank4' 
 61, 40, 2000, TRUE, 'Blue rockfish', 'Tank7' 
 62, 55, 1000, TRUE, 'Capelin', 'Tank5' 
 63, 60, 2000, FALSE, 'Chinook salmon', 'Tank3' 
 64, 75, 1000, FALSE, 'Chum salmon', 'Tank1' 
 65, 80, 2000, TRUE, 'Coho salmon', 'Tank6' 
 66, 9, 1000, FALSE, 'Greenland halibut', 'Tank7' 
 67, 16, 2000, TRUE, 'Lingcod', 'Tank3' 
 68, 18, 1000, FALSE, 'Pacific cod', 'Tank10' 
 69, 40, 2000, TRUE, 'Pacific halibut', 'Tank10' 
 70, 35, 1000, TRUE, 'Pacific herring', 'Tank9' 
 71, 10, 2000, TRUE, 'Pacific ocean perch', 'Tank1' 
 72, 15, 1000, FALSE, 'Yellowfin sole', 'Tank2' 
 73, 20, 2000, TRUE, 'Walleye pollock', 'Tank3' 
 74, 35, 1000, TRUE, 'Yellowfin sole', 'Tank4' 
 75, 40, 2000, TRUE, 'Walleye pollock', 'Tank5' 
 76, 55, 1000, TRUE, 'Yellowfin sole', 'Tank6' 
 77, 60, 2000, FALSE, 'Sockeye salmon', 'Tank3' 
 78, 75, 1000, FALSE, 'Salmon shark', 'Tank1' 
 79, 80, 2000, TRUE, 'Sablefish', 'Tank4' 
 80, 9, 1000, FALSE, 'Rock sole', 'Tank7' 
 81, 16, 2000, TRUE, 'Pink salmon', 'Tank3' 
 82, 18, 1000, FALSE, 'Pacific sleeper shark', 'Tank8' 
 83, 40, 2000, TRUE, 'Pacific sandfish', 'Tank6' 
 84, 35, 1000, TRUE, 'Pacific sand lance', 'Tank1' 
}



Aquarist = {
eId, name, category, tname
 1,'Hugo','Cat1','Tank1' 
 2,'Liam','Cat2','Tank2' 
 3,'Lucas','Cat3','Tank3' 
 4,'Martin','Cat4','Tank4' 
 5,'Pablo','Cat5','Tank5' 
 6,'Enzo','Cat1','Tank6' 
 7,'Diego','Cat2','Tank7' 
 8,'Marcos','Cat3','Tank8' 
 9,'Izan','Cat4','Tank9' 
 10,'Javier','Cat5','Tank10' 
 11,'Bruno','Cat2','Tank1' 
 12,'Thiago','Cat3','Tank2' 
 13,'Antonio','Cat4','Tank3' 
 14,'Carlos','Cat5','Tank4' 
 15,'Marcos','Cat1','Tank5' 
 16,'David','Cat1','Tank6' 
 17,'Juan','Cat2','Tank7' 
 18,'Carlos','Cat3','Tank8' 
 19,'Gael','Cat4','Tank9' 
 20,'Manuel','Cat5','Tank10' 
 21,'David','Cat2','Tank1' 
 22,'Diego','Cat4','Tank2' 
 23,'Iker','Cat3','Tank3' 
}

PredatorPrey = {
predatorSpecie, preySpecie, minCapacity
 'Killer whale','Northern elephant seal',1340 
 'Killer whale','Sea otter',2010 
 'Killer whale','Arctic cod',840 
 'Killer whale','Pacific harbor seals',1000 
 'Killer whale','Northern fur seal',1600 
 'Salmon shark','Pacific cod',900 
 'Salmon shark','Arctic cod',260 
 'Salmon shark','Lingcod',500 
}

FeedingHistory = {
sn, eId, date ,food , amount
 1, 1,'2020/01/09','Fish flakes',10 
 2, 2, '2021-02-09', 'Fish pellets', 2 
 3, 3, '2019-03-10','Tablets for fish', 9 
 4, 4,'2021-04-05', 'Fish sticks',  24 
 5, 5,'2020-05-09', 'Fish wafers', 14 
 6, 6,'2021-01-09', 'Fish chips', 20 
 1, 7,'2020-02-09','Fish flakes',7 
 2, 8, '2021-03-09', 'Fish pellets', 12 
 3, 9, '2019-04-10','Tablets for fish', 6 
 4, 10,'2021-05-05', 'Fish sticks',  23 
 5, 11,'2020-06-09', 'Fish wafers', 16 
 6, 6,'2021-07-09', 'Fish chips', 10 
 1, 11,'2020-08-09','Fish flakes',10 
 2, 12, '2021-09-09', 'Fish pellets', 2 
 3, 13, '2019-10-10','Tablets for fish', 9 
 4, 14,'2021-11-05', 'Fish sticks',  24 
 5, 15,'2020-12-09', 'Fish wafers', 14 
 6, 16,'2021-12-09', 'Fish chips', 20 
 1, 17,'2020-01-09','Fish flakes',7 
 2, 18, '2021-02-09', 'Fish pellets', 12 
 3, 19, '2019-03-10','Tablets for fish', 6 
 4, 20,'2021-04-05', 'Fish sticks',  23 
 5, 21,'2020-05-09', 'Fish wafers', 16 
 6, 22,'2021-06-09', 'Fish chips', 10 
 21, 1,'2020-07-09','Fish flakes',10 
 22, 2, '2021-08-09', 'Fish pellets', 2 
 23, 3, '2019-09-10','Tablets for fish', 9 
 24, 4,'2021-10-05', 'Fish sticks',  24 
 25, 5,'2020-11-09', 'Fish wafers', 14 
 26, 6,'2021-12-09', 'Fish chips', 20 
 21, 7,'2020-12-01','Fish flakes',7 
 22, 8, '2021-02-02', 'Fish pellets', 12 
 23, 9, '2019-03-11','Tablets for fish', 6 
 24, 10,'2021-04-05', 'Fish sticks',  23 
 25, 11,'2020-05-09', 'Fish wafers', 16 
 26, 6,'2021-06-09', 'Fish chips', 10 
 21, 11,'2020-01-09','Fish flakes',10 
 23, 12, '2021-02-09', 'Fish pellets', 2 
 23, 13, '2019-03-10','Tablets for fish', 9 
 24, 14,'2021-04-05', 'Fish sticks',  24 
 25, 15,'2020-05-09', 'Fish wafers', 14 
 26, 16,'2021-06-09', 'Fish chips', 20 
 31, 17,'2020-01-09','Fish flakes',7 
 32, 18, '2021-02-09', 'Fish pellets', 12 
 33, 19, '2019-03-10','Tablets for fish', 6 
 34, 20,'2021-04-05', 'Fish sticks',  23 
 35, 21,'2020-05-09', 'Fish wafers', 16 
 36, 22,'2021-07-09', 'Fish chips', 10 
 31, 1,'2020-08-09','Fish flakes',10 
 42, 2, '2021-09-09', 'Fish pellets', 2 
 43, 3, '2019-10-10','Tablets for fish', 9 
 44, 4,'2021-11-05', 'Fish sticks',  24 
 45, 5,'2020-12-09', 'Fish wafers', 14 
 46, 6,'2021-01-09', 'Fish chips', 20 
 47, 7,'2020-02-09','Fish flakes',7 
 48, 8, '2021-03-09', 'Fish pellets', 12 
 49, 9, '2019-04-10','Tablets for fish', 6 
 50, 10,'2021-05-05', 'Fish sticks',  23 
 51, 11,'2020-06-09', 'Fish wafers', 16 
 52, 6,'2021-06-09', 'Fish chips', 10 
 53, 11,'2020-01-09','Fish flakes',10
 54, 12, '2021-02-09', 'Fish pellets', 2 
 55, 13, '2019-03-10','Tablets for fish', 9 
 56, 14,'2021-04-05', 'Fish sticks',  24 
 57, 15,'2020-05-09', 'Fish wafers', 14 
 58, 16,'2021-06-09', 'Fish chips', 20 
 59, 17,'2020-01-09','Fish flakes',7
 60, 18, '2021-02-09', 'Fish pellets', 12 
 61, 19, '2019-03-10','Tablets for fish', 6 
 62, 20,'2021-04-05', 'Fish sticks',  23 
 63, 21,'2020-07-09', 'Fish wafers', 16 
 64, 22,'2021-08-09', 'Fish chips', 10 
 65, 1,'2020-09-09','Fish flakes',10 
 66, 2, '2021-01-09', 'Fish pellets', 2 
 67, 3, '2019-12-10','Tablets for fish', 9 
 78, 4,'2021-11-05', 'Fish sticks',  24 
 68, 5,'2020-10-09', 'Fish wafers', 14 
 69, 6,'2021-09-09', 'Fish chips', 20 
 70, 7,'2020-08-09','Fish flakes',7 
 71, 8, '2021-07-09', 'Fish pellets', 12 
 72, 9, '2019-06-10','Tablets for fish', 6 
 73, 10,'2021-05-05', 'Fish sticks',  23 
 74, 11,'2020-04-09', 'Fish wafers', 16 
 75, 6,'2021-03-09', 'Fish chips', 10 
 76, 11,'2020-02-09','Fish flakes',10 
 77, 12, '2021-01-09', 'Fish pellets', 2 
 78, 13, '2019-12-10','Tablets for fish', 9 
 79, 14,'2021-11-05', 'Fish sticks',  24 
 80, 15,'2020-10-09', 'Fish wafers', 14 
 81, 16,'2021-09-09', 'Fish chips', 20 
 32, 17,'2020-02-09','Fish flakes',7 
 34, 18, '2021-03-09', 'Fish pellets', 12 
 35, 19, '2019-04-10','Tablets for fish', 6 
 36, 20,'2021-06-05', 'Fish sticks',  23 
 37, 21,'2020-08-09', 'Fish wafers', 16 
 38, 22,'2021-07-09', 'Fish chips', 10 
}