insert into subjects (subjectName, dateIntroduced)
values
('Databases', '1989-01-01'),
('Semiconductor materials', '1975-01-01'),
('Design and analysis of algorithms', '2001-01-01'),
('Digital Signal Processing', '1999-01-01');

insert into exams (examName, dateHeld, semester, averageGrade, subject_id)
values
('Databases 2nd exam', '2018-05-19T08:00:00', 'summer', 6.00, 1),
('Semiconductors final', '2017-11-21T14:30:00', 'winter', 3.75, 2),
('Algorithms', '2018-06-06T11:30:00', 'summer', 4.60, 3),
('Amplitude Modulation', '2018-06-01T09:00:00', 'summer', 3.60, 4),
('Databases 1st exam', '2018-03-20T14:00:00', 'summer', 5.00, 1);