INSERT INTO Title (NameTitle,Salary,hasAccount) VALUES ('Air cabin crew',2000,0);

INSERT INTO Title (NameTitle,Salary,hasAccount) VALUES ('Airline customer agent',3000,0);

INSERT INTO Title (NameTitle,Salary,hasAccount) VALUES ('Airline pilot',4000,0);

INSERT INTO Title (NameTitle,Salary,hasAccount) VALUES ('Airport information',5000,0);

INSERT INTO Title (NameTitle,Salary,hasAccount) VALUES ('Administrator',1000,3);

INSERT INTO Title (NameTitle,Salary,hasAccount) VALUES ('Air Human Resources',1000,1);

INSERT INTO Title (NameTitle,Salary,hasAccount) VALUES ('Supply chain manager',3000,2);

INSERT INTO Title (NameTitle,Salary,hasAccount) VALUES ('Road transport manager',3000,2);

INSERT INTO Title (NameTitle,Salary,hasAccount) VALUES ('Bus or coach driver',3000,0);

INSERT INTO Title (NameTitle,Salary,hasAccount) VALUES ('Transport Human Resources',3000,2);



INSERT INTO Skills (NameSkill) VALUES ('driving');

INSERT INTO Skills (NameSkill) VALUES ('mechanics');

INSERT INTO Skills (NameSkill) VALUES ('electronics');

INSERT INTO Skills (NameSkill) VALUES ('communication');

INSERT INTO Skills (NameSkill) VALUES ('administrative');

INSERT INTO Skills (NameSkill) VALUES ('customer Service');

INSERT INTO Skills (NameSkill) VALUES ('management');

INSERT INTO Skills (NameSkill) VALUES ('interviews');

INSERT INTO Skills (NameSkill) VALUES ('translation');

INSERT INTO Skills (NameSkill) VALUES ('problem solving');



INSERT INTO Jobs (NameJob,Information,[Date]) VALUES ('Airline pilot','We need pilots for airplanes','01/10/2015');

INSERT INTO Jobs (NameJob,Information,[Date]) VALUES ('Bus driver','We need bus drivers','05/12/2015');

INSERT INTO Jobs (NameJob,Information,[Date]) VALUES ('Air cabin crew','Crew for air cabins','09/20/2015');

INSERT INTO Jobs (NameJob,Information,[Date]) VALUES ('Airline customer agent','Agents for customer servis with airlines','09/22/2015');

INSERT INTO Jobs (NameJob,Information,[Date]) VALUES ('Supply chain manager','manager for supply chain','11/13/2015');

INSERT INTO Jobs (NameJob,Information,[Date]) VALUES ('Transport Human Resources','Person who will work with human resources in the transport department','10/25/2015');


INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant) 
	VALUES ('1111111111111','Angelina','Jolie');

INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant) 
	VALUES ('1111111111112','Brad','Pitt');

INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant) 
	VALUES ('1111111111113','George','Clooney');

INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant) 
	VALUES ('1111111111114','Jesica','Alba');

INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant) 
	VALUES ('1111111111115','Vladimir','Putin');

INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant) 
	VALUES ('1111111111116','Barack','Obama');

INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant) 
	VALUES ('1111111111117','Angela','Merkel');

INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant) 
	VALUES ('1111111111118','Karolina','Gocheva');

INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant) 
	VALUES ('1111111111119','Vlado','Janevski');

INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant) 
	VALUES ('1111111111110','Cristiano','Ronaldo');

INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant) 
	VALUES ('1111111111120','De','Gea');

INSERT INTO Applicant (IdApplicant,NameApplicant,SurnameApplicant) 
	VALUES ('1111111111121','Salma','Hayek');

	
INSERT INTO JobsApplicants (IdJob,IdApplicant) 
	VALUES ('29','1111111111112');

INSERT INTO JobsApplicants (IdJob,IdApplicant) 
	VALUES ('29','1111111111111');

INSERT INTO JobsApplicants (IdJob,IdApplicant) 
	VALUES ('32','1111111111110');

INSERT INTO JobsApplicants (IdJob,IdApplicant) 
	VALUES ('33','1111111111113');

INSERT INTO JobsApplicants (IdJob,IdApplicant) 
	VALUES ('33','1111111111114');

INSERT INTO JobsApplicants (IdJob,IdApplicant) 
	VALUES ('33','1111111111115');

INSERT INTO JobsApplicants (IdJob,IdApplicant) 
	VALUES ('34','1111111111116');

INSERT INTO JobsApplicants (IdJob,IdApplicant) 
	VALUES ('34','1111111111117');

INSERT INTO JobsApplicants (IdJob,IdApplicant) 
	VALUES ('35','1111111111118');

INSERT INTO JobsApplicants (IdJob,IdApplicant) 
	VALUES ('35','1111111111119');

INSERT INTO JobsApplicants (IdJob,IdApplicant) 
	VALUES ('35','1111111111120');

INSERT INTO JobsApplicants (IdJob,IdApplicant) 
	VALUES ('35','1111111111121');
	
INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
	VALUES ('2222222222220','Bill','Clinton','Macedonia','Air cabin crew','active');

INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
	VALUES ('2222222222221','Chuck','Noris','Macedonia','Airline customer agent','active');

INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
	VALUES ('2222222222222','Ana','Atanasova','Macedonia','Administrator','active');

INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
	VALUES ('2222222222223','Goran','Lazarov','Macedonia','Administrator','active');

INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
	VALUES ('2222222222224','Filip','Davkovski','Macedonia','Administrator','active');

INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
	VALUES ('2222222222225','Ivona','Lazarovska','Macedonia','Supply chain manager','active');
	
INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
	VALUES ('5222222222225','Ivona','Jolie','Macedonia','Supply chain manager','active');

INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
	VALUES ('2222222222226','Vase','Pandev','Macedonia','Transport Human Resources','active');

INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
	VALUES ('2222222222227','Martin','Donovan','Macedonia','Air Human Resources','active');

INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
	VALUES ('2222222222228','Bruce','Willis','Macedonia','Airport information','active');

INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
	VALUES ('2222222222229','Jackie','Chan','Macedonia','Bus or coach driver','active');
	
INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
	VALUES ('1222222222228','George','Will','Macedonia','Transport Human Resources','active');

INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
	VALUES ('1222222222229','Jackie','Willis','Macedonia','Supply chain manager','active');
	
INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
	VALUES ('2222222222230','Richard','Gere','Macedonia','Air cabin crew','Fired');

INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
	VALUES ('2222222222231','Selena','Gomez','Macedonia','Airline customer agent','Fired');
	
INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
	VALUES ('2222222222233','Bob','Dylan','Macedonia','Transport Human Resources','Fired');

INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
	VALUES ('2222222222234','Boby','Gomez','Macedonia','Supply chain manager','Fired');

INSERT INTO Employee (IdEmployee,NameEmployee,SurnameEmployee,Contact,NameTitle,[Status]) 
	VALUES ('2222222222235','Justin','Tmberlake','Macedonia','Transport Human Resources','Fired');

INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating) 
	VALUES ('2222222222220','administrative',5.00);
	
INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating) 
	VALUES ('2222222222222','communication',5.00);

INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating) 
	VALUES ('2222222222223','driving',10.00);
	
INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating) 
	VALUES ('2222222222221','customer Service',5.00);
	
INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating) 
	VALUES ('2222222222221','administrative',10.00);

INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating) 
	VALUES ('1222222222228','customer Service',10.00);

INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating) 
	VALUES ('2222222222221','communication',10.00);

INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating) 
	VALUES ('2222222222229','driving',10.00);

INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating) 
	VALUES ('2222222222220','problem solving',8.00);

INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating) 
	VALUES ('1222222222228','problem solving',8.00);

INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating) 
	VALUES ('1222222222228','mechanics',7.00);

INSERT INTO EmployeeSkills(IdEmployee,NameSkill,Rating) 
	VALUES ('1222222222229','electronics',6.00);

