oracle 数据库课程设计，可运行

create user gzgl_zxy_420 identified by zxy_420; grant dba to gzgl_zxy_420; create table GZGL_ZXY_420 ( GZGL_GH VARCHAR2(20) not null, GZGL_YEAR INTEGER not null, GZGL_MON INTEGER not null, GZGL_XM VARCHAR2(20) null , GZGL_BM VARCHAR2(20) null , GZGL_GZ NUMBER(10,2) null , GZGL_JJ NUMBER(10,2) null , GZGL_GS NUMBER(10,2) null , constraint PK_GZGL_ZXY_420 primary key (GZGL_GH, GZGL_YEAR, GZGL_MON) ) / comment on column GZGL_ZXY_420.GZGL_GH is '员工工号' / comment on column GZGL_ZXY_420.GZGL_YEAR is '工资所属年' / comment on column GZGL_ZXY_420.GZGL_MON is '工资所属月' / comment on column GZGL_ZXY_420.GZGL_XM is '员工姓名' / comment on column GZGL_ZXY_420.GZGL_BM is '所在部门' / comment on column GZGL_ZXY_420.GZGL_GZ is '员工工资' / comment on column GZGL_ZXY_420.GZGL_JJ is '员工奖金' / comment on column GZGL_ZXY_420.GZGL_GS is '应交个税' / create table BM_ZXY_420 ( BM_BH INTEGER not null, BM_MC VARCHAR2(20) not null , constraint PK_BM_ZXY_420 primary key (BM_BH) ) / comment on column BM_ZXY_420.BM_BH is '部门编号' / comment on column BM_ZXY_420.BM_MC is '部门名称' / insert into bm_zxy_420 values(1,'市场部'); insert into bm_zxy_420 values(2,'研发部'); insert into bm_zxy_420 values(3,'人事部'); insert into bm_zxy_420 values(4,'财务部'); /