山东大学数据库实验1.docx

create table test1_student_course

(

sid char (12) not null,

cid char (6) not null,

score numeric (5,1) ,

d char (6),

scme date )

insert into test1_student values('200800020102','李华','女',20,date'1995-03-03','软

from test1_student_course;

select sid as a

from test1_student_course;

Create view test2_01 as

select disnct sid,name

from a,test1_student

where a.sid !=(test1_student.sid);

Create view test2_01 as

select test1_student .sid,name

from a,test1_student

age int,

birthday date,

dname varchar(30),

class varchar(10) )

create table test1_course

( cid char(6) not null,

name varchar(40) not null,

fcid char(6),

credit numeric(4,1))