--Script Name: Q1 - Insert data
--Dev Name:MR Adams
--Date: 24 Nov 2024
--Description:Insert Data into tables
INSERT INTO FOODMANUFACTURER (companyName, contactNumber, email)
VALUES
('Veggie Land', '123-456-7890', 'veggieland@[Link]'),
('Premier Seed Suppliers', '987-654-3210', 'premierseeds@[Link]'),
('Pet Grains Ltd.', '555-123-9876', 'grains@[Link]'),
('NutriPet Co.', '111-222-3333', 'nutripet@[Link]'),
('Feather Foods', '444-555-6666', 'featherfoods@[Link]'),
('Critter Snacks', '777-888-9999', 'critter@[Link]'),
('PawCare Suppliers', '321-654-0987', NULL),
('Happy Pets Foods', '567-890-1234', 'happypets@[Link]'),
('WildLife Grains', '876-543-2109', NULL),
('Green Feed Co.', '999-888-7777', 'greenfeed@[Link]');
Go
INSERT INTO CATEGORY (categoryName)
VALUES
('Mammals'),
('Birds'),
('Reptiles'),
('Fish'),
('Amphibians'),
('Insects'),
('Rodents'),
('Large Animals'),
('Small Animals'),
('Exotic Animals');
Go
INSERT INTO FOODTYPE (foodName, foodExpiryDate, foodDescription, measurement,
companyID)
VALUES
('Vegetables', '2025-01-01', 'Fresh vegetables for pets', 'kg', 1),
('Seeds', '2024-12-31', 'High-quality seeds for birds', 'kg', 2),
('Fish Food', '2025-06-01', 'Flakes for fish', 'g', 4),
('Reptile Mix', '2025-08-15', 'Special mix for reptiles', 'kg', 3),
('Amphibian Snacks', '2025-03-20', 'Healthy snacks for amphibians', 'g', 5),
('Insect Food', '2026-01-30', 'Protein-rich feed for insects', 'kg', 6),
('Dog Kibble', '2025-10-10', 'Dry kibble for dogs', 'kg', 7),
('Cat Treats', '2025-11-11', 'Crunchy treats for cats', 'g', 8),
('Bird Pellets', '2024-12-01', 'Balanced pellets for birds', 'kg', 9),
('Rabbit Hay', '2026-02-01', 'Nutritious hay for rabbits', 'kg', 10);
Go
INSERT INTO PETTYPE (totalInStock, categoryID)
VALUES
(12, 1), -- Dogs (Mammals)
(18, 1), -- Cats (Mammals)
(40, 2), -- Parrots (Birds)
(15, 2), -- Canaries (Birds)
(20, 3), -- Turtles (Reptiles)
(10, 4), -- Goldfish (Fish)
(8, 5), -- Frogs (Amphibians)
(30, 6), -- Crickets (Insects)
(25, 7), -- Hamsters (Rodents)
(5, 10); -- Iguanas (Exotic Animals)
Go
INSERT INTO ALLOCATEDQUANTITY (allocatedAmount, foodID, categoryID)
VALUES
(8.5, 1, 1), -- Vegetables for Mammals
(4.0, 2, 2), -- Seeds for Birds
(1.5, 3, 4), -- Fish Food for Fish
(2.0, 4, 3), -- Reptile Mix for Reptiles
(1.2, 5, 5), -- Amphibian Snacks for Amphibians
(0.8, 6, 6), -- Insect Food for Insects
(12.0, 7, 1), -- Dog Kibble for Mammals
(6.0, 8, 1), -- Cat Treats for Mammals
(3.5, 9, 2), -- Bird Pellets for Birds
(7.0, 10, 7); -- Rabbit Hay for Rodents