数据库设计：网上购系统(初稿).docxVIP

附录：源程序IF Not exists (select * from syslogins where name=’u1’)Exec sp_addlogin u1,u1GoIF Not exists (select * from sysdatabases where name=’shoponline’)Drop database shoponlineGocreate?database shoponlineon(Name=’shoponline’, Filename=’f:\SQL\shoponline.mdf’, Size=2,Maxsize=20,Filegrowth=1)Log on(name=’shoponlinelog’, Filename=’f；\SQL\shoponlinelog.ldf’, Size=2,Maxsize=5,Filegrowth=1)Use shoponlineGoExec sp_addlogin u1,u1GoCreate table customer（customerNochar(12)primanykey,passwordvarchar(18)NotNull，customerNamevarchar（12）NotNull，typeNochar（8）NotNull，sexchar（1）Check(sex In(‘M’，‘F’) companyvarchar（20）NotNull，emailvarchar（50）NotNull，IDvarchar(18)NotNull,VIPchar(1))CreatetableVIP（VIPchar（1）primanykey,Discount floatNot Null,)Createtableproduct（ProductNochar（12）primany key，ProductNamevarchar（18）Not Null,typeNochar(12)Not Null,describevarchar(50) Not Null,unitsvarchar(20)Not Null,standardchar(8)Not Null,pricenumericNot Null,)Createtable producer（producerNochar（12）primany key,producerNamevarchar(18)Not Null,addressvarchar(50)Not Null,telephonevarchar(12)Not Null)Createtable protype（protypeNochar(12)primany key,protypeNamevarchar(18)Not Null)Crestetable address(addressNochar(12)primanykey,addressvarchar(20)Not Null,)Createtable order(orderNochar(12)primany key,customerNochar(12)Not Null,productNochar(12)Not Null,addressvarchar(20)Not Null,orderdatedatetimeNot Null,quantitychar(4)Not Null,pricenumericNot Null,billNovarchar(12)primany key,FhdatedatetimeNot Null,Orderstatechar（8）Check（orderstate IN（‘0’，‘1’）），foreign key(customerNo) references customer(customerNo)foreign key(productNo) references product(productNo))Createtablebill（billNochar（12）primany key，orderNochar（12）primany key,foreign key(orderNo) references product(orderNoNo) )Createtablesupport（productNochar（12）primany key，producerNochar（12）primany key,foreign key(producerNo) references producer(producerNo)，foreign key(productNo) references product(productNo) )Createtabletype（CustomerNochar(12)primany key,Typevarch