您的位置:自考365 > 复习指导 > 历年试题 > 北大“数据库原理”上机实践题目总结(15)

北大“数据库原理”上机实践题目总结(15)

2007-07-18 14:59   【 】【我要纠错

  INSERT INTO W193_ATHLETE VALUES('1001','李明','男','计算机系')

  INSERT INTO W193_ATHLETE VALUES('1002','张三','男','数学系')

  INSERT INTO W193_ATHLETE VALUES('1003','李四','男','计算机系')

  INSERT INTO W193_ATHLETE VALUES('1004','王二','男','物理系')

  INSERT INTO W193_ATHLETE VALUES('1005','李娜','女','心理系')

  INSERT INTO W193_ATHLETE VALUES('1006','孙丽','女','数学系')

  INSERT INTO W193_PROJECT VALUES('x001','男子五千米','一操场')

  INSERT INTO W193_PROJECT VALUES('x002','男子标枪','一操场')

  INSERT INTO W193_PROJECT VALUES('x003','男子跳远','二操场')

  INSERT INTO W193_PROJECT VALUES('x004','女子跳高','二操场')

  INSERT INTO W193_PROJECT VALUES('x005','女子三千米','三操场')

  INSERT INTO W193_GRADE VALUES('1001','x001','6')

  INSERT INTO W193_GRADE VALUES('1001','x003','4')

  INSERT INTO W193_GRADE VALUES('1002','x001','4')

  INSERT INTO W193_GRADE VALUES('1002','x003','6')

  INSERT INTO W193_GRADE VALUES('1003','x001','2')

  INSERT INTO W193_GRADE VALUES('1004','x001','0')

  INSERT INTO W193_GRADE VALUES('1004','x003','2')

  INSERT INTO W193_GRADE VALUES('1005','x004','6')

  INSERT INTO W193_GRADE VALUES('1006','x004','4')

  athlete(a#,aname,sex,dno)

  project(p#,pname,address)

  grade(a#,p#,jf)

  delete from w193_grade

  where p#='x002'

  select * from w193_grade

本文转载链接:北大“数据库原理”上机实践题目总结(15)

分享到:
  • 站内搜索
  • 课程搜索
  • 试题搜索

热门搜索:教材 报名 查分 免考 考试计划