编辑代码

CREATE DATABAS xzgl;
CREATE TABLE departments (
	dnum  CHAR(3) NOT NULL,
    dname  CHAR(20) NOT NULL,
	dphone  CHAR(10) ,
	PRIMARY KEY(dnum)
);

SELECT*FROM student;
CREATE TABLE employees(
    enum CHAR(6) NOT NULL PRTMARY KEY,
    enamelCHAR(10) NOT NULL,
    education  CHAR(4) NOT NULL
    birthday DATE NOT NULL, 
    sex CHAR(2) DEFAULT '男',
    workyears TINYTNT(1),
    address VARCHAR(30),
    tel CHAR(12),
    dnum CHAR(3),
    CONSTRATNT fk_dumn FOREIGN KEY(dumn) REFERENCES departments(dumn)
);

    CREATE TABLE salarly(
        enum CHAR(6) NOT NULL PRTMARY KEY,
        WORK_day TINYTNT (2)NOT NULL,
        base_wage DEFAULT(8,2) NOT NULL,
        merits_wage DEFAULT(8,2),
        BONUS_money DEFAULT(8,2),
        subsidy_money DEFAULT(8,2),
        social_base DECTMAL(8,2),
        extra_deduction DECTMAL(8,2),
        loss_money DECTMAL(8,2),
        payroll DECTMAL(8,2),
        CONSTRATNT fk_enum FOREIGN KEY(enum) REFERENCES employees(enum) /*