--
-- departments
--
INSERT INTO departments VALUES('research', 45, 453, 27);
INSERT INTO departments VALUES('marketing', 73, 89, 11);
INSERT INTO departments VALUES('production', 54, 1245, 11);
INSERT INTO departments VALUES('finance', 24, 24, 27);
INSERT INTO departments VALUES('workshop', 62, 7, 11);


--
-- employees
--
INSERT INTO employees VALUES(12, 'jean', 'accountant');
INSERT INTO employees VALUES(7, 'lila', 'artist');
INSERT INTO employees VALUES(27, 'philippe', 'it');
INSERT INTO employees VALUES(28, 'albert', 'management');
INSERT INTO employees VALUES(11, 'pascal', 'it');
INSERT INTO employees VALUES(8, 'patrick', 'marketing');
INSERT INTO employees VALUES(32, 'gwendoline', 'management');
INSERT INTO employees VALUES(3, 'patrick', 'support');


--
-- assignments
--
INSERT INTO assignments VALUES('research', 28, 'albert', 1996);
INSERT INTO assignments VALUES('marketing', 8, 'patrick', 2005);
INSERT INTO assignments VALUES('production', 7, 'lila', 2008);
INSERT INTO assignments VALUES('research', 27, 'philippe', 1996);
INSERT INTO assignments VALUES('research', 11, 'pascal', 1999);
INSERT INTO assignments VALUES('finance', 12, 'jean', 2014);
INSERT INTO assignments VALUES('production', 32, 'gwendoline', 2019);
INSERT INTO assignments VALUES('production', 3, 'patrick', 2008);


--
-- computers
--
INSERT INTO computers VALUES('research', 1, 'linux', 28);
INSERT INTO computers VALUES('research', 2, 'linux', 27);
INSERT INTO computers VALUES('research', 3, 'windows', 27);
INSERT INTO computers VALUES('research', 4, 'linux', 11);
INSERT INTO computers VALUES('marketing', 1, 'windows', 8);
INSERT INTO computers VALUES('finance', 1, 'windows', 12);
INSERT INTO computers VALUES('production', 1, 'macOs', 7);
INSERT INTO computers VALUES('production', 2, 'macOs', 32);
INSERT INTO computers VALUES('production', 3, 'windows', 3);
INSERT INTO computers VALUES('workshop', 1, 'macOs', 11);
INSERT INTO computers VALUES('workshop', 2, 'windows', 11);
INSERT INTO computers VALUES('workshop', 3, 'windows', 11);

