CREATE DATABASE BillaStore

CREATE TABLE Employees
(
ID INT NOT NULL,
POSITION INT NOT NULL,
FullName VARCHAR(50) NOT NULL,
TowNumber INT NOT NULL,
Street VARCHAR(50),
StreetNumber INT NOT NULL,
Email VARCHAR(50) NOT NULL,
Phone CHAR(10) NOT NULL,
);

ALTER TABLE Employees
   ADD CONSTRAINT PK_employeeID PRIMARY KEY(ID);

   CREATE TABLE POSITION
(
ID INT NOT NULL UNIQUE,
POSITION VARCHAR(50),
Salary DECIMAL NOT NULL,
Hollydays INT NOT NULL,
Bonus DECIMAL,
);
ALTER TABLE Employees
   ADD CONSTRAINT FK_employeePos FOREIGN  KEY(ID)
   REFERENCES POSITION.ID
      ON DELETE CASCADE
      ON UPDATE CASCADE

CREATE TABLE EmployeeSalary(
ID_Employee INT NOT NULL,
ID_Position INT NOT NULL,
Salary_Month INT NOT NULL,
Salary_YearNUMBER INT NOT NULL,
WorkingDays INT NOT NULL,
Bonus INT,
Penalty INT,
Holydays_ForMonth INT,
Salart_ForMonth INT NOT NULL,
SalaryDate DATE
);
ALTER TABLE Employees
   ADD CONSTRAINT FK_employeePos FOREIGN  KEY(ID)
   REFERENCES POSITION.ID
      ON DELETE CASCADE
      ON UPDATE CASCADE

ALTER TABLE EmployeeSalary
   ADD CONSTRAINT FK_Position FOREIGN  KEY(ID_Position)
   REFERENCES POSITION.ID
      ON DELETE CASCADE
      ON UPDATE CASCADE

      ALTER TABLE EmployeeSalary
      ADD CONSTRAINT FK_Employee FOREIGN  KEY(ID_Employee)
   REFERENCES Employee.ID