《数据库原理》
实验报告
学号:姓名:
实验一:SQL定义功能、数据插入
1.建立教学数据库的三个基本表:
fSS
oS
ameSsexSageSdept学生(学号,姓名,性别,年龄,系)SCS
oC
oGrade选课(学号,课程号,成绩)CC
oC
ameCp
oCcredit课程(课程号,课程名,先行课,学分)__________________________________________________________________createtableS040930504S
ochar9PRIMARYKEYS
amechar40Ssexchar2SageSMALLINTSdeptchar20createtableSC040930504S
ochar9C
ochar4GradeSMALLINTcreatetableC040930504C
ochar4C
amechar40Cp
ochar4CcreditSMALLINTi
serti
toS040930504values200215121李勇男20CSi
serti
toS040930504values200215122刘晨女19CSi
serti
toS040930504values20204王敏女18MAi
serti
toS040930504values30203张立男19ISi
serti
toSC040930504values200215121192i
serti
toSC040930504values200215121285i
serti
toSC040930504values200215121388i
serti
toSC040930504values200215122290i
serti
toSC040930504values200215122380i
serti
toC040930504values1数据库54i
serti
toC040930504
fvalues1数学2i
serti
toC040930504values1信息系统14i
serti
toC040930504values1操作系统63i
serti
toC040930504values1数据结构74i
serti
toC040930504values1数据处理2i
serti
toC040930504values1PASCAL语言64
SQLselectfromS040930504SNOSNAMESSEXSAGE200215121李勇男20
SDEPTCS
200215122
刘晨
女
19
CS
200215123
王敏
女
18
MA
200215125
张立
男
19
IS
SQLselectfromSC040930504SNOCNOGRADE200215121192200215121285200215121388200215122290200215122380SQLselectfromC040930504CNOCNAME1数据库1数学1信息系统1操作系统1数据结构
CPNO5167
CCREDIT42434
f11
数据处理PASCAL语言
6
24
_______________________________________________________
2.DROPTABLE、ALTERTABLE、CREATEINDEX、DROPINDEX及INSERT语句输入数据。_______________________________________________________________________________createtablez040930504S
ochar5sagechar2S
amechar6i
serti
toz040930504values1512120李勇i
serti
toz040930504values3050420朱猪ALTERtablez040930504ADDs_e
tra
ceDATEDROPtablez040930504CREATEUNIQUEINDEXStuS
oONz040930504S
oDROPINDEXStuS
o_______________________________________________________________________________
实验二:数据查询
1.查询选修1号课程的学生学号与姓名。SQLSELECTS
oS
ame2FROMS0409305043WHEREEXISTS4SELECT5FRr