INSERT INTO REGIONS (REGION_ID, NAME)
VALUES (1,N'Балкански полуостров')

INSERT INTO COUNTRIES(COUNTRY_ID, NAME, REGION_ID)
VALUES ('BG','България', 1)

INSERT INTO DEPARTMENTS(DEPARTMENT_ID,NAME,COUNTRY_ID,CITY,ADDRESS,POSTAL_CODE)
VALUES(1,N'Научни разработки','BG',N'Пловдив',N'бул. Н. Вапцаров 25','4000')

INSERT INTO JOBS(JOB_ID,JOB_TITLE,MIN_SALARY,MAX_SALARY)
VALUES('DEV',N'Програмист',2000,6000)

INSERT INTO EMPLOYEE(EMPLOYEE_ID,FNAME,LNAME,EMAIL,PHONE,HIRE_DATE,SALARY,JOB_ID,DEPARTMENT_ID)
VALUES(1,N'ИВАН',N'ПЕТРОВ', 'ipetrov@abv.bg', '(+359)884572631', CONVERT(datetime, '17-01-2019', 105),3500, 'DEV', 1)