|
|
---班級(jí)
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
)
---班級(jí)與老師的關(guān)系
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, '語(yǔ)文')
insert into banji_laoshi values(2, 1003, '數(shù)學(xué)')
insert into banji_laoshi values(3, 1004, '英語(yǔ)')
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);
|
|
