CREATE TABLE departamentokadson (
  iddepartamentokadson INTEGER UNSIGNED  NOT NULL   AUTO_INCREMENT,
  nome VARCHAR(50)  NULL  ,
  somaqtde INTEGER UNSIGNED  NULL DEFAULT 0 ,
  somasalario REAL  NULL DEFAULT 0   ,
PRIMARY KEY(iddepartamentokadson));



CREATE TABLE funcionariokadson (
  idfuncionariokadson INTEGER UNSIGNED  NOT NULL   AUTO_INCREMENT,
  departamentokadson_iddepartamentokadson INTEGER UNSIGNED  NOT NULL  ,
  nome VARCHAR(50)  NULL  ,
  salario REAL  NULL    ,
PRIMARY KEY(idfuncionariokadson)  ,
INDEX funcionariokadson_FKIndex1(departamentokadson_iddepartamentokadson),
  FOREIGN KEY(departamentokadson_iddepartamentokadson)
    REFERENCES departamentokadson(iddepartamentokadson)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION);




