Oracle学生表、课程表、学生课程表 xs kc xs_kc

最新推荐文章于 2022-08-05 16:38:37 发布
学习不易
最新推荐文章于 2022-08-05 16:38:37 发布
阅读量975
点赞数
分类专栏： Mysql
本文链接：https://blog.csdn.net/qq_43656233/article/details/111569259
版权
Mysql 专栏收录该内容
6 篇文章 1 订阅
订阅专栏
CREATE TABLE kc ("KCH" CHAR(3 byte) NOT NULL,
    "KCM" CHAR(18 byte) NOT NULL, "KKXQ" NUMBER(1) NOT NULL, "XS"
    NUMBER(2) NOT NULL, "XF" NUMBER(1),
    CONSTRAINT "CHECK_KKXQ_1" CHECK(kkxq between 1
    and 8),
    CONSTRAINT "PK_KCH_1" PRIMARY KEY("KCH")
    USING INDEX 
    TABLESPACE "USERS"
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255,
    CONSTRAINT "XF_1" CHECK(xf between 0
    and 10)) 
    TABLESPACE "USERS" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS
    255
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0)
    LOGGING
    MONITORING;

CREATE TABLE xs ("XH" CHAR(6 byte) NOT NULL, "XM"
    VARCHAR2(20) NOT NULL, "ZYM" CHAR(12 byte), "XB" CHAR(3
    byte) NOT NULL, "CSSJ" DATE NOT NULL, "ZXF" NUMBER(2), "BZ"
    VARCHAR2(200 byte),
    CONSTRAINT "PK_XH_1" PRIMARY KEY("XH")
    USING INDEX 
    TABLESPACE "USERS"
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
    TABLESPACE "USERS" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS
    255
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0)
    LOGGING
    MONITORING;

CREATE TABLE xs_kc ("XH" CHAR(6 byte) NOT NULL,
    "KCH" CHAR(3 byte) NOT NULL, "CJ" NUMBER(2), "XF" NUMBER(1),
    CONSTRAINT "PK_XS_KC_1" PRIMARY KEY("XH", "KCH")
    USING INDEX 
    TABLESPACE "USERS"
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255)
    TABLESPACE "USERS" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS
    255
    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS
    2147483645 PCTINCREASE 0)
    LOGGING
    MONITORING;

insert into xs(xh,xm,zym,xb,cssj,zxf) values('061101',' 王林','计算机','男',to_date('19860210','yyyymmdd'),50);
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061102','王平','计算机','女',to_date('19860902','yyyymmdd'),38);
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061103','王燕','计算机','女',to_date('19851006','yyyymmdd'),40);
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061104','韦严平','计算机','女',to_date('19860826','yyyymmdd'),40);
insert into xs(xh,xm,zym,xb,cssj,zxf,bz) values('061105','吴庆红','计算机','男',to_date('19851230','yyyymmdd'),36,'有两门课不及格');
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061106','李方方','计算机','男',to_date('19861120','yyyymmdd'),40);
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061107','李明','计算机','男',to_date('19860501','yyyymmdd'),40);
insert into xs(xh,xm,zym,xb,cssj,zxf,bz) values('061108','林一凡','计算机','男',to_date('19850805','yyyymmdd'),40,'已提前修完一门课');
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061109','张强民','计算机','男',to_date('19840811','yyyymmdd'),40);
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061110','张蔚','计算机','女',to_date('19870722','yyyymmdd'),40);
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061111','赵琳','计算机','女',to_date('19860318','yyyymmdd'),40);
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061112','罗琳琳','计算机','女',to_date('19840130','yyyymmdd'),40);

insert into xs(xh,xm,zym,xb,cssj,zxf) values('061201','王敏','通讯工程','男',to_date('19840610','yyyymmdd'),42);
insert into xs(xh,xm,zym,xb,cssj,zxf,bz) values('061202','王林','通讯工程','男',to_date('19850129','yyyymmdd'),40,'有一门课不及格，待补考');
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061203','王玉民','通讯工程','男',to_date('19860326','yyyymmdd'),42);
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061204','马琳琳','通讯工程','女',to_date('19840210','yyyymmdd'),42);
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061206','李计','通讯工程','女',to_date('19850920','yyyymmdd'),42);
insert into xs(xh,xm,zym,xb,cssj,zxf,bz) values('061210','李红庆','通讯工程','女',to_date('19850501','yyyymmdd'),44,'已提前修完一门课成，并获得学分');

insert into xs(xh,xm,zym,xb,cssj,zxf) values('061216','孙祥欣','通讯工程','女',to_date('19840309','yyyymmdd'),42);
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061218','孙研','通讯工程','男',to_date('19861009','yyyymmdd'),42);
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061220','吴薇华','通讯工程','女',to_date('19860318','yyyymmdd'),42);
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061221','刘燕敏','通讯工程','女',to_date('19851112','yyyymmdd'),42);
insert into xs(xh,xm,zym,xb,cssj,zxf) values('061241','罗琳琳','通讯工程','女',to_date('19860130','yyyymmdd'),50);

insert into kc values('101','计算机基础  ', 1,80,5);
insert into kc values('102','程序设计语言', 2,68,4);
insert into kc values('206','离散数学   ', 4,68,4);
insert into kc values('208','数据结构', 5,68,4);
insert into kc values('109','操作系统', 6,68,4);
insert into kc values('210','计算机原理',7,85,5);
insert into kc values('212','数据库原理', 7,68,4);
insert into kc values('301','计算机网络', 7,51,3);
insert into kc values('302','软件工程',7,51,3);


insert into xs_kc(xh,kch,cj) values('061101','101', 80);
insert into xs_kc(xh,kch,cj) values('061101','102', 78);
insert into xs_kc(xh,kch,cj) values('061101','206', 76);
insert into xs_kc(xh,kch,cj) values('061103','101', 62);
insert into xs_kc(xh,kch,cj) values('061103','102', 70);
insert into xs_kc(xh,kch,cj) values('061103','206', 81);
insert into xs_kc(xh,kch,cj) values('061104','101', 90);

insert into xs_kc(xh,kch,cj) values('061107','101', 78);
insert into xs_kc(xh,kch,cj) values('061107','102', 80);
insert into xs_kc(xh,kch,cj) values('061107','206', 68);
insert into xs_kc(xh,kch,cj) values('061108','101', 85);
insert into xs_kc(xh,kch,cj) values('061108','102', 64);
insert into xs_kc(xh,kch,cj) values('061108','106', 87);
insert into xs_kc(xh,kch,cj) values('061109','101', 66);

insert into xs_kc(xh,kch,cj) values('061111','206', 76);
insert into xs_kc(xh,kch,cj) values('061113','101', 63);
insert into xs_kc(xh,kch,cj) values('061113','102', 79);
insert into xs_kc(xh,kch,cj) values('061113','206', 60);
insert into xs_kc(xh,kch,cj) values('061201','101', 80);
insert into xs_kc(xh,kch,cj) values('061202','101', 65);
insert into xs_kc(xh,kch,cj) values('061203','101', 87);

insert into xs_kc(xh,kch,cj) values('061104','102', 84);
insert into xs_kc(xh,kch,cj) values('061104','206', 65);
insert into xs_kc(xh,kch,cj) values('061102','102', 78);
insert into xs_kc(xh,kch,cj) values('061102','206', 78);
insert into xs_kc(xh,kch,cj) values('061106','101', 65);
insert into xs_kc(xh,kch,cj) values('061106','102', 71);
insert into xs_kc(xh,kch,cj) values('061106','206', 80);

insert into xs_kc(xh,kch,cj) values('061109','102', 83);
insert into xs_kc(xh,kch,cj) values('061109','206', 70);
insert into xs_kc(xh,kch,cj) values('061110','101', 95);
insert into xs_kc(xh,kch,cj) values('061110','102', 90);
insert into xs_kc(xh,kch,cj) values('061110','206', 89);
insert into xs_kc(xh,kch,cj) values('061111','101', 91);
insert into xs_kc(xh,kch,cj) values('061111','102', 70);

insert into xs_kc(xh,kch,cj) values('061204','101', 91);
insert into xs_kc(xh,kch,cj) values('061210','101', 76);
insert into xs_kc(xh,kch,cj) values('061216','101', 81);
insert into xs_kc(xh,kch,cj) values('061218','101', 70);
insert into xs_kc(xh,kch,cj) values('061220','101', 82);
insert into xs_kc(xh,kch,cj) values('061221','101', 76);
insert into xs_kc(xh,kch,cj) values('061241','101', 90);