use company
go
execute ADD_EMPLOYEE 'B276548','Dimou','Giorgos',2000,'Araxthou 4', 'M', '10/08/1956', null, 1
execute ADD_EMPLOYEE 'S676548','Pappas','Kwstas',1000,'Filellinon 10 Giannena','M', '06/11/1970',null, 2
execute ADD_EMPLOYEE 'A276654','Kwsta','Maria', 1500, 'Benizelou 2 Preveza','F', '02/07/1970' ,null, 3
execute ADD_EMPLOYEE 'AE342134','Andreou','Antonis', 2000, 'Georgiou Pappa 12 Arta','M', '02/12/1977',null, 4
execute ADD_EMPLOYEE 'G276548','Georgiou','Giorgos', 2000, 'Metamorfosis 12 Giannena','M', '2/12/1969',null, 5
execute ADD_EMPLOYEE 'E375898','Mitsios','Andreas', 900, 'Kalitheas 12 Giannena','M', '5/9/1959', 'B276548', 1
execute ADD_EMPLOYEE 'A475637','Floros','Dimitris', 800, 'Araxthou 80 Arta','M', '1/1/1964', 'B276548', 1
execute ADD_EMPLOYEE 'K876543','Florou','Amalia', 800, 'Araxthou 80 Arta','F', '09/10/1987', 'S676548', 2
execute ADD_EMPLOYEE 'X674532','Dara','Stauroula', 950, 'Bas Konstantinou 2 Preveza','F', '08/11/1984', 'S676548', 2
execute ADD_EMPLOYEE 'H576543','Karras',' Andreas', 900, 'Kalitheas 12  Giannena','M', '6/08/1980', 'A276654', 3
execute ADD_EMPLOYEE 'K475637','Petrou','Dimitris', 800, 'Araxthou 80 Arta','M', '1/1/1964', 'A276654', 3
execute ADD_EMPLOYEE 'H576544','Toli','Amalia', 800, 'Araxthou 80 Arta','F', '09/10/1977', 'AE342134', 4
execute ADD_EMPLOYEE 'J674532','Foti','Stauroula', 950, 'Bas Konstantinou 2 Preveza ','F', '08/11/1964', 'G276548', 5

execute ADD_DEPARTMENT 1, 'Management','B276548','2/05/1982'
execute ADD_DEPARTMENT 2, 'Polisewn','S676548','04/02/1983'
execute ADD_DEPARTMENT 3, 'Logistiriou','A276654', '3/08/1984'
execute ADD_DEPARTMENT 4, 'Marketing','AE342134', '09/25/1990'
execute ADD_DEPARTMENT 5, 'Ereunas', 'G276548', '02/3/1993'

execute ADD_DEP_LOCATION 1, 'Arta'
execute ADD_DEP_LOCATION 1, 'Giannena'
execute ADD_DEP_LOCATION 2, 'Arta'
execute ADD_DEP_LOCATION 2, 'Preveza'
execute ADD_DEP_LOCATION 3, 'Giannena'
execute ADD_DEP_LOCATION 4, 'Arta'
execute ADD_DEP_LOCATION 4, 'Giannena'
execute ADD_DEP_LOCATION 5, 'Preveza'
execute ADD_DEP_LOCATION 5, 'Giannena'

execute ADD_PROJECT 1, 'Apografi proiontwn','Giannena',2 
execute ADD_PROJECT 2, 'Ereuna agoras','Giannena',5 
execute ADD_PROJECT 3, 'Proothisi proiontwn','Arta',4 
execute ADD_PROJECT 4, 'Proothisi proiontwn','Giannena',4 
execute ADD_PROJECT 5, 'Nees Agores','Giannena',1 
execute ADD_PROJECT 6, 'Epektasi','Giannena',1 
execute ADD_PROJECT 7, 'Diafimisi proiontwn','Giannena',4
execute ADD_PROJECT 8, 'Enimerosi proiontwn','Arta',1

execute ADD_WORKS_ON 'B276548',5,30
execute ADD_WORKS_ON 'B276548',6,25
execute ADD_WORKS_ON 'S676548',3,10
execute ADD_WORKS_ON 'S676548',4,10
execute ADD_WORKS_ON 'A276654',1,30
execute ADD_WORKS_ON 'A276654',8,5
execute ADD_WORKS_ON 'E375898',3,20
execute ADD_WORKS_ON 'E375898',5,15
execute ADD_WORKS_ON 'K876543',4,10
execute ADD_WORKS_ON 'X674532',3,10
execute ADD_WORKS_ON 'H576543',8,10
execute ADD_WORKS_ON 'H576543',4,10
execute ADD_WORKS_ON 'H576543',1,5
execute ADD_WORKS_ON 'H576543',5,5
execute ADD_WORKS_ON 'J674532',6,5

execute ADD_DEPENDENT 'B276548','Maria','F','04/08/1989','kori'
execute ADD_DEPENDENT 'B276548','Kwstas','M','04/08/1989','gios'
execute ADD_DEPENDENT 'AE342134','Aliki','F','02/09/1990','kori'
execute ADD_DEPENDENT 'AE342134','Maria','F','01/24/1988','kori'
execute ADD_DEPENDENT 'AE342134','Amalia','F','12/12/1988','kori'
execute ADD_DEPENDENT 'E375898','Giorgos','M','11/08/1989','gios'
execute ADD_DEPENDENT 'G276548','Dimitris','M','2/24/1990','gios'
execute ADD_DEPENDENT 'X674532','Zinovia','F','2/17/1970','aderfi'