实验室安排管理系统
数据库，软件工程的实验室安排管理系统，很好的文档和代码。第一章引言1.1项目背景随着信息技术的普及,对计算机应用的普及,高等学校的计算机实验室在逐年上升,面对众多的计算机实验课,如何有效安排实验室,成为实验室管理人员的重要工作之一。为了提高实验室安排管理效率,方便教师对实验室的使用情况及时查询和申请实验室,需要设计一个能提供教师实时了解当前实验室教师申请情况,并可以对闲置实验室的申请,最后通过实验室管理员对教师所做的实验申请进行安排管理。本系统基于B/S结构,主要山前台教师对实验室申请和后台基本资料的维护及实验室的安排,主要包括以下功能:登录、申请实验、基本资料维护、实验室安排管理、用户管理,个人设置等。1.2实验室安排管理系统概述实验室安排管理系统是一门新兴的集管珪科学、信息科学、系统科学级计算机科学为一体的综合性学科,研究的是大学校园的实验室安排管理的全过程,以便有效的安排管理实验室信息,提高校园的实验室使用率,提供各类管理决策信息辅助实验室管理部门进行现代化管理。实验室安排管理系统是大学校园的实验空信息管理系统,它具备数据增加、修改、删除和査询功能,具体如下(1)对用户信息增加、修改、删除管理;(2)对实验室信息增加、修改、删除管理com3)对日期和课程信息增加、修改、删除管理(4)实验室安排管理1.3系统开发的意义为了有效的安排管理实验室信息,提高校园的实验室使用率,提供各类管理决策信息辅助实验室管理部门进行现代化管理需要设计一个能提供教师实时了解当前实验室教师申请情况,并可以对闲置实验室的申请,最后通过实验室管理员对教师所做的实验申请进行安排管理。本系统基于B/S结构,主要由前台教师对实验室申请和后台基本资料的维护及实验室的安排,主要包括以下功能:登录、申请实验、申请实习、基本资料维护、用户管理,个人设置、实验室安排管理等第二章系统分析2.1系统功能分析通过讨论分析,要求系统需要有以下功能:(1)要有良好的人机界面功能。(2)支持多用户操作,要求有较好的权限分配功能。(3)支持实验申请和实习申请多行录入功能。(4)为了方便用户能快速正确地申请到实验室,提供实验室申请浏览。(5)每个用户,课程,实验,实习,实验室都有惟一的编号即ID,编号需要是整型标识,能自动生成有序ID。(6)支持用户,课程,班级,实验室的修改,增加,删除功能。(7)支持实验室的安排浏览。2.2用户管理流程丁公共用户登录修改密退出→码图2-1用户管理流程com2.3实验管理流程用户登录系统—>申请实验—>修改申请—>查询申请结果申请实公共用户登录验,修改退出图2-2实验管理流程2.4实习管理流程用户登录系统—>申请实习—一>修改申请——一>查询申请结果申请实习,修改公共用户登录实习4退出图2-3实习管理流程2.5实验室安排系统管理流程管理员登录—>査询实验、实习申请—>安排实验室—>审核——>安排登录4添加、修改管理员册除用户退出管理实验室艹图2-4实验室安排系统管理流程docn豆丁www.docin.com第三章系统设计3.1项目规划本系统分为如下的几大模块:主界面登录模块实验室安排浏览模块用户控制面版实验宝查询用广管理实验审管理|报表图3-1系统模块图1、主界面模块该模块提供管理系统的主界面,是主系统的唯一入口和出口,该界面提供用户选择并调用各子模块2、登录根据用户管理分配不同的角色权限,核对用户,进入系统进行相应的操作。子模块:(1)用户控訇面版(公共用户)该模块提供用户的基本信息的界面,用户可在此修改密码、基本资料;察看本人申请实验室的情况。(2)实验室查询(老师)该模块提供査询符合某一条件的实验室安排情况的界面。(3)用户管理(管理员)该模块提供对用户信息进行更改、删除和新增和手动安排实验室的界面(4)实验室管理(管理员)该模块提供对实验室信息进行更改、删除和新增和手动安排实验室的界面。3、实验室安排浏览该模块提供全部实验室安排情況的界面。3.2功能框图用户查询更新查询更新查查更查查更更洵询更新结果询询新新条结条结条条结件|果果|件自果浏览申请表实验室安排表系统安排管理员审核图3-2主数据流程图3.3数据库设计创建数据库是设计系统的第·步,其关键问题在于确定所需的表结构并为之建立索引。为∫使系统设计精练实用,体现关系型数据库的特点,本系统还为各相关表建立关系。数据项设计通过需求分析,可确定系统的数据项和数据结构如下:实验申请表: shiyang(实验申请ID,周次,星期,节次,实验名称,实验班级,实验人数,任课教师,实验教师,申请时间实习申请I,周次,实习内容,实习课程名称,实习班级,实习人数,任课教师,申请时间)实习申请表 shixing(实习申请ID,周次,实习内容,实习课程名称,实习班级,实习人数,任课教师,申请时间)用户表:user(用户ID,用户名,用户类型)。班级表: classdb(班级ID,班级名称,班级入学时间)课程表:Kedb(课程ID,课程名称)实验室表: Ssdb(实验室ID,实验室名称,实验室座位)为了方便安排,本系统还设定了几个用于安排的临时表学年表: Xuelian(学年ID,学年名称)。学期表: xueqI(节次ID,节次名称)。周次表: Weekdb(周次ID,周次名称)。节次:jeci(节次I,节次名称)。实验表: shiyan(实验ID,实验名称)实习表: shixi(实习ID,实习名称)2、概念结构设计本系统在需求分析的基础上设计出能够满足用户需求的各种实体。根据上面的分析所得的实体有:实验室安排实体、用户实体。3、逻辑结构设计数据项描述{数据项名,数据类型,长度,数据项含义说明,可否为空}(1)用户表: Userdb用户表用来保存用信息,用户表结构如表3-1所示表3-1用户表数据项名数据类型(长度)数据项含义说明「可否为空user 1dint(4)用户ID否User-name char(20)用广名否User perchar(20)用户类型否(2)班级表: classdb班级表用来保存班级信息,班级表结构表3-2所示表3-2班级表数据项名数据类型(长度)数据项含义说明可否为空Class idInt(4)班级ID否Class nameChar(50)班级名称Class inyearChar(20)班级入学时间否3)实习申请表: shixia实习申请表用来保存实验申请信息,实习申请表结构表3-3所示表3-3实习申请表数据项名数据类型(长度)‖数据项含义说明「可否为空Shixing idInt(4)实习申请ID否Shixing week Char(20)周次否Shixing nameChar(100)实习内容否Shixing keChar(100)实习课程名称否Shixisg class Char(100)实习班级否Shixisq menInt(4)实习人数否Shixisq manChar(20)「任课教师否Shixing timeChar(20)申请时间可4)实验申请表: shiyang实验申请表用来保存实验申请信息,实验申请表结构如表3-4所示表34实验申请表数据项名数据类型(长|数据项含义说明「可否为空度)Shiyang idInt(4)实验申请ID否Shiyang weekChar(20周次Shiyang xqChar(20)星期Shiyang jcChar(20)节次否否否Shiyang nameCar(100实验名称Shiyang classChar(100)实验班级Shiyang menInt(4实验人数口Shiyang manar(2任课教师Shiyansq syteacher Char(20)实验教师Shiyang timeChar(20)申请时间(5)实验教师表: teacher实验教师表用来保存实验教师信息,实验教师表结构如表3-5所示表3-5实验教师表数据项名数据类型(长度)数据项含义说明「可否为空Teacher idInt(4)教师ID否Teacher nameChar(20)教师名称否(6)课程表:Kedb课程表用来保存课程信息,课程表结构如表3-6所示表3-6课程表数据项名数据类型(长度)数据项含义说明「可否为空Ke idInt(4)课程ID否Ke namelChar(100课程名称否(7)实验室表: Ssdb实验室表用来保存实验室信息,实验室表结构如表3-7所示表3-7实验室表数据项名数据类型(长度)数据项含义说明可否为空Sys idint(4)实验室ID否sys namechar(100)实验室名称否Sys menInt(4)实验室座位否(8)学年表: Xuelian学年表用来保存用信息,学年表结构如表3-8所示表3-8学年表数据项名数据类型(长度)数据项含义说明可否为空Xuenian idchar(20)学年ID否Xuwenlan nameint(20)学年名称否(9)周次表: Weekdb周次表用来保存周次信息,周次表结构如表39所示表3-9周次表数据项名数据类型(长度)「数据项含义说明「可否为空Week idchar (20)周次IDWeek nameint(20)周次名称否否(10)星期表: XIng星期表用来保存星期信息,星期表结构如表3-10所示表3-10星期表数据项名数据类型(长度)「数据项含义说明可否为空xing idchar(20)学年IDXIngl nameint(20)学年ID否否(11)节次表: J1eC1节次表用来保存节次信息,节次表结构如表3-11所示表3-11节次表数据项名数据类型(长度)数据项含义说明「可否为空c ldchar(20)班级名称合Jc nameint(20)编级人数4www.docin.com
- 2020-11-30下载
- 积分：1
ISO16750-3-2012
ISO16750-3-2012Road vehicles — Environmentalconditions and testing for electricaland electronic equipment —Part 3:Mechanical loadsContents PageForeword.............................................................................................................................................Iso16750-3:2012[EContentsPageForewordScope12Normative references1Terms and definitions4Tests and requirements4.1ibration4.2 Mechanical shock274.3 Free fall…294.4 Surface strength/ scratch and abrasion resistance294.5 Gravel bombardmentCode letters for mechanical loads29Documentation…,…………111111130Annex A (informative) Guideline for the development of test profiles for vibration tests.32Annex B (informative) Recommended mechanical requirements for equipment depending on themounting location44Bibliography46C ISO 2012-All rights reservedIso16750-3:2012EForewordISo (the International Organization for Standardization) is a worldwide federation of national standardsbodies (Iso member bodies). The work of preparing International Standards is normally carried outthrough iso technical committees. Each member body interested in a subject for which a technicalcommittee has been established has the right to be represented on that committee. Internationaorganizations, governmental and non-governmental, in liaison with ISO, also take part in the workIso collaborates closely with the International Electrotechnical Commission (IEC) on all matters ofelectrotechnical standardizationInternational Standards are drafted in accordance with the rules given in the ISo/IEC Directives, Part 2The main task of technical committees is to prepare lnternational standards. draft InternationalStandards adopted by the technical committees are circulated to the member bodies for votingublication as an International Standard requires approval by at least 75 of the member bodiescasting a voteAttention is drawn to the possibility that some of the elements of this document may be the subject ofpatent rights. ISO shall not be held responsible for identifying any or all such patent rightsIso 16750-3 was prepared by Technical Committee ISO/TC 22, Road vehicle, Subcommittee SC 3,Electrical and electronical equipment.This third edition cancels and replaces the second edition (Iso 16750-3: 2007), which has beentechnically revisedISo 16750 consists of the following parts, under the general title road vehicles-Environmental conditionsand testing for electrical and electronic equipment:Part 1: GeneralPart 2: electrical loadsPart 3: Mechanical loadsPart 4: Climatic loadsPart 5: chemical loadso ISO 2012-All rights reservedINTERNATIONAL STANDARDIso16750-3:2012(E)Road vehicles- Environmental conditions and testing forelectrical and electronic equipmentPart 3Mechanical loads1 ScopeThis part of IS0 16750 applies to electric and electronic systems/components for road vehicles. Itdescribes the potential environmental stresses and specifies tests and requirements recommended forthe specific mounting location on/in the vehicleThis part of iso 16750 describes mechanical loads2 Normative referencesThe following referenced documents are indispensable for the application of this document. For datedreferences, only the edition cited applies For undated references, the latest edition of the referenceddocument (including any amendments applies.Iso16750-1, Road vehicles- Environmental conditions and testing forelectrical andelectronicequipment-Part 1: GeneralIEC 60068-2, 6, Environmental testing- Part 2-6: Testing, Test Fc: Vibration SinusoidalIEC60068-2, 14, Basicenvironmental testing procedures- Part 2-14: Tests-Test Nb: Change oftemperatureTEC 60068-2, 64, Environmental testing Part 2-64: Test methods -Test Fh -Vibration, broad-bandrandom(digital control)and guidanceIEC 60068-2, 80, Environmental testing- Part 2-80: Tests- Test Fi: Vibration - Mixed mode testingIEC 60068-2-31, Environmental testing procedures- Part 2: Tests; Test Ec: Free fall, Clause 5.23 Terms and definitionsFor the purposes of this document, the terms and definitions given in Iso 16750-1 app4 Tests and requirements4.1 Vibration41.1 GeneralThe vibration test metho ds specified consider various levels of vibration severities applicable to on-board electrical and electronic equipment. It is recommended that the vehicle manufacturer andsupplier choose the test method, the environmental temperature and vibration parameters dependingon the specific mounting locationFollowing the expressions in MIL-STD please noticeC ISO 2012-All rights reservedIso16750-3:2012EWhen applied properly, the environmental management and engineering processes described in this partof Iso 16750 can be of enormous value in generating confidence in the environmental worthiness andoverall durability. However, it is important to recognize that there are limitations inherent in laboratorytesting that make itimperative to use proper caution and engineering judgement when extrapolating theselaboratory results to results that may be obtained under actual service conditions. In many cases, realworld environmental stresses (singularly orin combination cannot be duplicated practically or reliably intestlaboratories. Therefore, users of this part of Iso 16750 should not assume that a system or componentthat passes laboratory tests of this part of Iso 16750 would also pass field/ fleet verification trialsThe specified values are the best estimation one can get up to the moment when results frommeasurements in the car are received - but they do not replace a car measurement!The specified values apply to direct mounting in defined mounting locations. Using a bracket formounting can resultin higher or lower loads. If the device under test ( DUT)is used in the vehicle with abracket then all vibration and mechanical shock test shall be done with this bracketCarry out the vibration with the dut suitably mounted on a vibration table. The mounting method (sused shall be noted in the test report. Carry out the frequency variation by logarithmic sweeping of 0,5octave/minute for sinusoidal tests and the sinusoidal part of sine on random tests. The scope of therecommended vibration tests is to avoid malfunctions and breakage mainly due to fatigue in the fieldTesting for wear has special requirements and is not covered in this part of ISo 16750Loads outside of the designated test frequency ranges are to be considered separatelNOTE Deviations from the load on the DUT can result, should vibration testing be carried out according tothis part of Iso 16750 on a heavy and bulky dut, as mounting rigidity and dynamic reaction on the vibrator tableexcitation are different compared to the situation in the vehicle. This deviation can be minimized by applying theaverage control method(see Annex A)Application of the weighted average control method according to IEC 60068-2, 64 is to be agreed uponSubject the dut during the vibration test to the temperature cycle according to iEC 60068-2, 14, withelectric operation according to diagram 1. Alternatively, a test at constant temperature may be agreed onOperate the dutelectrically as indicatedin Figure l at Tmin(Short functional testafterthe dUT completelyreached Tmin). This functional test shall be as short as possible- only long enough to check the properperformance of the dUt. This minimizes self-heating of the dUT. Additional electrical operation of theDUT between 210 min and 410 min of the cycle (see Figure 1)Additional drying of test chamber air is not permittedIn the vehicle, vibration stress can occur together with extremely low or high temperatures; for thisreason, this interaction between mechanical and temperature stress is simulated in the test, too. afailure mechanism is, for example, a plastic part of a system/component, which mellows due to the hightemperature and cannot withstand the acceleration under this condition2o ISO 2012-All rights reservedIso16750-3:2012[EYmax20aburditt0100200300400500600yY temperature[°C]x time [ minIa Operating mode 3.2 according to ISo 16750-1.b Operating mode 2. 1 according to ISo 16750-1One cycleFigure 1-Temperature profile for the vibration testTable 1- Temperature versus time for the vibration testTimeTemperaturemin°C0206040150-4021020300max41048020See Is016750-44.1.2 Tests4.1.2.1 Test I- Passenger car, engine4.1.2.1.1 PurposeThis test checks the dUt for malfunctions and breakage caused by vibrationThe vibrations of a piston engine can be split up into two kinds: Sinusoidal vibration which results from theunbalanced mass forces in the cylinders and random noise due to all other vibration-schemes of an engine,C ISO 2012-All rights reserved3Iso16750-3:2012Ee.g. closing of valves. In the lowest frequency range from 10 Hz to 100 Hz the influence of rough-roadconditions is taken into account. The main failure to be identified by this test is breakage due to fatigueNOTE 1 Road profile usually has negligible impact on engine-mounted components. Shock inputs are effectivelysolated by suspension, and engine-mounting systemsThe test profiles specified in the following clauses apply to loads generated by(four strokereciprocating enginesNotE 2 If the dut is to be tested for a specific resonance effect, then a resonance dwell test according to 8.3.2of IEC 60068-2, 6: 2007 can also be applied4.12.1.2Test4.1.2.1.2.1 GeneralIt is required to perform this test as a mixed mode vibration test according to IEC 60068-2, 80NOTE The test duration is based on A 4. The temperature in the chamher is above room temperature (rt)atthe end of the test (2 3/4 temperature cycles4.1.2.1.2.2 Sinusoidal vibrationPerform the test according to IEC 60068-2, 6, but using a sweep rate of s 0,5 octave/minute. Use a testduration of 22 h for each plane of the dUTUse curve l in Table 2/ Figure 2 for DUT intended for mounting on engines with 5 cylinders or fewerUse curve 2 in Table 2/Figure 2 for dUT test intended for mounting on engines with 6 cylinders or moreBoth curves may be combined to cover all engine types in one test2502001501005050100150200250300350400450500ⅩKeyamplitude of acceleration [m/s2IXfrequency [Hzcurve1(≤5 cylinders)curve 2(5 cylindersFigure 2- Vibration severity curves4o ISO 2012-All rights reservedIso16750-3:2012[ETable 2- values for max acceleration versus frequencyCurve 1(see Figure 2FrequencyAmplitude of accelerationHz100100200200240200270100440100Curve 2(see Figure 2)FrequencyAmplitude of accelerationHm/s2100100150150440150CombinationFrequencyAmplitude of accelerationH1001001501502002002402002551504401504,1.21.2.3 Random vibrationPerform the test according to IEC 60068-2, 64. Use a test duration of 22 h for each plane of the DUTThe r.m.s. acceleration value shall be 181 m/s2The psd versus frequency are referred to in Figure 3 and Table 3NoTE The Power Spectral Density(PSD)values (random vibration] are reduced in the frequency range of thesinusoidal vibration testC ISO 2012-All rights reserved5Iso16750-3:2012EY100100,110100100010000KeyY PSD [(m/s2)2/HzX frequency [Hz]Figure 3- PSD of acceleration versus frequencyTable 3- Values for frequency and PsDFrequencyPSDH:(m/s2)2/Hz1010100103000,5150020200024.1.2.1.3 RequirementBreakage shall not occur.Functional status a see iso 16750-1) is required during operating mode 3.2 as defined in ISo 16750-1and functional status C during periods with other operating modes4.1.2.2 Test II-Passenger car, gearbox4.1.2.2.1 PurposeThis test checks the dut for malfunctions and breakage caused by vibrationThe vibrations of a gearbox can be split up into two kinds which result partly from sinusoidal vibrationfrom unbalanced mass forces of the engine(e. g dominating orders) in the frequency range from 100 Hzto 440 Hz and vibration from the friction of the gear wheels and other schemes, which are tested in therandom part. In the lowest frequency range from 10 Hz to 100 Hz the influence of rough-road conditionsis taken into account The main failure to be identified by this test is breakage due to fatigueChanging the gears can create additional mechanical shock and shall be considered separatey brationsThe test profiles specified in the following subclauses apply to loads generated by gearbox vibo ISO 2012-All rights reserved
- 2020-12-08下载
- 积分：1
