1)
CREATE  TABLE `skripnik`.`scienes` (  
   `number` INT NOT NULL ,  
   `name` TINYTEXT NOT NULL ,  
   `lector` TINYTEXT NULL ,  
   `degree`  ENUM('доктор', 'магистр', 'бакалавр') ,  
   PRIMARY KEY (`number`) )  
DEFAULT CHARACTER SET = utf8;  
2)  

CREATE  TABLE `skripnik`.`specialization` (  
   `number` INT NOT NULL ,  
   `specializarion` TINYTEXT NOT NULL ,  
   `year` INT NULL ,  
   `quantity` INT NULL ,  
   PRIMARY KEY (`number`) )  
DEFAULT CHARACTER SET = utf8;

DELIMITER $$

USE `skripnik`$$
3) CREATE  TABLE `skripnik`.`assembly` (  
   `num sci` INT NOT NULL ,  
   `num spec` INT NOT NULL ,  
   `semester` ENUM('1','2','3','4','5','6','7','8') NOT NULL ,  
   `hours` INT NOT NULL ,  
   `cheking` ENUM('экзамен','зачет') NOT NULL ,  
   PRIMARY KEY (`semester`) ,  
   INDEX (`num sci` ASC) ,  
   INDEX `numberspec` (`num spec` ASC) ,  
   CONSTRAINT `numbersci`  
     FOREIGN KEY (`num sci` )  
     REFERENCES `skripnik`.`scienes` (`number` )  
     ON DELETE NO ACTION  
     ON UPDATE NO ACTION,  
   CONSTRAINT `numberspec`  
     FOREIGN KEY (`num spec` )  
     REFERENCES `skripnik`.`specialization` (`number` )  
     ON DELETE NO ACTION  
     ON UPDATE NO ACTION)  
DEFAULT CHARACTER SET = utf8;