RelationalDesign: polnenje.sql

INSERT INTO Clenovi (Ime, Prezime, Telefon, Email, Adresa, Datum_rajganje) 
VALUES 
('Ivan', 'Petrov', '071123456', 'ivan.petrov@example.com', 'Skopje, Macedonia', '1990-05-15'),
('Ana', 'Kostova', '070987654', 'ana.kostova@example.com', 'Bitola, Macedonia', '1995-09-22'),
('Marko', 'Stojanovski', '078112233', 'marko.stojanovski@example.com', 'Ohrid, Macedonia', '1988-01-10');
INSERT INTO Paketi (Naziv, Cena, Validnost, Vremetraenje) 
VALUES 
('Basic', 1200.00, '1 month', '30 days'),
('Standard', 2500.00, '3 months', '90 days'),
('Premium', 6000.00, '12 months', '365 days');
INSERT INTO Clenstvo (Validnost, Od, DoDat, ClenIdFK, PaketiFK) 
VALUES 
('Active', '2024-01-01', '2024-02-01', 1, 1),
('Expired', '2023-06-01', '2023-09-01', 2, 2),
('Active', '2024-01-01', '2024-12-31', 3, 3);
INSERT INTO Lokacii (Adresa, Telefon) 
VALUES 
('Boulevard Partizanski Odredi, Skopje', '023456789'),
('Marsal Tito Street, Bitola', '047223344'),
('Kaneo Area, Ohrid', '046334455');
INSERT INTO Poseti (CheckInTime, ClenIdFK, LokacijaIdFK) 
VALUES 
('2024-01-15 09:30:00', 1, 1),
('2024-01-16 14:00:00', 2, 2),
('2024-01-17 18:45:00', 3, 3);
INSERT INTO Vraboteni (LokacijaIdFK, Ime, Prezime, Telefon, Email, Uloga, Plata, Raboti) 
VALUES 
(1, 'Maja', 'Ilievska', '070555123', 'maja.ilievska@example.com', 'Trainer', 35000.00, 'Fitness Center'),
(2, 'Dimitar', 'Todorovski', '078999456', 'dimitar.todorovski@example.com', 'Receptionist', 25000.00, 'Membership Desk'),
(3, 'Elena', 'Ristova', '071222789', 'elena.ristova@example.com', 'Manager', 50000.00, 'Management Office');
INSERT INTO Trenira (ClenstvoId, VrabotenId) 
VALUES 
(1, 1),
(2, 2),
(3, 3);