s.execute("insert into four values (2, 1, 1, 1, 1)");
s.execute("insert into four values (2, 1, 2, 1, 1)");
s.execute("insert into four values (2, 1, 3, 1, 1)");
s.execute("insert into four values (3, 1, 1, 1, 1)");
s.execute("insert into four values (3, 1, 2, 1, 1)");
s.execute("insert into four values (3, 1, 3, 1, 1)");
s.execute("insert into idept values ('Dept', 1, 'Department1', null, null, null, null)");
s.execute("insert into idept values ('HardwareDept', 2, 'Department2', 25, 1, 'hardwareaset2', null)");
s.execute("insert into idept values ('HardwareDept', 3, 'Department3', 25, 2, 'hardwareaset3', null)");
s.execute("insert into idept values ('SoftwareDept', 4, 'Department4', 25, 1, null, 'softwareasset4')");