insert into users (username, pw, job, college, department, address, phone, cc_number, cc_date) values
("ruben", "pass", "estudante", "fctuc", "dei", "daqui", 91893737, 123123, DATE '2010-2-10'),
 ("ze", "pass", "estudante", "fluc", "deec", "daqui", 91893737, 123123, DATE '2010-2-10'),
 ("toino", "pass", "estudante", "fctuc", "deec", "daqui", 91893737, 123123, DATE '2010-2-10'),
 ("alfredo", "pass", "funcionario", "fctuc", "dei", "daqui", 91893737, 123123, DATE '2010-2-10'),
 ("miguel", "pass", "funcionario", "fluc", "dei", "daqui", 91893737, 123123, DATE '2010-2-10'),
 ("fabio", "pass", "funcionario", "fctuc", "deec", "daqui", 91893737, 123123, DATE '2010-2-10'),
 ("pedro", "pass", "funcionario", "fluc", "dei", "daqui", 91893737, 123123, DATE '2010-2-10'),
 ("tobias", "pass", "funcionario", "fctuc", "dei", "daqui", 91893737, 123123, DATE '2010-2-10'),
 ("zequinha", "pass", "professor", "fctuc", "deec", "daqui", 91893737, 123123, DATE '2010-2-10'),
 ("tina", "pass", "professor", "fctuc", "dei", "daqui", 91893737, 123123, DATE '2010-2-10'),
 ("rosa", "pass", "professor", "fctuc", "dei", "daqui", 91893737, 123123, DATE '2010-2-10');

insert into department ( department_name,college_name) values
("dei","fctuc"),
("deec","fctuc");

insert into college (college_name,initials) values
("faculdade de ciencias e tecnologias da universidade de coimbra","fctuc"),
("faculdade de letras da universidade de coimbra","fluc");