小型商场综合管理系统数据库设计

[{"title":"（ 34 个子文件 841KB ） 小型商场综合管理系统数据库设计","children":[{"title":"SmallSuperMarket数据库","children":[{"title":"存储过程","children":[{"title":"创建存储过程","children":[{"title":"存储过程6：查询某位销售员的基本信息.sql <span style='color:#111;'> 133B </span>","children":null,"spread":false},{"title":"存储过程4：查询某商品的日销售量.sql <span style='color:#111;'> 296B </span>","children":null,"spread":false},{"title":"存储过程7：查询某位销售员的月销售明细（业绩）.sql <span style='color:#111;'> 373B </span>","children":null,"spread":false},{"title":"存储过程5：查询某商品的月销售明细.sql <span style='color:#111;'> 252B </span>","children":null,"spread":false},{"title":"存储过程1：查询某商品库存.sql <span style='color:#111;'> 121B </span>","children":null,"spread":false},{"title":"存储过程2：查询某商品的月供货量.sql <span style='color:#111;'> 251B </span>","children":null,"spread":false},{"title":"存储过程3：查询某商品的厂商信息.sql <span style='color:#111;'> 204B </span>","children":null,"spread":false},{"title":"存储过程8：根据商品号、数量，查询顾客的消费清单.sql <span style='color:#111;'> 353B </span>","children":null,"spread":false}],"spread":true},{"title":"触发存储过程","children":[{"title":"触发存储过程7：销售员号为BB002的销售员的月销售明细（业绩）.sql <span style='color:#111;'> 48B </span>","children":null,"spread":false},{"title":"触发存储过程8：购买商品号为0A001，数量为2的顾客的消费清单.sql <span style='color:#111;'> 48B </span>","children":null,"spread":false},{"title":"触发存储过程1：商品号为0A001.sql <span style='color:#111;'> 44B </span>","children":null,"spread":false},{"title":"触发存储过程6：销售员号为DD004的销售员基本信息.sql <span style='color:#111;'> 44B </span>","children":null,"spread":false},{"title":"触发存储过程3：商品号为0A001的商品的厂商信息.sql <span style='color:#111;'> 44B </span>","children":null,"spread":false},{"title":"触发存储过程4：商品号为0A001的商品在2009-5-1这天的日销售量.sql <span style='color:#111;'> 55B </span>","children":null,"spread":false},{"title":"触发存储过程2：商品号为0B002的商品5月份的供货量.sql <span style='color:#111;'> 48B </span>","children":null,"spread":false},{"title":"触发存储过程5：商品号为0C003的商品5月份的销售明细.sql <span style='color:#111;'> 48B </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"触发器","children":[{"title":"创建触发器","children":[{"title":"触发器2：从供货表中动态刷新商品库存.sql <span style='color:#111;'> 646B </span>","children":null,"spread":false},{"title":"触发器1：从销售表中动态刷新商品库存.sql <span style='color:#111;'> 437B </span>","children":null,"spread":false}],"spread":true},{"title":"触发触发器","children":[{"title":"触发触发器1和2：在销售表、供货表中同时添加数据，刷新商品库存.sql <span style='color:#111;'> 185B </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"SmallSuperMarket_log.ldf <span style='color:#111;'> 1024.00KB </span>","children":null,"spread":false},{"title":"SmallSuperMarket的E-R图.er1 <span style='color:#111;'> 33.93KB </span>","children":null,"spread":false},{"title":"SmallSuperMarket数据字典.xls <span style='color:#111;'> 16.00KB </span>","children":null,"spread":false},{"title":"查询","children":[{"title":"查询9：商品号为0B002的商品的供货明细情况.sql <span style='color:#111;'> 229B </span>","children":null,"spread":false},{"title":"查询3：商品号为0C003的商品的月销售量.sql <span style='color:#111;'> 204B </span>","children":null,"spread":false},{"title":"查询8：商品号为0C003的商品的月销售利润.sql <span style='color:#111;'> 273B </span>","children":null,"spread":false},{"title":"查询1：商品号为0A001的商品的厂商情况.sql <span style='color:#111;'> 152B </span>","children":null,"spread":false},{"title":"查询5：销售员号为BB002的销售员的月销售业绩.sql <span style='color:#111;'> 220B </span>","children":null,"spread":false},{"title":"查询7：顾客号为A0001的顾客的月消费清单.sql <span style='color:#111;'> 310B </span>","children":null,"spread":false},{"title":"查询6：在2009-5-1购买过商品的顾客所有信息及其购买商品的商品名和数量.sql <span style='color:#111;'> 211B </span>","children":null,"spread":false},{"title":"查询2：商品号为0A001的商品的日销售量.sql <span style='color:#111;'> 180B </span>","children":null,"spread":false},{"title":"查询4：商品号为0B002的商品的月供货量.sql <span style='color:#111;'> 204B </span>","children":null,"spread":false}],"spread":true},{"title":"SmallSuperMarket的E-R图.BK1 <span style='color:#111;'> 33.88KB </span>","children":null,"spread":false},{"title":"SmallSuperMarket.mdf <span style='color:#111;'> 3.00MB </span>","children":null,"spread":false},{"title":"SmallSuperMarket管理系统需求分析报告.doc <span style='color:#111;'> 46.27KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}]