设备采购管理系统数据库设计展示 PPT课件

1 山东理工大学设备采购管理信息系统 设计者 周无霜王彬洲李雪连 2 目录 数据库需求分析 数据库概念结构设计 数据库逻辑结构设计 数据库物理结构设计 3 一 数据库需求分析 本小组在山东理工大学资源供应管理科采用询问的调查方法 了解到完成正常的设备采购安排需要以下信息 返回目录 4 1 功能需求分析 根据调研需求分析我们得出的基本采购流程为 5 1 功能需求分析 根据调研需求分析我们得出的基本采购流程为 系统实现整个采购过程当中各个信息的录入存储 修改 删除和查询 具体包括 资源供应处信息 采购单信息 供货厂家信息 货物信息 合同信息 验货单信息 使用部门信息 物资领用验货信息 存储 修改 删除和查询 6 2 数据需求 资源供应处名称 电话 邮编 电子邮件 地址 采购单号 日期 货物编号 货物名称 货物单价 货物数量 发货单位 发货单位编号 使用部门 使用部门编号 成交方式 采购人 采购人编号 厂家名称 厂家编号 厂家电话 厂家邮编 厂家电子邮件 厂家地址 货物编号 货物名称 货物单价 货物数量 货物型号 货物规格 验货日期 付款日期 生产厂家 生产厂家编号 附件名称及数量 7 2 数据需求 购货单位 甲方 供货单位 乙方 购货单位 法定代表人 供货单位 法定代表人 鉴定日期 合同编号 单号 验货日期 资产名称 生产厂家 规格 型号 单价 数量 总价 出厂号 附件名称及数量 验收结论 备注 验收人 送货人 职工号 结账方式 部门名称 部门编号 部门管理员 联系电话 电子邮件 单位 验收时间 物资名称 供应商 型号 生产厂家 规格 经费来源 发票号 单价 数量 总价 出厂号 附件名称及数量 验收结论 备注 采购人 使用部门管理员 验收领用人 8 3 数据字典 9 3 数据字典 10 3 数据字典 11 3 数据字典 12 3 数据字典 13 3 数据字典 14 3 数据字典 15 3 数据字典 16 4 数据流程图 4 数据流程图 17 二 数据库概念结构设计 E R图 返回目录 18 二 数据库概念结构设计 局部视图 部门提出采购单 19 UserName UserPhone UserEmail UserAddress UserZipcode 三 数据库逻辑结构设计 CompName CompID CompPhone CompAddress CompZipcode Company User 返回目录 20 ListID LastDate GoodsQuantity GoodsName GoodsID UnitPrice CompName CompID TradeStyle DepartName Buyer EmployeeId 三 数据库逻辑结构设计 OrigianalID GoodsName UnitPrice Standards Type GoodsQuantity CompID ReDatePayDate Anatomy CompName TotalPrice Goods Shoppinglist 21 ACID DepartName Departmanager GoodsName Standards Type UnitPrice Anatomy Source BillID OfferDate Quantity TotalPrice OrigianlID ReConclusion Remarks Recipients 三 数据库逻辑结构设计 ConID UserName CompName UserManager CompManager ConDate ConRemarks Preserveway CompID Contract AC 22 DepartID DepartName Departmanager DepartPhone DepartEmail 三 数据库逻辑结构设计 ReID Redate GoodsName CompName Standards Type UnitPrice GoodsQuantity TotalPrice OrigianlID Anatomy ReConclusion Remarks Deliveryman Receipt Department 23 三 数据库逻辑结构设计 24 三 数据库逻辑结构设计 25 三 数据库逻辑结构设计 26 三 数据库逻辑结构设计 27 三 数据库逻辑结构设计 28 三 数据库逻辑结构设计 29 三 数据库逻辑结构设计 30 三 数据库逻辑结构设计 31 四 数据库物理结构设计 选取SQLServer2005作为DBMS 创建数据库Offer 及表User CreatedatabaseOfferOnprimary name Offer Filename d Offer mdf Logon name Offer log Filename d Offer log ldf CREATETABLE User UserName varchar 20 NOTNULL UserPhone varchar 13 NOTNULL UserEmail varchar 200 NOTNULL UserAddress varchar 200 NOTNULL UserZipcode varchar 6 NOTNULL ON PRIMARY CREATETABLE Company CompName varchar 50 NOTNULL CompID varchar IDENTITY 20 NOTNULL CompPhone varchar 13 NULL CompAddress varchar 200 NOTNULL CompEmail varchar 200 NULL CompZipcode varchar 6 NULL ON PRIMARY CREATETABLE Shoppinglist ListID varchar IDENTITY 20 NOTNULL ListDate datetime NOTNULL GoodsQuantity varchar 20 NOTNULL GoodsName varchar 200 NOTNULL GoodsID varchar 200 NOTNULL UnitPrice varchar 12 NOTNULL CompName varchar 200 NULL CompID varchar 20 NOTNULL TradeStyle varchar 12 NOTNULL DepartName varchar 50 NOTNULL Buyer varchar 12 NOTNULL EmployeeID varchar 9 NOTNULL ON PRIMARY 返回目录 32 四 数据库物理结构设计 CREATETEBLE Goods GoodsName varchar 50 NOTNULL OrigianalID varchar IDENTITY 20 NOTNULL UnitPrice varchar 12 NOTNULL Standards varchar 20 NOTNULL Type varchar 20 NOTNULL GoodsQuantity varchar 50 NOTNULL CompID varchar 20 NOTNULL ReDate datetime NOTNULL PayDate datetime NOTNULL Anatomy varchar 500 NULL CompName varchar 80 NOTNULL TotalPrice varchar 12 NOTNULL ON PRIMARY CREATETABLE AC ACID varchar IDENTITY 20 NOTNULL DepartName varchar 50 NOTNULL Departmanager varchar 12 NOTNULL GoodsName varchar 50 NOTNULL CompName varchar 80 NOTNULL Standards varchar 20 NOTNULL Type varchar 20 NOTNULL UnitPrice varchar 12 NOTNULL Anatomy varchar 80 NULL Source varchar 50 NULL BillID varchar 20 NOTNULL OfferDate datetime NOTNULL Quantity varchar 10 NOTNULL TotalPrice varchar 10 NOTNULL OrinianlID varchar 20 NOTNULL ReConculsion varchar 80 NOTNULL ACRemarks varchar 500 NULL Recipients varchar 12 NOTNULL ON PRIMARY 33 四 数据库物理结构设计 CREATETABLE Contract UserName varchar 20 NOTNULL CompName varchar 50 NOTNULL UserManager varchar 12 NOTNULL CompManager varchar 12 NOTNULL ConDate datetime NOTNULL ConID varchar IDENTITY 20 NOTNULL ConRemarks varchar 500 NULL Preserveway varchar 20 NOTNULL CompID varchar 20 NOTNULL ON PRIMARY CREATETABLE Department DepartName varchar 50 NOTNULL DepartID varchar IDENTITY 20 NOTNULL Departmanager varchar 12 NOTNULL DepartPhone varchar 11 NULL DepartEmail varchar 20 NULL ON PRIMARY CREATETABLE Receipt ReID varchar IDENTITY 20 NOTNULL Redate datetime NOTNULL GoodsName varchar 50 NOTNULL CompName varchar 80 NOTNULL Standards varchar 20 NOTNULL Type varchar 20 NOTNULL UnitPrice varchar 12 NOTNULL GoodsQuantity varchar 50 NOTNULL TotalPrice varchar 12 NOTNULL OrigianlID varchar 20 NOTNULL Anatomy varchar 500 NOTNULL ReConclusion varchar 80 NOTNULL ReRemarks varchar 500 NULL Reperson varchar 12 NOTNULL Deliveryman varchar 12 NOTNULL ON PRIMARY 34 HotTip HowdoIincorporatemylogotoaslidethatwillapplytoalltheotherslides Onthe View menu pointto Master andthenclick SlideMaster or NotesMaster Changeimagestotheoneyoulike thenitwillapplytoalltheotherslides Imageinformationinproduct Image Notetocustomers ThisimagehasbeenlicensedtobeusedwithinthisPowerPointtemplateonly Youmaynotextracttheimageforanyotheruse 35 Clicktoedittitlestyle ContentsThemeGalleryisaDesignDigitalContent ContentsmalldevelopedbyGuildDesignInc YourTextHere YourTextHere YourTextHere YourTextHere Descriptionofthecontents ClicktoaddText ClicktoaddText ClicktoaddText ClicktoaddText ClicktoaddText 36 Clicktoedittitlestyle 4 Descriptionofthebusiness 5 Descriptionofthebusiness 1 Descriptionofthebusiness 2 Descriptionofthebusiness 3 Descriptionofthebusiness ThemeGalleryisaDesignDigitalContent ContentsmalldevelopedbyGuildDesignInc 37 Clicktoedittitlestyle ThemeGalleryisaDesignDigitalContent ContentsmalldevelopedbyGuildDesignInc 38 Clicktoedittitlestyle 2 DescribecontentsforaChartDescriptionofthecompany ssubcontentsDescriptionofthecompany ssubcontents 1 DescribecontentsforaChartDescriptionofthecompany ssubcontentsDescriptionofthecompany ssubcontents Title Title Title Title ChartTitleinhere textinhere textinhere textinhere textinhere 39 Clicktoedittitlestyle Contents01 Contents02 Contents03 Contents04 Contents05 Contents06 0 20 40 60 80 100 18 5 17 5 8 7 23 6 63 6 84 3 ThemeGalleryisaDesignDigitalContent ContentsmalldevelopedbyGuildDesignInc 40 Clicktoedittitlestyle Textinhere Textinhere Textinhere ThemeGalleryisaDesignDigitalContent ContentsmalldevelopedbyGuildDesignInc ThemeGalleryisaDesignDigitalContent ContentsmalldevelopedbyGuildDesignInc 41 Clicktoedittitlestyle ThemeGalleryisaDesignDigitalContent ContentsmalldevelopedbyGuildDesignInc Titleinhere 2 Descriptionofthecompany ssubcontents Describeavisionofcompanyorstrategiccontents 1 Descriptionofthecompany ssubcontents ThemeGalleryisaDesignDigitalContent ContentsmalldevelopedbyGuildDesignInc 42 Clicktoedittitlestyle ClicktoaddText ClicktoaddText ClicktoaddText ContentsThemeGalleryisaDesignDigitalContent ContentsmalldevelopedbyGuildDesignInc 43 Clicktoedittitlestyle Level1 Level2 Level3 Level4 Level5 Descriptionofthecontents Descriptionofthecontents Descriptionofthecontents Descriptionofthecontents Descriptionofthecontents 44 Clicktoedittitlestyle ThemeGalleryisaDesignDigitalContent ContentsmalldevelopedbyGuildDesignInc ThemeGalleryisaDesignDigitalContent ContentsmalldevelopedbyGuildDesignInc ThemeGalleryisaDesignDigitalContent ContentsmalldevelopedbyGuildDesignInc AGroup CGroup BGroup ThemeGalleryisaDesignDigitalContent ContentsmalldevelopedbyGuildDesignInc 45 Clicktoedittitlestyle Describeavisionofcompanyorstrategiccontents Describeavisionofcompanyorstrategiccontents Describeavisionofcompanyorstrategiccontents Describeavisionofcompanyorstrategiccontents Descriptionoftheproducts 46 Clicktoedittitlestyle Textinhere Textinhere Textinhere Textinhere Textinhere Descriptionofthecontents ThemeGalleryisaDesignDigitalContent ContentsmalldevelopedbyGuildDesignInc 47 Clicktoedittitlestyle 50 24 10 16 ProductsDescriptionofthecompany sproducts ServiceDescriptionofthecompany sservice TechnologyDescriptionofthecompany stechnology MarketDescriptionofthecompany smarket 50 24 16 10 48 Clicktoedittitlestyle 2006 Text Text Text 2007 2008 Textinhere Textinhere Textinhere Textinhere Textinhere Textinhere ThemeGalleryisaDesignDigitalContent ContentsmalldevelopedbyGuildDesignInc 49 Clicktoedittitlestyle ThemeGalleryisaDesignDigitalContent ContentsmalldevelopedbyGuildDesignInc Yourtextinhere Yourtextinhere Yourtextinhere AddyourtextinhereYourtextinhereYourtextinhereYourtextinhere AddyourtextinhereYourtextinhereYourtextinhereYourtextinhere AddyourtextinhereYourtextinhereYourtextinhereYourtextinhere 50 Clicktoedittitlestyle Textinhere ThemeGalleryisaDesignDigitalContent ContentsmalldevelopedbyGuildDesignInc Textinhere ThemeGalleryisaDesignDigitalContent ContentsmalldevelopedbyGuildDesignInc Textinhere ThemeGalleryisaDesignDigitalContent ContentsmalldevelopedbyGuildDesignInc Textinhere Textinhere Textinhere 51 Clicktoedittitlestyle Textinhere Titleinhere Textinhere Textinhere 2005 2006 2007 2008 DescriptionofthecontentsDescriptionofthecontents DescriptionofthecontentsDescriptionofthecontents DescriptionofthecontentsDescriptionofthecontents DescriptionofthecontentsDescriptionofthecontents ThemeGalleryisaDesignDigitalContent ContentsmalldevelopedbyGuildDesignInc 52 Clicktoedittitlestyle Textinhere Textinhere Textinhere ThemeGalleryisaDesignDigitalContent ContentsmalldevelopedbyGuildDesignInc 53 Clicktoedittitlestyle Addyourtextinhere Addyourtextinhere Addyourtextinhere Addyourtextinhere Addyourtextinhere 54 Clicktoedittitlestyle 10 60 30 YourtextinhereYourtextinhereYourtextinhereYourtextinhere Textinhere YourtextinhereYourtextinhere Textinhere YourtextinhereYourtextinhereYourtextinhereYourtextinhere Textinhere ClicktoaddText Theme