Zoo_BD_EX2

INSERT Animals (Spicie, Family, Sex, Name) VALUES
('Ornithorhynchus anatinus',N'Ornithorhynchidae',N'male',N'Qwa'),
('Ornithorhynchus anatinus',N'Ornithorhynchidae',N'female',N'Qwary'),
('Ornithorhynchus anatinus',N'Ornithorhynchidae',N'male',N'Qwaqwa'),
('Ornithorhynchus anatinus',N'Ornithorhynchidae',N'male',N'Qwaawq'),
('Ornithorhynchus anatinus',N'Ornithorhynchidae',N'female',N'Swa'),
('Panthera leo',N'Felidae',N'male',N'Swarmy'),
('Panthera leo',N'Felidae',N'female',N'Marma'),
('Panthera leo',N'Felidae',N'female',N'Cowarma'),
('Panthera leo',N'Felidae',N'female',N'Sarma'),
('Panthera leo',N'Felidae',N'female',N'Harva'),
('Panthera tigris',N'Felidae',N'male',N'Pity'),
('Panthera tigris',N'Felidae',N'male',N'Crawdy'),
('Panthera tigris',N'Felidae',N'female',N'Party'),
('Panthera tigris',N'Felidae',N'male',N'Army'),
('Panthera tigris',N'Felidae',N'female',N'Wastry'),
('Zaglossus bartoni',N'Tachyglossidae',N'female',N'Lala'),
('Zaglossus bartoni',N'Tachyglossidae',N'female',N'Lora'),
('Zaglossus bartoni',N'Tachyglossidae',N'female',N'Cola'),
('Zaglossus bartoni',N'Tachyglossidae',N'male',N'Lantor'),
('Zaglossus bartoni',N'Tachyglossidae',N'male',N'Cwantor'),
('Giraffa camelopardalis',N'Giraffidae',N'male',N'Sop'),
('Giraffa camelopardalis',N'Giraffidae',N'female',N'Copa'),
('Giraffa camelopardalis',N'Giraffidae',N'male',N'Lop'),
('Giraffa camelopardalis',N'Giraffidae',N'female',N'Pola'),
('Giraffa camelopardalis',N'Giraffidae',N'male',N'Warn'),
('Ommatotriton ophryticus',N'Salamandridae',N'male',N'Cotty'),
('Ommatotriton ophryticus',N'Salamandridae',N'female',N'Procotty'),
('Ommatotriton ophryticus',N'Salamandridae',N'female',N'Segotty'),
('Ommatotriton ophryticus',N'Salamandridae',N'male',N'Smatty'),
('Ommatotriton ophryticus',N'Salamandridae',N'male',N'Harty'),
('Falco peregrinus',N'Falconidae',N'male',N'Dart'),
('Falco peregrinus',N'Falconidae',N'male',N'Hume'),
('Falco peregrinus',N'Falconidae',N'female',N'Misma'),
('Falco peregrinus',N'Falconidae',N'female',N'Misella'),
('Falco peregrinus',N'Falconidae',N'female',N'Jisella'),
('Chimaera monstrosa',N'Chimaeridae',N'male',N'Poppy'),
('Chimaera monstrosa',N'Chimaeridae',N'female',N'Snoppy'),
('Chimaera monstrosa',N'Chimaeridae',N'female',N'Cooppy'),
('Chimaera monstrosa',N'Chimaeridae',N'female',N'Wooppy'),
('Chimaera monstrosa',N'Chimaeridae',N'male',N'Crooppy'),
('Dendrortyx leucophrys',N'Odontophoridae',N'female',N'Sally'),
('Dendrortyx leucophrys',N'Odontophoridae',N'male',N'Bobby'),
('Dendrortyx leucophrys',N'Odontophoridae',N'female',N'Cally'),
('Dendrortyx leucophrys',N'Odontophoridae',N'female',N'Pally'),
('Dendrortyx leucophrys',N'Odontophoridae',N'female',N'Crally')

INSERT Volonteers (NUMBER, Zone) VALUES
('Ivanova',N'Anna',N'89032100',N'[email protected]'),
('Sidorov',N'Ivan',N'89211212',N'[email protected]'),
('Larikova',N'Maria',N'83120432',N'[email protected]'),
('Kirillova',N'Olga',N'09284145',N'[email protected]'),
('Maglov',N'Ilya',N'12345678',N'[email protected]'),
('Petrov',N'Daniil',N'76543287',N'[email protected]'),
('Kireeva',N'Nadya',N'12849201',N'[email protected]'),
('Lastov',N'Pavel',N'89237132',N'[email protected]'),
('Kav',N'Il',N'22222232',N'[email protected]')

INSERT Paddocks(NUMBER, Zone) VALUES
(1,2),
(2,1),
(3,1),
(4,2),
(5,1),
(6,3),
(7,4),
(8,5),
(9,3)