use SuperMarket go create table GoodsType ( TypeId int identity(1,1) primary key, TypeName nvarchar(50) not null ) go create table Goods ( GoodsId int identity(1,1) primary key, GoodsName nvarchar(50) not null, Price float not null, TypeId int not null, ProdureCounts int not null foreign key(Type