Create table Employees (EmployeeID integer primary key autoincrement,Name text, Occupation text, Manager Integer,Salary real, DateOfBirth text, Department integer, AddressID integer);


Create table Departments( DepartmentID integer primary key autoincrement, DepartmentName text);
INSERT INTO Departments ( DepartmentName)
    VALUES ( " Manager");
INSERT INTO Departments ( DepartmentName)
    VALUES ( " Marketing");
INSERT INTO Departments ( DepartmentName)
    VALUES ( " Finance");
cities - Sofia, Pleven
adresses - ul.
INSERT INTO Employees ( EmployeeID integer primary key autoincrement,Name text, Occupation text, Manager Integer,Salary real, DateOfBirth text, Department integer, AddressID integer)
    VALUES ( "Bojidar", "2004.11.23", "Todor Kableshkov 22a", "2000"," "," Manager",""," ");
    Create table Cities( CityID integer primary key autoincrement,

CityName text);
INSERT INTO Cities ( Cityname text)
    VALUES ( "Sofia");
INSERT INTO Cities (Cityname text)
    VALUES ("Pleven");

Create table Address(AddressID integer primary key autoincrement, Text text, CityID integer);
INSERT INTO Address (Address)
    VALUES ( "Todor Kableshkov 22a",1);
INSERT INTO Address (Address)
    VALUES ( "Todor Kableshkov 31a",2);
INSERT INTO Address (Address)
    VALUES ( "Todor Kableshkov 30a",1);
INSERT INTO Address (Address)
    VALUES ( "Todor Kableshkov 29a",1);
 INSERT INTO Address (Address)
    VALUES ( "Todor Kableshkov 28a",2);
 INSERT INTO Address (Address)
    VALUES ( "Todor Kableshkov 27a",2);
 INSERT INTO Address (Address)
    VALUES ( "Todor Kableshkov 26a",2);
 INSERT INTO Address (Address)
    VALUES ( "Todor Kableshkov 25a",1);
INSERT INTO Address (Address)
    VALUES ( "Todor Kableshkov 24a",1);
INSERT INTO Address (Address)
    VALUES ( "Todor Kableshkov 23a",2);
/*
cities - Sofia, Pleven
adresses - ul.
INSERT INTO Employees ( EmployeeID integer primary key autoincrement,Name text, Occupation text, Manager Integer,Salary real, DateOfBirth text, Department integer, AddressID integer)
    VALUES ( "Bojidar", "2004.11.23", "Todor Kableshkov 22a", "2000"," "," Manager",""," ");
    Create table Cities( CityID integer primary key autoincrement,

CityName text);
INSERT INTO Cities ( Cityname text)
    VALUES ( "Sofia");
INSERT INTO Cities (Cityname text)
    VALUES ("Pleven");
*/