数据库SQL期末考试题

## SQL
create database db148
on primary
(name=db148dat,
filename='D:\db148dat.mdf',
size=5mb,
maxsize=50mb,
filegrowth=5mb
)

log on
(name=db148dat_log,
filename='D:\db148_log.ldf',
size=5mb,
maxsize=50mb,
filegrowth=5mb
)








/*新建表Supplier,Part,Project,SPJ*/
use db1902078148
go

/*create table Supplier
(Sno char(15) not null primary key,
Sname varchar(10) not null,
Status int,
City varchar(10) not null
)

create table Part
(Pno char(15) not null primary key,
Pname char(10) not null,
color char(5)not null,
Weight int not null,
)

create table Project 
(PJno char(15)not null primary key,
PJname varchar(10)not null,
city varchar(10)not null
)
create table SPJ
(Sno char(15) not null,
Pno char(15) not null,
PJno char(15)not null ,
Qty int,
constraint PK_SPJ primary key(Sno,Pno,PJno)
)
alter table SPJ 
add constraint FK_SPJ_Supplier foreign key(Sno) references Supplier(Sno)
alter table SPJ 
add constraint FK_SPJ_Part foreign key(Pno) references Part(Pno)
alter table SPJ 
add constraint FK_SPJ_Project foreign key(PJno) references Project(PJno)*/







/*向表中添加数据*/
use db1902078148
go
insert Supplier(Sno,Sname,Status,City)
values('s1','精益',20,'天津'),
('s2','盛锡',10,'北京'),
('s3','东方红',30,'北京'),
('s4','丰盛泰',20,'天津')

insert Part(Pno,Pname,Color,Wei