Sutdent表的定义
字段名字段描述数据类型主键外键非空唯一自增Id学号INT(10)是否是是是Name姓名VARCHAR(20)否否是否否Sex性别VARCHAR(4)否否否否否Birth出生年份YEAR否否否否否Department院系VARCHAR(20)否否是否否Address家庭住址VARCHAR(50)否否否否否
Score表的定义
字段名字段描述数据类型主键外键非空唯一自增Id编号INT(10)是否是是是Stu_id学号INT(10)否否是否否C_name课程名VARCHAR(20)否否否否否Grade分数INT(10)否否否否否
1.创建student和score表
create table student(
id number(10)not null primary key,
name varchar2(20)not null,
sex varchar2(4),
birth number,
department varchar2(20)not null,
address varchar2(50)
);
create table score(
id number(10)not null primary key,
stu_id number(10)not null,
c_name varchar2(20),
grade number(10)
);
2.为student表和score表增加记录
向student表插入记录的INSERT语句如下:
Insert into student values(100101,'张三','男',23,'计算机系','北京市朝阳区');
Insert into student values(100102,'李四','男',21,'英语系','北京市海淀区');
Insert into student values(100103,'王五','女',19,'建工系','北京市昌平区');
Insert into student values(100104,'孙六','女',21,'化学系','北京市苏州桥');
Insert into student values(100105,'齐七','男',23,'英语系','北京市海淀区');
向score表插入记录的INSERT语句如下:
Insert into score values(001,100101,'计算机基础',89);
Insert into score values(002,100101,'英语',93);
Insert into score values(003,100101,'数学',87);