LogicalModel: data_load1.sql

SET search_path TO project;

-- University
INSERT INTO University (Name, Location, IsPrivate) VALUES
('University of Skopje', 'Skopje', FALSE),
('Private Tech University', 'Bitola', TRUE);

-- Faculty
INSERT INTO Faculty (Name, Location, Study_field, University_Id) VALUES
('Faculty of Computer Science', 'Skopje', 'Computer Science', 1),
('Faculty of Economics', 'Skopje', 'Economics', 1),
('Faculty of Engineering', 'Bitola', 'Engineering', 2);

-- Professor
INSERT INTO Professor (Name, Surname, Age, Address, Faculty_Id) VALUES
('Ivan', 'Petrov', 45, 'Skopje', 1),
('Ana', 'Markoska', 38, 'Skopje', 2),
('Boris', 'Stojanov', 50, 'Bitola', 3);

-- Student
INSERT INTO Student (Name, Surname, Location, Index, Faculty_Id, Adviser_Id) VALUES
('Elena', 'Georgieva', 'Skopje', 12345, 1, 1),
('Marko', 'Trajkov', 'Skopje', 12346, 2, 2),
('Petar', 'Ivanov', 'Bitola', 12347, 3, 3);

-- Subject
INSERT INTO Subject (Name, Semester, Credits, Faculty_Id, Professor_Id) VALUES
('Databases', 'Fall', 6, 1, 1),
('Economics 101', 'Spring', 5, 2, 2),
('Engineering Basics', 'Fall', 4, 3, 3);

-- Student_Subject
INSERT INTO Student_Subject (Student_Id, Subject_Id, Final_Grade, Status, Enrollment_Date, Absence_Count) VALUES
(1, 1, 10, 'Completed', '2026-01-10', 0),
(2, 2, 9, 'Completed', '2026-01-12', 2),
(3, 3, NULL, 'Enrolled', '2026-01-15', 0);