数据库实验源代码大全.pdfVIP

数据库实验源代码大全

实验一：数据定义语言

createuserU099074235IDENTIFIEDBYXHM123DEFAULTTABLESPACE

DXPDATASPACE

1,创建表Student

CREATETABLEStudent(

SNOCHAR(5),

SNAMECHAR(10)NOTNULL,

SDEPTCHAR(2)NOTNULL,

SCLASSCHAR(2)NOTNULL,

SAGENUMBER(2),

SSEXCHAR(2),

CONSTRAINTSNO_PKPRIMARYKEY(SNO));

2，创建表Course

CREATETABLECourse(

CNOCHAR(3),

CNAMEVARCHAR2(16),

CTIMENUMBER(3),

CONSTRAINTCNO_PKPRIMARYKEY(CNO)

)

3,创建表Teach

CREATETABLETeach(

TNOVARCHAR(6),

TNAMEVARCHAR(8),

TSEXCHAR(2),

CNOCHAR(3),

TDATEDATE,

TDEPTCHAR(2),

CONSTRAINTTT_PKPRIMARYKEY(TNO),

CONSTRAINTCNO_FKFOREIGNKEY(CNO)REFERENCESCourse(CNO)

)

CREATETABLETeach(

TNOVARCHAR(6),

TNAMEVARCHAR(8),

TSEXCHAR(2),

CNOCHAR(3),

TAGENUMBER(2),

TDEPTCHAR(2),

CONSTRAINTTT_PKPRIMARYKEY(TNO),

CONSTRAINTCNO_FKFOREIGNKEY(CNO)REFERENCESCourse(CNO)

)

4,创建表Score

CREATETABLEScore(

SNOCHAR(5),

CNOCHAR(3),

SCORENUMBER(5,2),

CONSTRAINTSC_PKPRIMARYKEY(SNO,CNO),

CONSTRAINTSNO_FKFOREIGNKEY(SNO)REFERENCESStudent(SNO),

CONSTRAINTCNOM_FKFOREIGNKEY(CNO)REFERENCESCourse(CNO)

)

二、插入数据

1，Student

INSERTINTOStudentVALUES(96001,马小燕,CS,01,21,女);

INSERTINTOStudentVALUES(96002,黎明,CS,01,18,男);

INSERTINTOStudentVALUES(96003,刘东明,MA,01,18,男);

INSERTINTOStudentVALUES(96004,赵志勇,IS,02,20,男);

INSERTINTOStudentVALUES(97001,马蓉,MA,02,19,女);

INSERTINTOStudentVALUES(97002,李成功,CS,01,20,男);

INSERTINTOStudentVALUES(97003,黎明,IS,03,19,女);

INSERTINTOStudentVALUES(97004,李丽,CS,02,19,女);

INSERTINTOStudentVALUES(96005,司马志明,CS,02,18,男);

2，Course

INSERTINTOCourseVALUES(001,数学分析,144);

INSERTINTOCourseVALUES(002,普通物理,144);

INSERTINTOCourseVALUES(003,微机原理,72);

INSERTINTOCourseVALUES(004,数据结构,72);

INSERTINTOCourseVALUES(005,操作系统,64);

INSERTINTOCourseVALUES(006,数据库原理,64);

INSERTINTOCourseVALUES(007,DB_Design,48);

INSERTINTOCourseVALUES(008,程