---班级
create table banji
(
banji_id int primary key,
banji_name nvarchar(10) not null,
banji_num int not null,
)
---老师
create table laoshi
(
laoshi_id int primary key,
laoshi_name nvarchar(10) not null,
laoshi_age int not null
)
---班级与老师的关系
create table banji_laoshi
(
banji_id int constraint fk_banji foreign key references banji(banji_id),
laoshi_id int constraint fk_laoshi foreign key references laoshi(laoshi_id),
constraint pk_banji_laoshi primary key (banji_id, laoshi_id),
kecheng nvarchar(100) not null,
)
drop table banji_laoshi;
drop table laoshi;
select * from laoshi
select * from banji
select * from banji_laoshi
insert into banji_laoshi values(1, 1003, '语文')
insert into banji_laoshi values(2, 1003, '数学')
insert into banji_laoshi values(3, 1004, '英语')
insert into banji_laoshi values(4, 1005, '几何')
insert into banji_laoshi values(5, 1006, '体育')
insert into banji_laoshi values(1, 1002, '生物')
insert into banji_laoshi values(3, 1006, '历史')
insert into banji values(1, '初30班', 36);
insert into banji values(2, '初31班', 32);
insert into banji values(3, '初29班', 56);
insert into banji values(4, '初26班', 66);
insert into laoshi values(1001, '李红', 26);
insert into laoshi values(1002, '老张', 42);
insert into laoshi values(1003, '小王', 28);
insert into laoshi values(1004, '小韩', 29);
insert into laoshi values(1005, '李明', 26);
insert into laoshi values(1006, '赵玲', 26);
|
QQ好友和群
QQ空间
腾讯微博
腾讯朋友
收藏
淘帖
顶
踩
