范文一:数据库概要设计
卷号
卷内编号
密级
数据库概要设计说明书
项目名称: 部门级文档管理系统
项目编号:
编写人员:
编写日期: 2004年7月19日
审批人员: __
审批日期: __
appearance of the weld appearance quality technical requirements of the project must not have a molten metal stream does not melt the base metal to weld, weld seam and heat-affected zone surface must not have cracks, pores, defects such as crater and ash, surface smoothing, weld and base metal should be evenly smooth transition. Width 2-3 mm from the edge of weld Groove. Surface reinforcement should be less than or equal to 1 + 0.2 times the slope edge width, and should not be greater than 4 mm. Depth of undercut should be less than or equal to 0.5 mm, total length of the welds on both sides undercut not exceed 10% of the weld length, and long continuous should not be greater than 100 mm. Wrong side should be less than or at 0.2T, and should not be greater than 2 mm (wall thickness mm t) incomplete or not allow 7.5 7.5.1 installation quality process standards of the electrical enclosure Cabinet surface is clean, neat, no significant phenomenon of convex, close to nature, close the door. 7.5.2 Cabinet Cabinet face paints no paint, returned to rusted, consistent color. 7.5.3 uniform indirect gap from top to bottom, slot width <1.5mm 7.5.4="" adjacent="" cabinet="" surface="" roughness="" is="" 0.="" 7.5.5="" the="" cabinets="" firmly="" fixed,="" crafts="" beautiful.="" 7.5.6="" cabinet="" surface="" gauge,="" switch="" cabinet="" mark="" clear,="" neat,="" firm="" paste.="" 7.5.7="" terminal="" row="" of="" neat,="" is="" reliable,="" the="" appearance="" is="" clean="" and="" not="" damaged.="" 7.5.8="" cables="" neat="" and="" clean,="" solid="" binding,="" binding="" process="" in="" appearance.="" 7.5.9="" the="" first="" cable="" production="" firm,="" crafts="" beautiful,="" clear="" signage="" does="" not="" fade.="" 7.5.10="" fireproof="" plugging="" tight,="" no="" cracks="" and="" pores.="" 7.6="" 7.6.1="" of="" the="" standard="" electrical="" wiring="" quality="" technology="" cable="" a,="" the="" multi-core="" wire="" bunch="" arrangement="" should="" be="" parallel="" to="" each="" other,="" horizontal="" wire="" harness="" or="" wire="" should="" be="" perpendicular="" to="" the="" longitudinal="" multi-core="" wire="" bunch.="" the="" distance="" between="" the="" wire="" harness="" and="" wire="" harness="" symmetry,="" and="" as="" close="" as="" possible.="" b-core="" wiring="" harness="" into="" round,="" multi-core="" wire="" bunch="" used="" g="" wire="" binding,="">1.5mm>
历史修改记录
版本号 修改人/日期 摘要 审定人/日期
appearance of the weld appearance quality technical requirements of the project must not have a molten metal stream does not melt the base metal to weld, weld seam and heat-affected zone surface must not have cracks, pores, defects such as crater and ash, surface smoothing, weld and base metal should be evenly smooth transition. Width 2-3 mm from the edge of weld Groove. Surface reinforcement should be less than or equal to 1 + 0.2 times the slope edge width, and should not be greater than 4 mm. Depth of undercut should be less than or equal to 0.5 mm, total length of the welds on both sides undercut not exceed 10% of the weld length, and long continuous should not be greater than 100 mm. Wrong side should be less than or at 0.2T, and should not be greater than 2 mm (wall thickness mm t) incomplete or not allow 7.5 7.5.1 installation quality process standards of the electrical enclosure Cabinet surface is clean, neat, no significant phenomenon of convex, close to nature, close the door. 7.5.2 Cabinet Cabinet face paints no paint, returned to rusted, consistent color. 7.5.3 uniform indirect gap from top to bottom, slot width <1.5mm 7.5.4="" adjacent="" cabinet="" surface="" roughness="" is="" 0.="" 7.5.5="" the="" cabinets="" firmly="" fixed,="" crafts="" beautiful.="" 7.5.6="" cabinet="" surface="" gauge,="" switch="" cabinet="" mark="" clear,="" neat,="" firm="" paste.="" 7.5.7="" terminal="" row="" of="" neat,="" is="" reliable,="" the="" appearance="" is="" clean="" and="" not="" damaged.="" 7.5.8="" cables="" neat="" and="" clean,="" solid="" binding,="" binding="" process="" in="" appearance.="" 7.5.9="" the="" first="" cable="" production="" firm,="" crafts="" beautiful,="" clear="" signage="" does="" not="" fade.="" 7.5.10="" fireproof="" plugging="" tight,="" no="" cracks="" and="" pores.="" 7.6="" 7.6.1="" of="" the="" standard="" electrical="" wiring="" quality="" technology="" cable="" a,="" the="" multi-core="" wire="" bunch="" arrangement="" should="" be="" parallel="" to="" each="" other,="" horizontal="" wire="" harness="" or="" wire="" should="" be="" perpendicular="" to="" the="" longitudinal="" multi-core="" wire="" bunch.="" the="" distance="" between="" the="" wire="" harness="" and="" wire="" harness="" symmetry,="" and="" as="" close="" as="" possible.="" b-core="" wiring="" harness="" into="" round,="" multi-core="" wire="" bunch="" used="" g="" wire="" binding,="">1.5mm>
湖北国际软件外包人才培养基地 数据库概要设计说明书
1引言 .............................................. 4 1.1编写目的 ....................................................... 4 1.2背景 ........................................................... 4 1.3术语定义 ....................................................... 4 1.4参考资料 ....................................................... 4 2总体设计 .......................................... 4 2.1运行环境。 ..................................................... 4 3结构设计 .......................................... 5 3.1数据库ER模型(建议用PowerDesigner或Visio工具) .............. 5
3.2数据库表 ....................................................... 5
3.2.1 Popedom ......................................5
3.2.2 Organize .....................................5
3.2.3 User_Type ....................................6
3.2.4 Path.........................................6
3.2.5 User_Info ....................................6
3.2.6 Document_Electron ............................6
3.2.7 Document_Bunf ................................7
3.2.8 Log .........................................7
3.2.9 Data_Backup ..................................8
3.2.10 Templet .....................................8
3.2.11模板表 ......................................8
- 3 - appearance of the weld appearance quality technical requirements of the project must not have a molten metal stream does not melt the base metal to weld, weld seam and heat-affected zone surface must not have cracks, pores, defects such as crater and ash, surface smoothing, weld and base metal should be evenly smooth transition. Width 2-3 mm from the edge of weld Groove. Surface reinforcement should be less than or equal to 1 + 0.2 times the slope edge width, and should not be greater than 4 mm. Depth of undercut should be less than or equal to 0.5 mm, total length of the welds on both sides undercut not exceed 10% of the weld length, and long continuous should not be greater than 100 mm. Wrong side should be less than or at 0.2T, and should not be greater than 2 mm (wall thickness mm t) incomplete or not allow 7.5 7.5.1 installation quality process standards of the electrical enclosure Cabinet surface is clean, neat, no significant phenomenon of convex, close to nature, close the door. 7.5.2 Cabinet Cabinet face paints no paint, returned to rusted, consistent color. 7.5.3 uniform indirect gap from top to bottom, slot width <1.5mm 7.5.4="" adjacent="" cabinet="" surface="" roughness="" is="" 0.="" 7.5.5="" the="" cabinets="" firmly="" fixed,="" crafts="" beautiful.="" 7.5.6="" cabinet="" surface="" gauge,="" switch="" cabinet="" mark="" clear,="" neat,="" firm="" paste.="" 7.5.7="" terminal="" row="" of="" neat,="" is="" reliable,="" the="" appearance="" is="" clean="" and="" not="" damaged.="" 7.5.8="" cables="" neat="" and="" clean,="" solid="" binding,="" binding="" process="" in="" appearance.="" 7.5.9="" the="" first="" cable="" production="" firm,="" crafts="" beautiful,="" clear="" signage="" does="" not="" fade.="" 7.5.10="" fireproof="" plugging="" tight,="" no="" cracks="" and="" pores.="" 7.6="" 7.6.1="" of="" the="" standard="" electrical="" wiring="" quality="" technology="" cable="" a,="" the="" multi-core="" wire="" bunch="" arrangement="" should="" be="" parallel="" to="" each="" other,="" horizontal="" wire="" harness="" or="" wire="" should="" be="" perpendicular="" to="" the="" longitudinal="" multi-core="" wire="" bunch.="" the="" distance="" between="" the="" wire="" harness="" and="" wire="" harness="" symmetry,="" and="" as="" close="" as="" possible.="" b-core="" wiring="" harness="" into="" round,="" multi-core="" wire="" bunch="" used="" g="" wire="" binding,="">1.5mm>
1引言
1.1编写目的
目的:描述部门文档管理系统数据库的概要设计。
预期读者:项目经理,系统分析员。
1.2背景
数据库名称:DocumentManage
软件系统名称:部门级文档管理系统
1.3术语定义
1.4参考资料
需求分析说明书
2总体设计
2.1运行环境。
Pentium III 600MHz 以上
256MB RAM
Windows 2000/NT 4.0 Server
Microsoft SQL Server 2000
磁盘设备空间>10G
appearance of the weld appearance quality technical requirements of the project must not have a molten metal stream does not melt the base metal to weld, weld seam and heat-affected zone surface must not have cracks, pores, defects such as crater and ash, surface smoothing, weld and base metal should be evenly smooth transition. Width 2-3 mm from the edge of weld Groove. Surface reinforcement should be less than or equal to 1 + 0.2 times the slope edge width, and should not be greater than 4 mm. Depth of undercut should be less than or equal to 0.5 mm, total length of the welds on both sides undercut not exceed 10% of the weld length, and long continuous should not be greater than 100 mm. Wrong side should be less than or at 0.2T, and should not be greater than 2 mm (wall thickness mm t) incomplete or not allow 7.5 7.5.1 installation quality process standards of the electrical enclosure Cabinet surface is clean, neat, no significant phenomenon of convex, close to nature, close the door. 7.5.2 Cabinet Cabinet face paints no paint, returned to rusted, consistent color. 7.5.3 uniform indirect gap from top to bottom, slot width <1.5mm 7.5.4="" adjacent="" cabinet="" surface="" roughness="" is="" 0.="" 7.5.5="" the="" cabinets="" firmly="" fixed,="" crafts="" beautiful.="" 7.5.6="" cabinet="" surface="" gauge,="" switch="" cabinet="" mark="" clear,="" neat,="" firm="" paste.="" 7.5.7="" terminal="" row="" of="" neat,="" is="" reliable,="" the="" appearance="" is="" clean="" and="" not="" damaged.="" 7.5.8="" cables="" neat="" and="" clean,="" solid="" binding,="" binding="" process="" in="" appearance.="" 7.5.9="" the="" first="" cable="" production="" firm,="" crafts="" beautiful,="" clear="" signage="" does="" not="" fade.="" 7.5.10="" fireproof="" plugging="" tight,="" no="" cracks="" and="" pores.="" 7.6="" 7.6.1="" of="" the="" standard="" electrical="" wiring="" quality="" technology="" cable="" a,="" the="" multi-core="" wire="" bunch="" arrangement="" should="" be="" parallel="" to="" each="" other,="" horizontal="" wire="" harness="" or="" wire="" should="" be="" perpendicular="" to="" the="" longitudinal="" multi-core="" wire="" bunch.="" the="" distance="" between="" the="" wire="" harness="" and="" wire="" harness="" symmetry,="" and="" as="" close="" as="" possible.="" b-core="" wiring="" harness="" into="" round,="" multi-core="" wire="" bunch="" used="" g="" wire="" binding,="">1.5mm>
湖北国际软件外包人才培养基地 数据库概要设计说明书 3结构设计
3.1数据库ER模型(建议用PowerDesigner或Visio工具)
3.2数据库表
3.2.1 Popedom
【中文含义】 权限表
字段名称 数据类型及长度 允许为空 中文说明 备注 Popedom_Id int NO 权限ID 主键 Popedom_Name varchar(100) NO 权限名称
Remark varchar(1000) YES 备注 注: 数据字典。
3.2.2 Organize
【中文含义】 组织表
字段名称 数据类型及长度 允许为空 中文说明 备注 Organize_Id int NO 组织ID 主键 Organize_Name varchar(100) NO 组织名称 Up_Organize_Id int NO 上级组织ID 外键
Remark Varchar(1000) YES 备注 appearance of the weld appearance quality technical requirements of the project must not have a molten metal stream does not me - 5 - lt the base metal to weld, weld seam and heat-affected zone surface must not have cracks, pores, defects such as crater and ash, surface smoothing, weld and base metal should be evenly smooth transition. Width 2-3 mm from the edge of weld Groove. Surface reinforcement should be less than or equal to 1 + 0.2 times the slope edge width, and should not be greater than 4 mm. Depth of undercut should be less than or equal to 0.5 mm, total length of the welds on both sides undercut not exceed 10% of the weld length, and long continuous should not be greater than 100 mm. Wrong side should be less than or at 0.2T, and should not be greater than 2 mm (wall thickness mm t) incomplete or not allow 7.5 7.5.1 installation quality process standards of the electrical enclosure Cabinet surface is clean, neat, no significant phenomenon of convex, close to nature, close the door. 7.5.2 Cabinet Cabinet face paints no paint, returned to rusted, consistent color. 7.5.3 uniform indirect gap from top to bottom, slot width <1.5mm 7.5.4="" adjacent="" cabinet="" surface="" roughness="" is="" 0.="" 7.5.5="" the="" cabinets="" firmly="" fixed,="" crafts="" beautiful.="" 7.5.6="" cabinet="" surface="" gauge,="" switch="" cabinet="" mark="" clear,="" neat,="" firm="" paste.="" 7.5.7="" terminal="" row="" of="" neat,="" is="" reliable,="" the="" appearance="" is="" clean="" and="" not="" damaged.="" 7.5.8="" cables="" neat="" and="" clean,="" solid="" binding,="" binding="" process="" in="" appearance.="" 7.5.9="" the="" first="" cable="" production="" firm,="" crafts="" beautiful,="" clear="" signage="" does="" not="" fade.="" 7.5.10="" fireproof="" plugging="" tight,="" no="" cracks="" and="" pores.="" 7.6="" 7.6.1="" of="" the="" standard="" electrical="" wiring="" quality="" technology="" cable="" a,="" the="" multi-core="" wire="" bunch="" arrangement="" should="" be="" parallel="" to="" each="" other,="" horizontal="" wire="" harness="" or="" wire="" should="" be="" perpendicular="" to="" the="" longitudinal="" multi-core="" wire="" bunch.="" the="" distance="" between="" the="" wire="" harness="" and="" wire="" harness="" symmetry,="" and="" as="" close="" as="" possible.="" b-core="" wiring="" harness="" into="" round,="" multi-core="" wire="" bunch="" used="" g="" wire="" binding,="">1.5mm>
注: 数据字典。
包括了每个组织的上级组织的信息,如果是最高级组织,上级则为自己,其他必须填
写上级。
3.2.3 User_Type
【中文含义】 组织表
字段名称 数据类型及长度 允许为空 中文说明 备注 User_Type_Id int NO 用户类型ID 主键 User_Type_Name varchar(100) NO 用户类型名称
Remark Varchar(1000) YES 备注 注: 数据字典
3.2.4 Path
【中文含义】 路径表
字段名称 数据类型及长度 允许为空 中文说明 备注 Path_Id int NO 路径ID 主键,自动增1
Path varchar(500) NO 路径
Remark Varchar(1000) YES 备注 注: 服务器上存放文件的路径。
3.2.5 User_Info
【中文含义】 用户信息表
字段名称 数据类型及长度 允许为空 中文说明 备注 User_Info_Id varchar(100) NO 用户ID 主键 User_Name varchar(100) NO 用户姓名 Pass_Word varchar(100) NO 登陆密码 Disk_Space_Sum bigint NO 最大上传空间 Disk_Space_Ovebigint NO 剩余上传空间
rplus
Organize_Id int YES 组织ID 外键 User_Type_Id int NO 用户类型 外健 Popedom_Id int NO 权限ID 外健
Remark varchar(1000) YES 备注 注: UserInfoId用来和外部连接,做为别的表的外键和唯一标识符,是登陆帐号。
并且规定了最大上传空间和剩余上传空间,建立用户时必须规定该用户最大的上
传空间(累积),当用户上传了数据时,剩余空间减少,标识用户类型和用户权限。
3.2.6 Document_Electron 【中文含义】 文档信息表_电子版
字段名称 数据类型及长度 允许为空 中文说明 备注 Document_Electvarchar(100) NO 文档ID 主键
ron_Id
appearance of the weld appearance quality technical requirements of the project must not have a molten metal stream does not melt the base metal to weld, weld seam and heat-affected zone surface must not have cracks, pores, defects such as crater and ash, surface smoothing, weld and base metal should be evenly smooth transition. Width 2-3 mm from the edge of weld Groove. Surface reinforcement should be less than or equal to 1 + 0.2 times the slope edge width, and should not be greater than 4 mm. Depth of undercut should be less than or equal to 0.5 mm, total length of the welds on both sides undercut not exceed 10% of the weld length, and long continuous should not be greater than 100 mm. Wrong side should be less than or at 0.2T, and should not be greater than 2 mm (wall thickness mm t) incomplete or not allow 7.5 7.5.1 installation quality process standards of the electrical enclosure Cabinet surface is clean, neat, no significant phenomenon of convex, close to nature, close the door. 7.5.2 Cabinet Cabinet face paints no paint, returned to rusted, consistent color. 7.5.3 uniform indirect gap from top to bottom, slot width <1.5mm 7.5.4="" adjacent="" cabinet="" surface="" roughness="" is="" 0.="" 7.5.5="" the="" cabinets="" firmly="" fixed,="" crafts="" beautiful.="" 7.5.6="" cabinet="" surface="" gauge,="" switch="" cabinet="" mark="" clear,="" neat,="" firm="" paste.="" 7.5.7="" terminal="" row="" of="" neat,="" is="" reliable,="" the="" appearance="" is="" clean="" and="" not="" damaged.="" 7.5.8="" cables="" neat="" and="" clean,="" solid="" binding,="" binding="" process="" in="" appearance.="" 7.5.9="" the="" first="" cable="" production="" firm,="" crafts="" beautiful,="" clear="" signage="" does="" not="" fade.="" 7.5.10="" fireproof="" plugging="" tight,="" no="" cracks="" and="" pores.="" 7.6="" 7.6.1="" of="" the="" standard="" electrical="" wiring="" quality="" technology="" cable="" a,="" the="" multi-core="" wire="" bunch="" arrangement="" should="" be="" parallel="" to="" each="" other,="" horizontal="" wire="" harness="" or="" wire="" should="" be="" perpendicular="" to="" the="" longitudinal="" multi-core="" wire="" bunch.="" the="" distance="" between="" the="" wire="" harness="" and="" wire="" harness="" symmetry,="" and="" as="" close="" as="" possible.="" b-core="" wiring="" harness="" into="" round,="" multi-core="" wire="" bunch="" used="" g="" wire="" binding,="">1.5mm>
湖北国际软件外包人才培养基地 数据库概要设计说明书 Document_Name varchar(100) NO 文档名称 Document_Creatdatetime NO 创建文档日期
e_Time
Document_Changdatetime YES 文档修改时间
e_Time
Document_Size int NO 文档大小 Document_Editivarchar(100) NO 文挡版本
on
User_Info_Id varchar(100) NO 用户ID 外键
Remark varchar(1000) YES 备注 Templet_Id int YES 模板ID 外健 注: 电子版文档,上传了文件后,在此表记录该文件的文件名,上传日期,文件大小,文件版本,以及是谁上传的。
3.2.7 Document_Bunf
【中文含义】 文档信息表_纸张版
字段名称 数据类型及长度 允许为空 中文说明 备注 Document_Bunf_Ivarchar(100) NO 文档ID 主键
d
Document_Name varchar(100) NO 文档名称 Document_Number int NO 文档编号 Document_Time datetime NO 创建文档日期 User_Info_Id varchar(100) YES 用户ID 外键
Remark varchar(1000) YES 备注 Templet_Id int YES 模板ID 外健 注: 纸张版文档,记录文挡的存放信息,以便需要时可以进行查询,快速找到该文档。
3.2.8 Log
【中文含义】日志信息表
字段名称 数据类型及长度 允许为空 中文说明 备注
Log_Id int NO 日志ID 主键,自动增1
Handle varchar(200) NO 操作名称
Log_Time datetime NO 操作日期
User_Name varchar(100) NO 用户名 Document_Electrvarchar(100) YES 电子文档名
on_Name
Document_Bunf_Nvarchar(100) YES 纸张文档名
ame
Operate_Static bit NO 操作是否成功
Remark varchar(1000) YES 备注 appearance of the weld appearance quality technical requirements of the project must not have a molten metal stream does not me - 7 - lt the base metal to weld, weld seam and heat-affected zone surface must not have cracks, pores, defects such as crater and ash, surface smoothing, weld and base metal should be evenly smooth transition. Width 2-3 mm from the edge of weld Groove. Surface reinforcement should be less than or equal to 1 + 0.2 times the slope edge width, and should not be greater than 4 mm. Depth of undercut should be less than or equal to 0.5 mm, total length of the welds on both sides undercut not exceed 10% of the weld length, and long continuous should not be greater than 100 mm. Wrong side should be less than or at 0.2T, and should not be greater than 2 mm (wall thickness mm t) incomplete or not allow 7.5 7.5.1 installation quality process standards of the electrical enclosure Cabinet surface is clean, neat, no significant phenomenon of convex, close to nature, close the door. 7.5.2 Cabinet Cabinet face paints no paint, returned to rusted, consistent color. 7.5.3 uniform indirect gap from top to bottom, slot width <1.5mm 7.5.4="" adjacent="" cabinet="" surface="" roughness="" is="" 0.="" 7.5.5="" the="" cabinets="" firmly="" fixed,="" crafts="" beautiful.="" 7.5.6="" cabinet="" surface="" gauge,="" switch="" cabinet="" mark="" clear,="" neat,="" firm="" paste.="" 7.5.7="" terminal="" row="" of="" neat,="" is="" reliable,="" the="" appearance="" is="" clean="" and="" not="" damaged.="" 7.5.8="" cables="" neat="" and="" clean,="" solid="" binding,="" binding="" process="" in="" appearance.="" 7.5.9="" the="" first="" cable="" production="" firm,="" crafts="" beautiful,="" clear="" signage="" does="" not="" fade.="" 7.5.10="" fireproof="" plugging="" tight,="" no="" cracks="" and="" pores.="" 7.6="" 7.6.1="" of="" the="" standard="" electrical="" wiring="" quality="" technology="" cable="" a,="" the="" multi-core="" wire="" bunch="" arrangement="" should="" be="" parallel="" to="" each="" other,="" horizontal="" wire="" harness="" or="" wire="" should="" be="" perpendicular="" to="" the="" longitudinal="" multi-core="" wire="" bunch.="" the="" distance="" between="" the="" wire="" harness="" and="" wire="" harness="" symmetry,="" and="" as="" close="" as="" possible.="" b-core="" wiring="" harness="" into="" round,="" multi-core="" wire="" bunch="" used="" g="" wire="" binding,="">1.5mm>
注: 记录用户对软件的操作,当用户进行了任何操作时,在此表记录该该用户什么时
间对哪个文档进行了什么操作。Operate_Static判断用户操作是否成功,0代表失败,1
代表成功。
3.2.9 Data_Backup
【中文含义】备份表
字段名称 数据类型及长度 允许为空 中文说明 备注 Backup_Id int NO 备份ID 主键,自动增1 Backup_Name varchar(100) NO 备份名称 Backup_Path varchar(500) NO 备份路径
Remark varchar(1000) YES 备注 注:记录对数据的备份以及信息。
3.2.10 Templet
【中文含义】模板名称表
字段名称 数据类型及长度 允许为空 中文说明 备注 Templet_Id int NO 模板名ID 主键 Templet_Name varchar(100) NO 模板名称 Templet_Create_datetime NO 模板创建时间
Time
注:记录用户自定义模板表的名称。
3.2.11模板表
【中文含义】模板表
字段名称 数据类型及长度 允许为空 中文说明 备注
Id int NO 模板ID 主键 Document_Electrvarchar(100) YES 电子文档ID 外键
on_Id
Document_Bunf_Ivarchar(100) YES 纸质文档ID 外键
d
注:用户自定义模板的属性由于其不确定性,在此没有列出。 appearance of the weld appearance quality technical requirements of the project must not have a molten metal stream does not melt the base metal to weld, weld seam and heat-affected zone surface must not have cracks, pores, defects such as crater and ash, surface smoothing, weld and base metal should be evenly smooth transition. Width 2-3 mm from the edge of weld Groove. Surface reinforcement should be less than or equal to 1 + 0.2 times the slope edge width, and should not be greater than 4 mm. Depth of undercut should be less than or equal to 0.5 mm, total length of the welds on both sides undercut not exceed 10% of the weld length, and long continuous should not be greater than 100 mm. Wrong side should be less than or at 0.2T, and should not be greater than 2 mm (wall thickness mm t) incomplete or not allow 7.5 7.5.1 installation quality process standards of the electrical enclosure Cabinet surface is clean, neat, no significant phenomenon of convex, close to nature, close the door. 7.5.2 Cabinet Cabinet face paints no paint, returned to rusted, consistent color. 7.5.3 uniform indirect gap from top to bottom, slot width <1.5mm 7.5.4="" adjacent="" cabinet="" surface="" roughness="" is="" 0.="" 7.5.5="" the="" cabinets="" firmly="" fixed,="" crafts="" beautiful.="" 7.5.6="" cabinet="" surface="" gauge,="" switch="" cabinet="" mark="" clear,="" neat,="" firm="" paste.="" 7.5.7="" terminal="" row="" of="" neat,="" is="" reliable,="" the="" appearance="" is="" clean="" and="" not="" damaged.="" 7.5.8="" cables="" neat="" and="" clean,="" solid="" binding,="" binding="" process="" in="" appearance.="" 7.5.9="" the="" first="" cable="" production="" firm,="" crafts="" beautiful,="" clear="" signage="" does="" not="" fade.="" 7.5.10="" fireproof="" plugging="" tight,="" no="" cracks="" and="" pores.="" 7.6="" 7.6.1="" of="" the="" standard="" electrical="" wiring="" quality="" technology="" cable="" a,="" the="" multi-core="" wire="" bunch="" arrangement="" should="" be="" parallel="" to="" each="" other,="" horizontal="" wire="" harness="" or="" wire="" should="" be="" perpendicular="" to="" the="" longitudinal="" multi-core="" wire="" bunch.="" the="" distance="" between="" the="" wire="" harness="" and="" wire="" harness="" symmetry,="" and="" as="" close="" as="" possible.="" b-core="" wiring="" harness="" into="" round,="" multi-core="" wire="" bunch="" used="" g="" wire="" binding,="">1.5mm>
范文二:数据库概要设计
数据库概要设计说明书
项目名称: 部门级文档管理系统
项目编号:
编写人员:
编写日期: 2004年7月19日
审批人员: __
审批日期: __
1引言 .................................................... 4
1.1编写目的 . ...................................................... 4 1.2背景 . .......................................................... 4 1.3术语定义 . ...................................................... 4 1.4参考资料 . ...................................................... 4
2总体设计 ................................................ 4
2.1运行环境。 . .................................................... 4
3结构设计 ................................................ 5
3.1数据库ER 模型(建议用PowerDesigner 或Visio 工具) . ............. 5 3.2数据库表 . ...................................................... 5
3.2.1 Popedom ........................................ 5
3.2.2 Organize ....................................... 5 3.2.3 User_Type ...................................... 6 3.2.4 Path ........................................... 6 3.2.5 User_Info ...................................... 6 3.2.6 Document_Electron .............................. 6 3.2.7 Document_Bunf .................................. 7 3.2.8 Log ............................................ 7 3.2.9 Data_Backup .................................... 8 3.2.10 Templet ....................................... 8 3.2.11模板表 ........................................ 8
1引言
1.1编写目的
目的:描述部门文档管理系统数据库的概要设计。 预期读者:项目经理,系统分析员。 1.2背景
数据库名称:DocumentManage 软件系统名称:部门级文档管理系统 1.3术语定义
1.4参考资料
需求分析说明书
2总体设计
2.1运行环境。
Pentium III 600MHz 以上 256MB RAM
Windows 2000/NT 4.0 Server Microsoft SQL Server 2000 磁盘设备空间>10G
3结构设计
3.1数据库ER 模型(建议用PowerDesigner 或Visio 工具)
3.2数据库表
3.2.1 Popedom
3.2.2 Organize
注: 数据字典。
包括了每个组织的上级组织的信息, 如果是最高级组织,上级则为自己,其他必须填写上级。
3.2.3 User_Type
3.2.4 Path
3.2.5 User_Info
并且规定了最大上传空间和剩余上传空间,建立用户时必须规定该用户最大的上传空间(累积), 当用户上传了数据时,剩余空间减少,标识用户类型和用户权限。
3.2.6 Document_Electron
文件版本, 以及是谁上传的。
3.2.7 Document_Bunf
3.2.8 Log
注: 记录用户对软件的操作, 当用户进行了任何操作时, 在此表记录该该用户什么时间对哪个文档进行了什么操作。Operate_Static判断用户操作是否成功,0代表失败,1代表成功。
3.2.9 Data_Backup
3.2.10 Templet
3.2.11模板表
范文三:数据库概要设计
数据库课程设计
公司人事管理系统 概要设计
——登录
——员工工资管理
编 写 者: 所属项目: 版 本 号: 文件类别:
审 核 者:
目 录
1 引言…………………………………………………………………1 1.1编写目的………………………………………………………..1
1.2背景………………………………………………………….....1
1.3 参考资料……………………………………………………….1 2 总体设计……………………………………………………………1
2.1 需求规定………………………………………………………1
2.2 运行环境………………………………………………………2 2.3基本设计概念和处理流程……………………………………..2 2.4 功能分配……………………………………………………….2 3 接口设计……………………………………………………………3 4 运行设计……………………………………………………………3 4.1 运行模块组合………………………………………………….3 4.2 运行控制……………………………………………………….3 4.3 运行时间……………………………………………………….3 5 数据结构设计………………………………………………………3 5.1 逻辑结构设计………………………………………………….3 5.2 物理结构设计………………………………………………….4 6 错误处理……………………………………………………………4 7 维护设计……………………………………………………………4
1. 引言
1.1 编写目的
随着各具特色的软件的出现,让软件使用者了解编程员的编程思路越显重要。为了让软件程序用户更清晰的理解作者的编程思路,因此把此软件程序概要设计写成报告以供查阅。
阅读对象,软件程序的使用者。
1.2 背景
a. 项目提出者:刘月明、刘振权、苏小平、朱立光
b. 开发者:刘月明、刘振权、苏小平、朱立光 c. 用户:任何一个现代化的公司 1.3
参考资料
数据库系统原理及应用教程——苗雪兰 刘瑞新 宋会群 编著——机械工业出版
社
Visual Basic 程序设计简明教程——龚沛曾 陆慰民 杨志强 编著——高等教育
出版社
Visual Basic 数据库编程从范例入门到项目开发——李华飚 毕宗睿 李水根 编
著——人民邮电出版社
2. 总体设计 2.1 需求规定
2.1.1为真正实现全现代化管理,软件程序的面向对象是整个公司的员工——员
工通过该软件系统,可以直接查询到与自己相关的信息,如考勤、工资等。因此,我们在数据库里面设立了userDL (用户登录表),设置了权限列,以区分登录者的权限。
用户输入:用户名,密码
程序处理:根据用户名在数据库的userDL (用户登录表)里,查找该用户,
存在,则判断该用户输入的密码是否正确。正确则进入系统,不正确着警告用户。
如果该用户名不存在,则警告用户。
2.1.2工资管理,是一个自动化很高的版块。因此,我们在程序设计的时候,用
编程语言实现使得此表内容与其他表相关联。
用户输入:员工编号,计发日期
程序处理:①:从manrecord (员工基本信息表)查找该编号员工的基本相关
信息,如果不存在,则警告用户。
②:从manappraise (员工工作信息表)查找该编号员工的工作信
息,如职位等,如果不存在,则警告用户;存在,则再从ranking (等级信息表)里面查找出该职位的等级信息,用来计算工资。
③:从checkin (员工考勤信息表)查找该编号员工在当月的考勤
情况,分类从regulate (规定信息表)中查找相关条款,进行奖罚。
④:最终计算该编号员工该月的工资。
2.2 运行环境
2.2.1 设备
该软件程序在以下计算机配置下测试运行通过: CPU :AMD 2500+ 内存:DDR400 256
硬盘:大于10M (视数据库资料多少而定,此数据是在数据库数据库
资料极少时测试而得)
操作硬件:①、输入:键盘 鼠标 ②、输出:显示器 2.2.2 软件支持
该软件程序在以下软件环境下测试通过:
操作系统:windongws XP SP2
其他软件:SQL 2000 、VB 6.0(看源代码必备) 2.3
基本设计概念和处理流程
2.3.1处理流程
2.4
功能分配
此概要设计主要针对该软件程序的其中两个版块——用户登录、员工工资管理 因此相关功能与其相关的程序块事件关系如下表:
3. 接口设计
由于系统的各种内外部接口是通过借助数据库SQL Server 开发软件来实现的,是完全在数据库内部操作的。
4. 运行设计
4.1 运行模块组合
具体软件的运行模块组合为程序多窗口的运行环境,各个模块在软件运行过程中能较好的交换信息,并能够独立的处理各自的数据。版块功能运行除了本版块的一些程序外,还调用到公共模块里面的一些函数和事件。具体如下:
时间的相关:事件:sub RiQiFuZhi(RiQi As String) 和 函数:Function RiJS(Nian_JS
As String, Yue_JS As String) As Integer 4.2
运行控制
软件运行时有较友好的界面,基本能够实现用户的数据处理要求。此软件程序的所
有控制操作,都通过按钮形式。使用户与计算机互动 4.3
运行时间
户所提出的要求。
函数和事件的运行时间要看所在计算机的配置。系统的运行时间基本可以达到用
5. 数据结构设计
5.1 逻辑结构设计
5.2物理结构设计
系统的物理结构具体由数据库来设计与生成。
6. 错误处理
所有的错误均记录在软件程序目录下的err.txt 文件里。已知的错误,可以用msgbox
弹出对话框告知用户错误的相关信息。未知的错误可以在记录里面查看,然后返回作者处理。
7. 维护设计
鉴于软件程序的简单性,没有在其中设计维护模块。数据维护靠SQL 软件的支持即可。
范文四:数据库概要设计
花店管理系统概要设计说明书
1. 需求规定
本系统的主要的输入输出项目、处理的功能性能要求。
2. 基本设计概念和处理流程
用户没有以会员身份登录网站,则可以查看所有商品,查看所有信息,但是无法购买商品,必须登陆后才能购买商品。
购买商品时,用户可以先将自己喜欢的商品放入购物车中,在结账之后会生成订单,生成订单之后,交易才算是真正的建立,货物就会由商家根据用户信息,给买家发货。购物流程如图1所示。
图1 会员在花店的购物流程 3. 数据库分析
数据库在一个信息管理系统中占有非常重要的地位,数据库结构设计的好坏将直接对应用系统的效率,以及实现的效果产生影响。合理的数据库结构设计可以提高数据存储的效率,保证数据的完整和一致。
3.1数据库需求分析
针对本系统功能分析,数据库需要设计七张表:
用户包括属性:用户名、密码、真实姓名、联系地址、邮政编码、证件号码、
证件类别、E-mail 。
鲜花包括属性:名称、图片名、所属大类、所属小类、商品简介、是否新品、是否特价、定价。
订单包括属性:订单号、用户名、品种数、订货日期、折扣、付款方式、运送方式、是否执行。
购物信息表包括属性:购物号、
管理员表单包括属性:
3.2实体概念分析
从本系统中规划出的实体有:用户实体、鲜花实体、订单实体等。 实体之间关系的E-R 图如图所示:
范文五:数据库概要设计
家 家 团 购 网
数据库概要设计
[V1.0(版本号)]
班 级:S3SN37班
组 名:个人项目小组
指 导:张果老师
组 员:杨家颖
1、 引言
1、1、 编写目的
编写数据库设计文档的目的是:明确数据库的表名、字段名
等数据信息,用来指导后期的数据库脚本的开发。本文档的读者
对象是需求人员、网站设计人员、开发人员、测试人员。
A284--284nm wavelength measured with absorbance; A386--336nm wavelength measured with absorbance; M--sample quality, g. Note: If there is a dispute, an ultraviolet spectrophotometry for arbitration law. the qualitative identification see Appendix a (Appendix to the standard) needed to neutralize acidity refers to acidity per 100 g of sample 1mol/L number of ml of sodium hydroxide solution. 1 reagents and materials, except as otherwise provided, the reagent is pure, water as distilled water. 1.1 0.1mol/L sodium hydroxide standard solution dissolve 4 g of sodium hydroxide in 1L by the boiling and cooling water, potassium hydrogen phthalate (reference sample) according to its rules of play calibration concentration. Said take advance in 125 0C Shi dry had of o benzene II carboxylic acid hydrogen potassium (benchmark reagents 0.8 g~0.9 g (precise to 0.000 2 g), placed 350mL tapered bottle in the, with 50mL by boiling Hou cooling of water dissolved, joined 2~3 drops 1% phenolphthalein indicates agent, with hydrogen oxidation sodium solution titration to solution is pink, to in 10 s within not faded for end. by type (3) calculation sodium hydroxide standard solution of concentration: C=m ? (Vx0.204 2)................................. (3) in the formula: C--standard solution of sodium hydroxide concentration, mol/l; The quality of m--potassium hydrogen phthalate, g; V--drops of time consumed by the volume of standard solution of sodium hydroxide, mL; 0.204
1、2、 背景
数据库名:MyProduct
开发软件名称:家家团购网
项目提出者:南方学院S37班指导老师
开发者:S37班个人项目小组
用户:所有用户
1、3、 定义
数据结构:数据结构是计算机存储、组织数据的方式。数据
结构是指相互之间存在一种或多种特定关系的数据元素的
集合。
逻辑结构:数据的逻辑结构是对数据之间关系的描述,有时
就把逻辑结构简称为数据结构。
物理结构:数据结构在计算机中的表示(映像)称为数据的
物理(存储)结构。它包括数据元素的表示和关系的表示。
A284--284nm wavelength measured with absorbance; A386--336nm wavelength measured with absorbance; M--sample quality, g. Note: If there is a dispute, an ultraviolet spectrophotometry for arbitration law. the qualitative identification see Appendix a (Appendix to the standard) needed to neutralize acidity refers to acidity per 100 g of sample 1mol/L number of ml of sodium hydroxide solution. 1 reagents and materials, except as otherwise provided, the reagent is pure, water as distilled water. 1.1 0.1mol/L sodium hydroxide standard solution dissolve 4 g of sodium hydroxide in 1L by the boiling and cooling water, potassium hydrogen phthalate (reference sample) according to its rules of play calibration concentration. Said take advance in 125 0C Shi dry had of o benzene II carboxylic acid hydrogen potassium (benchmark reagents 0.8 g~0.9 g (precise to 0.000 2 g), placed 350mL tapered bottle in the, with 50mL by boiling Hou cooling of water dissolved, joined 2~3 drops 1% phenolphthalein indicates agent, with hydrogen oxidation sodium solution titration to solution is pink, to in 10 s within not faded for end. by type (3) calculation sodium hydroxide standard solution of concentration: C=m ? (Vx0.204 2)................................. (3) in the formula: C--standard solution of sodium hydroxide concentration, mol/l; The quality of m--potassium hydrogen phthalate, g; V--drops of time consumed by the volume of standard solution of sodium hydroxide, mL; 0.204
1、4、 参考资料
购物网站概要说明书
2、 结构设计
2.1、逻辑结构设计
上架日期 重量 图片
寄送描述 数量
价格 详细描述
类型Id 状态
商品 商品名 游客 N N 浏览
N Id
Id 管理
N
N N N 1 账号
管理员 浏览 查看 订购 评论
密码 1 N
管理 管理 N N N N
N N
会员 N 查看 Id N 公告
用户名
Id
密码
内容 发布日期
真实姓名 邮编
状态 收货地址
联系电话
A284--284nm wavelength measured with absorbance; A386--336nm wavelength measured with absorbance; M--sample quality, g. Note: If there is a dispute, an ultraviolet spectrophotometry for arbitration law. the qualitative identification see Appendix a (Appendix to the standard) needed to neutralize acidity refers to acidity per 100 g of sample 1mol/L number of ml of sodium hydroxide solution. 1 reagents and materials, except as otherwise provided, the reagent is pure, water as distilled water. 1.1 0.1mol/L sodium hydroxide standard solution dissolve 4 g of sodium hydroxide in 1L by the boiling and cooling water, potassium hydrogen phthalate (reference sample) according to its rules of play calibration concentration. Said take advance in 125 0C Shi dry had of o benzene II carboxylic acid hydrogen potassium (benchmark reagents 0.8 g~0.9 g (precise to 0.000 2 g), placed 350mL tapered bottle in the, with 50mL by boiling Hou cooling of water dissolved, joined 2~3 drops 1% phenolphthalein indicates agent, with hydrogen oxidation sodium solution titration to solution is pink, to in 10 s within not faded for end. by type (3) calculation sodium hydroxide standard solution of concentration: C=m ? (Vx0.204 2)................................. (3) in the formula: C--standard solution of sodium hydroxide concentration, mol/l; The quality of m--potassium hydrogen phthalate, g; V--drops of time consumed by the volume of standard solution of sodium hydroxide, mL; 0.204
2.2、概念结构设计(用例图)
(1)会员功能
(2)管理员功能
A284--284nm wavelength measured with absorbance; A386--336nm wavelength measured with absorbance; M--sample quality, g. Note: If there is a dispute, an ultraviolet spectrophotometry for arbitration law. the qualitative identification see Appendix a (Appendix to the standard) needed to neutralize acidity refers to acidity per 100 g of sample 1mol/L number of ml of sodium hydroxide solution. 1 reagents and materials, except as otherwise provided, the reagent is pure, water as distilled water. 1.1 0.1mol/L sodium hydroxide standard solution dissolve 4 g of sodium hydroxide in 1L by the boiling and cooling water, potassium hydrogen phthalate (reference sample) according to its rules of play calibration concentration. Said take advance in 125 0C Shi dry had of o benzene II carboxylic acid hydrogen potassium (benchmark reagents 0.8 g~0.9 g (precise to 0.000 2 g), placed 350mL tapered bottle in the, with 50mL by boiling Hou cooling of water dissolved, joined 2~3 drops 1% phenolphthalein indicates agent, with hydrogen oxidation sodium solution titration to solution is pink, to in 10 s within not faded for end. by type (3) calculation sodium hydroxide standard solution of concentration: C=m ? (Vx0.204 2)................................. (3) in the formula: C--standard solution of sodium hydroxide concentration, mol/l; The quality of m--potassium hydrogen phthalate, g; V--drops of time consumed by the volume of standard solution of sodium hydroxide, mL; 0.204
(3) 游客功能
3、数据库设计
3.1数据字典设计
数据库名:MyProduct
表名:Admins(管理员表)
序号 列名 数据类型 长度 小数位 标识 主键 允许空 默认值 说明
1 Id int 4 0 是 是 否
2 AName varchar 20 0 否
3 APassword varchar 20 0 否
表名:Affiches(公告表)
序号 列名 数据类型 长度 小数位 标识 主键 允许空 默认值 说明
1 Id int 4 0 是 是 否
2 PutDate datetime 8 3 否
3 PutContent ntext 16 0 否
表名:Leaves(留言表)
序号 列名 数据类型 长度 小数位 标识 主键 允许空 默认值 说明
1 Id int 4 0 是 是 否 A284--284nm wavelength measured with absorbance; A386--336nm wavelength measured with absorbance; M--sample quality, g. Note: If there is a dispute, an ultraviolet spectrophotometry for arbitration law. the qualitative identification see Appendix a (Appendix to the standard) needed to neutralize acidity refers to acidity per 100 g of sample 1mol/L number of ml of sodium hydroxide solution. 1 reagents and materials, except as otherwise provided, the reagent is pure, water as distilled water. 1.1 0.1mol/L sodium hydroxide standard solution dissolve 4 g of sodium hydroxide in 1L by the boiling and cooling water, potassium hydrogen phthalate (reference sample) according to its rules of play calibration concentration. Said take advance in 125 0C Shi dry had of o benzene II carboxylic acid hydrogen potassium (benchmark reagents 0.8 g~0.9 g (precise to 0.000 2 g), placed 350mL tapered bottle in the, with 50mL by boiling Hou cooling of water dissolved, joined 2~3 drops 1% phenolphthalein indicates agent, with hydrogen oxidation sodium solution titration to solution is pink, to in 10 s within not faded for end. by type (3) calculation sodium hydroxide standard solution of concentration: C=m ? (Vx0.204 2)................................. (3) in the formula: C--standard solution of sodium hydroxide concentration, mol/l; The quality of m--potassium hydrogen phthalate, g; V--drops of time consumed by the volume of standard solution of sodium hydroxide, mL; 0.204
2 Pids int 4 0 否 3 Uids int 4 0 否 4 Contents nvarchar 300 0 否 5 Dates datetime 8 3 否
表名:OrderProducts(订单商品表)
序号 列名 数据类型 长度 小数位 标识 主键 允许空 默认值 说明 1 Id int 4 0 是 是 否 2 OrderId int 4 0 是 3 ProductId int 4 0 是 4 Amount int 4 0 是
表名:Orders(订单表)
序号 列名 数据类型 长度 小数位 标识 主键 允许空 默认值 说明 1 Id int 4 0 是 是 否 2 UserId int 4 0 是 3 OrderDate datetime 8 3 是 getdate
表名:Products(商品表)
序号 列名 数据类型 长度 小数位 标识 主键 允许空 默认值 说明 1 Id int 4 0 是 是 否 2 ProductName nvarchar 200 0 否 3 TypeId int 4 0 是 4 Price money 8 4 是 5 Amount int 4 0 是 6 Picture varchar 30 0 是 7 AddDate datetime 8 3 是 getdate 8 Weights int 4 0 是 9 Post nvarchar 250 0 是
A284--284nm wavelength measured with absorbance; A386--336nm wavelength measured with absorbance; M--sample quality, g. Note: If there is a dispute, an ultraviolet spectrophotometry for arbitration law. the qualitative identification see Appendix a (Appendix to the standard) needed to neutralize acidity refers to acidity per 100 g of sample 1mol/L number of ml of sodium hydroxide solution. 1 reagents and materials, except as otherwise provided, the reagent is pure, water as distilled water. 1.1 0.1mol/L sodium hydroxide standard solution dissolve 4 g of sodium hydroxide in 1L by the boiling and cooling water, potassium hydrogen phthalate (reference sample) according to its rules of play calibration concentration. Said take advance in 125 0C Shi dry had of o benzene II carboxylic acid hydrogen potassium (benchmark reagents 0.8 g~0.9 g (precise to 0.000 2 g), placed 350mL tapered bottle in the, with 50mL by boiling Hou cooling of water dissolved, joined 2~3 drops 1% phenolphthalein indicates agent, with hydrogen oxidation sodium solution titration to solution is pink, to in 10 s within not faded for end. by type (3) calculation sodium hydroxide standard solution of concentration: C=m ? (Vx0.204 2)................................. (3) in the formula: C--standard solution of sodium hydroxide concentration, mol/l; The quality of m--potassium hydrogen phthalate, g; V--drops of time consumed by the volume of standard solution of sodium hydroxide, mL; 0.204
10 Descriptions ntext 16 0 是 11 ProductState int 4 0 是 1
表名:ProductType(商品类型表)
序号 列名 数据类型 长度 小数位 标识 主键 允许空 默认值 说明 1 Id int 4 0 是 是 否 2 TypeName nvarchar 100 0 否 3 TypeSate int 4 0 是 1
表名:Users(用户表)
序号 列名 数据类型 长度 小数位 标识 主键 允许空 默认值 说明 1 Id int 4 0 是 是 否 2 UserName nvarchar 50 0 否 3 Password1 varchar 50 0 否 5 RealName varchar 20 0 是 6 Addresss nvarchar 200 0 是 7 Phone varchar 16 0 是 8 PostCode char 6 0 是 9 States int 4 0 是 1
A284--284nm wavelength measured with absorbance; A386--336nm wavelength measured with absorbance; M--sample quality, g. Note: If there is a dispute, an ultraviolet spectrophotometry for arbitration law. the qualitative identification see Appendix a (Appendix to the standard) needed to neutralize acidity refers to acidity per 100 g of sample 1mol/L number of ml of sodium hydroxide solution. 1 reagents and materials, except as otherwise provided, the reagent is pure, water as distilled water. 1.1 0.1mol/L sodium hydroxide standard solution dissolve 4 g of sodium hydroxide in 1L by the boiling and cooling water, potassium hydrogen phthalate (reference sample) according to its rules of play calibration concentration. Said take advance in 125 0C Shi dry had of o benzene II carboxylic acid hydrogen potassium (benchmark reagents 0.8 g~0.9 g (precise to 0.000 2 g), placed 350mL tapered bottle in the, with 50mL by boiling Hou cooling of water dissolved, joined 2~3 drops 1% phenolphthalein indicates agent, with hydrogen oxidation sodium solution titration to solution is pink, to in 10 s within not faded for end. by type (3) calculation sodium hydroxide standard solution of concentration: C=m ? (Vx0.204 2)................................. (3) in the formula: C--standard solution of sodium hydroxide concentration, mol/l; The quality of m--potassium hydrogen phthalate, g; V--drops of time consumed by the volume of standard solution of sodium hydroxide, mL; 0.204