?
商品信息：
顾客信息：
账单信息：
数据库课程设计--“茶咖啡”销售管理系统总结(二)
,BILL_unitprice ,MemberID, Customers_num)
values('2013010101','20140101','100','50','卡布奇诺','55','Null','2014110106')
insert into BILL(BILL_num, BILL_time,BILL_paymoney ,BILL_summoney, BILL_goodstype ,BILL_unitprice ,MemberID, Customers_num)
values('2013010102','20140101','100','50','卡布奇诺','55','Null','2014110106')
insert into Member(MemberID,MemberNAme,MemberSex,Memberphone,BILL_num)
values ('20140101001','李一','男','15832578651','2014010101')
insert into Member(MemberID,MemberNAme,MemberSex,Memberphone,BILL_num)
values ('20140202002','李二','女','15832578652','2014010102')
insert into Member(MemberID,MemberNAme,MemberSex,Memberphone,BILL_num)
values ('20140310003','李三','男','15832578653','2014010103')
insert into Member(MemberID,MemberNAme,MemberSex,Memberphone,BILL_num)
values ('20140404004','李四','女','15832578654','2014010104')
insert into Member(MemberID,MemberNAme,MemberSex,Memberphone,BILL_num)
values ('20141001005','李五','男','15832578655','2014010105')
insert into Member(MemberID,MemberNAme,MemberSex,Memberphone,BILL_num)
values ('20141101006','李六','女','15832578656','2014010106')
insert into Goods(Goods_num ,Goods_name ,Goods_stock ,BILL_num )
values('1','蓝山','10','2014010101')
insert into Goods(Goods_num ,Goods_name ,Goods_stock ,BILL_num )
values('2','炭烧','10','2014010102')
insert into Goods(Goods_num ,Goods_name ,Goods_stock ,BILL_num )
values('3','美式','10','2014010103')
insert into Goods(Goods_num ,Goods_name ,Goods_stock ,BILL_num )
values('4','拿铁','10','2014010104')
insert into Goods(Goods_num ,Goods_name ,Goods_stock ,BILL_num )
values('5','摩卡','10','2014010105')
insert into Goods(Goods_num ,Goods_name ,Goods_stock ,BILL_num )
values('6','卡布奇诺','10','2014010106')
insert into Customers( Customers_num,Customers_name,BILL_num )
values ('01','王一','2013010101')
insert into Customers( Customers_num,Customers_name,BILL_num )
values ('02','王二','2013010102')
实验结果：会员信息：