实验室安排管理系统
数据库，软件工程的实验室安排管理系统，很好的文档和代码。第一章引言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
使用CC2591作为CC2530的功放
使用CC2591作为CC2530的功放, CC2591 PAThe absolute maximum ratings and operating conditions listed in the CC2530 datasheet [1]and the CC2591 datasheet [4] must be followed at all times. Stress exceeding one or more ofthese limiting values may cause permanent damage to any of the devicesNote that these characteristics are only valid when using the recommended register settingspresented in Section 4.6 and in Chapter 8, and the CC2530 - EM reference designOperating Frequency240524835MHzOperating Supply Voltage2036VOperating Temperature-40CTC=25C, VDD=3.0V, f=2440 MHz if nothing else is stated. All parameters are measuredon the CC2530-Cc2591EM reference design [11] with a 50 Q2 loadReceive CurrentWait for sync, -90 dBm input levelWait for sync, -50 dBm input level24mATXPOWER OXE5166mATXPOWER OXD5149mATXPOWER OXC5138mATXPOWER OXB5127mATransmit currentTXPOWER OXA5115ATXPOWER = 0X95100mATXPOWER = 0X8594ATXPOWE=0×75mATXPOWE=0×6579APower Down Current PM2UAISTRUMENTSPage 3 of 19SWRA308ATC=25C, Vdd=3.0V, f= 2440 MHz if nothing else is stated. All parameters are measuredon the CC2530-CC2591 EM reference design with a 50 Q2 loadReceive Sensitivity HGM 1 %PER, IEEE 802. 15.4[6] requires -85 dBm-988dBmReceive Sensitivity LGM1 PER, IEEE 802. 15.4 [6] requires -85 dBm-90.4dBmSaturationlEEE 802.15. 4 [6] requires-20 dBm10dBmWanted signal 3 db above the sensitivity levelIEEE 802.15.4 modulated interferer at ieee 802.15.4 channelsInterferer Rejection+5 MHz from wanted signal, IEEE 802. 15. 4 [6] requires 0 dBdB+10 MHz from wanted signal, IEEE 802. 15. 4 [6] requires 30 dB49dB+20 MHz from wanted signal wanted signal at- 82d BmdBdue to in the external lna and the offset in cc2530 the rssi readouts from cc2530CC2591 is different from rssi offset values for a standalone cc2530 design the offsetvalues are shown in table 4.4High Gain Mode79LoW Gain mode67Real rssi Register value-Rssl offsetISTRUMENTSPage 4 of 19SWRA308ATc=25C, Vdd=3.0V, f=2440 MHz if nothing else is stated All parameters are measuredon the CC2530-CC2591 EM reference design with a 50 Q2 load Radiated measurements aredone with the kit antennaRadiated Emissionwith TXPOWer Oxe5Conducted 2. RF (FCC restricted band)-462|dBmConducted 3. RF(FCC restricted band46.5 dBmComplies withFCC 15.247. SeeChapter 7 for moredetails about regulatoryRadiated 2.RF(FCC restricted band)42.2dBmrequirements andcomplianceIEEE 802.15.4[6]requires max.35%%Measured as defined by IEEE 802.15. 4 6TXPOWER OxE5. f= EEE 802.15. 4 channels13TXPOWER= OXD5. f= EEE 802.15.4 channelsTXPOWER= OXC5 f= EEE 802.15.4 channelsMax error∨ ectorTXPOWER OxB5 f= IEEE 802.15. 4 channelsMagnitude(EVM)TXPOWER OxA5. f= IEEE 802.15.4 channelsTXPOWER 0X95. f= IEEE 802. 15.4 channels643333%%%%%%%TXPOWER= 0x85. f= iEEE 802. 15.4 channelsTXPOWER =0x75 f= IEEE 802. 15.4 channels%TXPOWER= 065. f= iEEE 802. 15.4 channelsThe RF output power of the CC2530- CC2591 EM is controlled by the 7-bit value in theCC2530 TXPOWER register. Table 4.6 shows the typical output power and currentconsumption for the recommended power settings The results are given for Tc= 25 C, Vdd3.0V and f= 2440 MHz, and are measured on the cC2530-CC2591 EM reference designwith a 50 Q2 load. For recommendations for the remaining CC2530 registers, see Chapter 8 oruse the settings given by SmartRF StudioOXE520166OxD519149OxC18138OxB517127OxA5161150x95141000x8513940X75860x651079Note that the recommended power settings given in Table 4.6 are a subset of all the possibleTXPOWER register settings. However, using other settings than those recommended mightINSTRUMENTSPage 5 of 19SWRA308Aresult in suboptimal performance in areas like current consumption, EVM, and spuriousemissionTc=25C, Vdd=3.0V, f=2440 MHz if nothing else is stated All parameters are measuredon the CC2530-CC2591EM reference design with a 50 32 load2221-2V201918171611121314151617181920212223242526251510OxE5OxC5OxA50X850x65540-30-20-1001020304050607080ISTRUMENTSPage 6 of 19SWRA308A98Avg 3.6VAva 3vAvg 2V110111213141516171819202122232425261023.6V-1062V-110-40-30-20-100102030405060708070604020-Wanted signal at:-82 dBm10ISTRUMENTSPage 7 of 19SWRA308ACC2530-CC2591EM High Gain ModeC C2530-CC2591EM Low Gain Mode- CC2530EM40000-100110100908070-60-50-40-30-20-100The IEEE standard 802.15. 4 [8] requires the transmitted spectral power to be less than thelimits specified in table 4.7If-fc>3.5 MHz-20 dB-30 dBmThe results below are given for Tc=25 C, Vdd=3.0V and f= 2440 MHz, and are measuredon the CC2530-CC259 1EM reference design with a 50 Q loadIEEE absoluteChannel 182432.52435243752442524452447.5ISTRUMENTSPage 8 of 19SWRA308AOnly a few external components are required for the CC2530-CC2591 reference design. Atypical application circuit is shown below in Figure 5.1. Note that the application circuit figuredoes not show how the board layout should be done. The board layout will greatly influencethe RF performance of the CC2530-CC2591EM. TI provides a compact CC2530CC2591 EM reference design that it is highly recommended to follow. The layout, stack-upand schematic for the CC2591 need to be copied exactly to obtain good performance. Notethat the reference design also includes bill of materials with manufacturers and part numbersL102 L10=TI INF inductorVDD13cc2530LA 1RF PANTCC2591 RF NFNPA EN(P1 1)i工工I NA FNP:1HGM ENPO 7)T:1Proper power supply decoupling must be used for optimum performance. In Figure 5.1, onlythe decoupling components for the CC2591 are shown. This is because, in addition todecoupling, the parallel capacitors C11, C101, and C131 together with, L101, L102, TL11TL101 and TL131 also work as RF loads. These therefore ensure the optimal performancefrom the CC2591. C161 decouples the AvDD blAs power.The placement and size of the decoupling components, the power supply filtering and thePCB transmission lines are very important to achieve the best performance Details about theimportance of copying the CC2530-CC2591EM reference design exactly and potentialconsequences of changes are explained in chapter 6The RF input/output of CC2530 is high impedance and differential. The CC2591 includes abalun and a matching network in addition to the PA, LNa and RF switches which makes theinterface to the CC2530 seamless. Only a few components between the CC2530 andCC2591 necessary for RF matching For situation with extreme mismatch(VSWR 6: 1 till 12: 1out-of-band as shown in Figure 6.2) it is recommended to include all the components asshown in Figure 5.1ISTRUMENTSPage 9 of 19SWRA308ANote that the PCB transmission lines that connect the two devices also are part of the RFmatching. It is therefore important to copy the distance between the devices, the transmissionlines and the stack-up of the PCB according to the reference design to ensure optimumperformanceThe network between the CC2591 and the antenna(L111, C112, C111 C113 and L112matches the CC2591 to a 50 2 load and provides filtering to pass regulatory demands. C111also works as a dc-blockR151 is a bias resistor the bias resistor is used to set an accurate bias current for internaluse in the cc2591The TI reference design contains two antenna options. As default, the Sma connector isconnected to the output of CC2591 through a 0 Q2 resistor. This resistor can be soldered offand rotated 90 clockwise in order to connect to the PCB antenna, which is a planar invertedF antenna(PIFA). Note that all testing and characterization has been done using the SMAconnector. The PCB antenna has only been functionally tested by establishing a link betweentwo EMs. Please refer to the antenna selection guide [6] and the Inverted F antenna designnote [7 for further details on the antenna solutionsISTRUMENTSPage 10 of 19SWRA308A
- 2020-11-30下载
- 积分：1
