达梦数据库原理及应用-强化训练答案 (3).docxVIP

【强化训练4.1】

利用DM_SQL语句定义class表、department表、floor表、teacher表、teaching表的结构。

CREATETABLEclass

(classnochar(8)PRIMARYKEY,

classnamevarchar(20),

specialityvarchar(60),

indatedate,

classnumbertinyint,

headerchar(10),

deptnochar(4),

classroomvarchar(16),

monitorchar(8),

CONSTRAINTB1FOREIGNKEY(deptno)REFERENCESdepartment(deptno)

);

CREATETABLEdepartment

(deptnochar(4)PRIMARYKEY,

deptnamechar(14),

deptheaderchar(8),

officechar(20),

deptphonechar(20)DEFAULT不详

);

CREATETABLEfloor

(sfloorchar(10)NOTNULL,

sroomnochar(5)NOTNULL,

ssexchar(2),

maxnUMtinyint,

CONSTRAINTB2