文件名称:drinks
- 所属分类:
- SQL Server数据库
- 资源属性:
- [WORD]
- 上传时间:
- 2012-11-26
- 文件大小:
- 265kb
- 下载次数:
- 0次
- 提 供 者:
- zhangz*******
- 相关连接:
- 无
- 下载说明:
- 别用迅雷下载,失败请重下,重下不扣分!
介绍说明--下载内容均来自于网络,请自行研究使用
饮料批发系统,以批发商为中心实体,其他实体有供应商,客户,饮料。关系实体有供应,批发。
分别建立Supply,Wholesale,Wholesaler,Supplier,Drinks,Customer六张表格。一个关系主外键约束图。在表Supply中的Squantity和Sprice列中建立输入不为0的约束。分别建立了与六张表对应的视图,及表间关系视图,生产商与饮料,供应饮料给批发商,批发饮料给客户共九张视图。
-Beverage wholesale system to wholesalers as the central entity, other entities have suppliers, customers, beverages. Relationship between the entities has the supply, wholesale. Established Supply, Wholesale, Wholesaler, Supplier, Drinks, Customer Form 6. A relationship between the main foreign key constraint graph. Supply in the table of Squantity and Sprice out to create input bound to 0. Were set up six tables and the corresponding view, and the relationship between form view, and beverage manufacturers, suppliers beverages to wholesalers, wholesale beverages to the customer a total of nine views.
分别建立Supply,Wholesale,Wholesaler,Supplier,Drinks,Customer六张表格。一个关系主外键约束图。在表Supply中的Squantity和Sprice列中建立输入不为0的约束。分别建立了与六张表对应的视图,及表间关系视图,生产商与饮料,供应饮料给批发商,批发饮料给客户共九张视图。
-Beverage wholesale system to wholesalers as the central entity, other entities have suppliers, customers, beverages. Relationship between the entities has the supply, wholesale. Established Supply, Wholesale, Wholesaler, Supplier, Drinks, Customer Form 6. A relationship between the main foreign key constraint graph. Supply in the table of Squantity and Sprice out to create input bound to 0. Were set up six tables and the corresponding view, and the relationship between form view, and beverage manufacturers, suppliers beverages to wholesalers, wholesale beverages to the customer a total of nine views.
相关搜索: 渚涘簲鍟?p=
(系统自动生成,下载前可以参看下载内容)
下载文件列表
数据库文件
..........\drinks_Data.MDF
..........\drinks_Log.LDF
饮料批发系统.doc
..........\drinks_Data.MDF
..........\drinks_Log.LDF
饮料批发系统.doc