"小型自选商场综合管理数据库设计及分析步骤"

2 下载量 5 浏览量 更新于2023-12-21 1 收藏 423KB DOC 举报
"Management Information Systems (MIS) is a specialized course focused on the design and implementation of comprehensive standard management systems for small-scale self-selected markets. The course involves the development of a database design document for a Small-Scale Self-Selected Market Integrated Management System. The database design document encompasses various steps and processes to create a comprehensive and efficient management system for small-scale markets. The steps involved in this process include conceptual model design, logical model design, and analysis of the self-selected market management system. The conceptual model design consists of the identification of entity sets and their attributes, as well as the determination of keys and relationships. This step is essential in laying the foundation for the database design, as it forms the basis for the subsequent logical model design. The logical model design involves transforming the conceptual model into initial relational schemas, normalizing the initial relational schemas, and defining the relationship patterns. In addition to the model design, the course also covers the analysis of the self-selected market management system. This analysis includes the organization structure design, business processes (such as procurement, sales, inventory management, and financial processes), data processes (using top-down, inside-out, outside-in, and layer-by-layer structured analysis), and the creation of a data dictionary to define the data flows, storage, processing, and elements. Overall, the course aims to equip students with the knowledge and skills to design, develop, and implement efficient management information systems for small-scale self-selected markets. Through the completion of the database design document, students gain practical experience in applying theoretical concepts to real-world scenarios, thus preparing them for careers in MIS and database management."
2023-05-31 上传
试验二 一、小型自选商场组织结构图 二、业务步骤图 (一)采购步骤图 (二)销售业务步骤图 (三)入库业务步骤图 (四)出库业务步骤图 三、数据步骤图 (一)顶层数据步骤图 (二)0层数据步骤图 (三)子系统数据图 1. 人事子系统 2. 采购子系统 3. 销售子系统 4. 仓库存放子系统 四、数据字典 (一)人事系统 1. 数据流 "数据流名 "通知 " " 别名 "无 " "组成 "姓名+职员职位+培训时间+培训内容+单位盖章+通知时间 " "起源 "1.2培训职员 " "去向 "1.3人事分配 " "数据量 "0.1次/天 " "高峰值 "1次/天 " "数据流名 "解聘信 " " 别名 "无 " "组成 "姓名+解聘原由+解聘赔偿金+单位盖章+解聘日期 " "起源 "1.3人事分配 " "去向 "1.4解聘职员 " "数据量 "0.05次/天 " "高峰值 "0.2次/天 " 2. 数据存放 "文件名 "招聘职员通知书 " "别名 "无 " "组成 "招聘原由+招聘人数+招聘要求 " "组织 "按各个部门所需人数从大到小排列 " "存取要求 "无 " "关键字 "部门和人数 " "文件名 "培训职员通知书 " "别名 "无 " "组成 "培训原由+培训人数+培训要求+单位盖章 " "组织 "按各个部门所需人数从大到小排列 " "存取要求 "无 " "关键字 "部门和人数 " "别名 "无 " "组成 "部门名称+职员姓名+转换部门原因+单位盖章 " "组织 "按各个部门变感人数从大到小排列 " "存取要求 "无 " "关键字 "部门和人数 " "文件名 "解聘职员通知书 " "别名 "无 " "组成 "解聘原由+解聘人数+单位盖章 " "组织 "按各个部门所解聘人数从大到小排列 " "存取要求 "无 " "关键字 "部门和人数 " 3. 数据处理 "加工名 "招聘职员 " "编号 "1.1 " "加工激活条件 "得到需要招聘职员通知 " "加工逻辑 "1.4解聘职员 " "实施频率 "随时 " "加工名 "培训职员 " "编号 "1.2 " "加工激活条件 "得到需要对职员进行培训通知 " "加工逻辑 "1.1招聘职员 " "实施频率 "随时 " "加工名 "人事分配 " "编号 "1.3 " "加工激活条件 "职员培训后需要安排到各个部门 " "加工逻辑 "1.2培训职员 " "实施频率 "随时 " (二)销售系统 1、数据存放 "文件名 "消费清单 " "别名 "无 " "组成 "消费数据+消费金额+消费数量 " "组织 "按消费清单编号从小到大排列 " "存取要求 "无 " "关键字 "消费清单编号 " "文件名 "商品登记单 " "别名 "无 " "组成 "商品条码+商品数量+销售员信息 " "组织 "按商品登记编号从小到大排列 " "存取要求 "无 " "关键字 "商品登记编号 " "文件名 "售货单 " "别名 "无 " "组成 "销售商品数量+商品单价+商品条码 " "组织 "按商品录入前后次序排列 " "存取要求 "无 " "关键字 "售货单编号 " "文件名 "销售报表 " "别名 "无 " "组成 "日期+销售员信息+销售数量+销售金额 " "组织 "按商品录入前后次序排列 " "存取要求 "无 " "关键字 "销售报表编号 " "文件名 "订货单 " "别名 "无 " "组成 "商品数量+商品条码 " "组织 "按订货清单编号从小到大排列 " "存取要求 "无 " "关键字 "订货清单编号 " 2、数据处理 "加工名 "销售登记 " "编号 "2.1 " "加工激活条件 " " "加工逻辑 "2.4库存更新 " "实施频率 "随时 " "加工名 "销售核实 " "编号 "2.2 " "加工激活条件 " " "加工逻辑 "2.1销售登记 " "实施频率 "随时 " "加工名 "销售统计 " "编号 "2.3 " "加工激活条件 " " "加工逻辑 "2.2销售核实 " "实施频率 "随时 " "加工名 "库存更新 " "编号 "2.4 " "加工激活条件 " " "加工逻辑 "2.3销售统计 " "实施频率 "随时 " (三)库存系统 1、数据流 "数据流名 "出库单 " " 别名 "商品出库单 " "组成 "(仓库号)+类型+商品编号+单价+数量+总价+货价累计+出 " " "库日期 " "起源 "4.2按商品类型汇总并发通知 " "去向 "仓库管理员 " "数据量 "30次/天 " "高峰值 "100次/天 " "数据流名 "出库通知 " " 别名 "商品出库通知 " "组成 "(仓库号)+类型+商品编号+单价+数量+总价+货价累计+出 " " "库日期 " "起源 "仓库管理员 " "去向 "