[毕业设计精品]图书信息管理系统设计与实现

目录A1A0A2A3A4A4A5A6A7A8A9A5A6A8A9A5A8A9A10A10A11A12A13A14A152A11A16A13A17A18A19A20A21A223A16A23A12A17A18A19A203A16A23A16A17A18A24A25A26A27A285A16A23A29A17A18A30A31A32A336A16A23A34A17A18A35A31A32A336A16A23A36A17A18A37A38A39A227A11A29A13A17A18A40A41A27A288A29A23A12A42A43A44A45A468A29A23A16A47A48A44A45A27A2810A29A23A34A47A48A49A50A51A52A53A3915A11A34A13A17A18A30A31A53A3915A34A23A12A54A55A56A57A4615A11A36A13A58A59A53A3919A36A23A12A47A48A60A50A61A62A53A3919A36A23A16A63A64A65A66A67A68A69A70A71A72A73A50A74A6423A36A23A29A45A75A44A45A4623A11A76A13A17A18A77A78A79A8026A76A23A12A81A45A82A83A50A84A8526A76A23A16A17A18A77A86A87A88A89A67A90A87A84A8526A76A23A29A17A18A91A25A92A93A9429A11A95A13A17A18A53A39A30A9631A95A23A12A17A18A50A97A9831A95A23A16A17A18A50A84A8532A95A23A29A17A18A50A99A10033A95A23A34A31A10133A96A102A10334A104A10535A106A107A108A10936A110A111A11237A110A111A113412第1章前言随着我国经济的高速发展，人们的物质需求已趋向饱和，而精神上的需求却日益提高。学习的繁重、工作的压力、竞争的刺激使人们感到知识的困乏，渴望进一步的充电。而阅读书籍无疑是较好的途径，因此近几年每逢节假日图书馆总是人丁兴旺，来满足人们的各种需求。在计算机技术与信息技术迅猛发展的今天，作为信息系统核心和基础的数据库技术得到了越来越广泛的应用。从小型单项事G2165G3800G10714系统到G3835型G1861G1151系统，从一G14336G2842用事G2165G3800G10714到计算机G17753G2173G16786计与G2058G17908G708G38G36G39G18G38G36G48G709、计算机G19610G6116G2058G17908系统G708G38G44G48G54G709、G2162G1856信息系统G708G50G44G54G709、G3332G10714信息系统G708G42G44G54G709G12573G12573，越来越G3822的G7044的应用G20058G3507G18331用数据库G4396G1660和G3800G10714G1194们的信息G17176G9316。G8503是G11013G1122计算机的应用，G6177G7389G2499G14033使G10628G1207G12050G1262G13464G13467和G1237G1006的信息G3800G10714G14033力G17878应G10628G1207G2282G12661G10714的G16213求。G12661G10714信息系统是G1820进的G12197学技术和G10628G1207G12661G10714G11468G13479G2524的G1147物，G5326G12447G1209计算机为G1039G16213G6175G8585的G12661G10714信息系统，已G6116为G10628G1207G1237G1006、G6931G5232G18108G19388G12573各G12879G13464G13467提高G14270G17535G13044质、G4466G10628G13464G13467的G6124G11065G11458G7643。因此，为满足图书馆G1006G2165发展的需G16213，提高竞争G14033力，图书馆G1927G4462G2045用计算机G2282来提高G12661G10714G8712G5191和工作G6940G10587，G6116G12447一G1022工作小G13464来G17139G17143图书G1523阅G12661G10714系统的G5332发。G7693据G1006G2165的需G16213，G11842G4462G7044系统G16213G4466G10628G1128G1022基G7424G2163G14033G726图书G17176G7021G12661G10714、读G13785G17176G7021G12661G10714、G1523书G6817作、G17836书G6817作、G7609G16822G3800G10714。G2528G7114G16825系统G1867G7389G5390G3835的G7609G16822G2163G14033和G2499G19764G5627。3第2章系统调查规划21系统调查系统G16855G7609的G1039G16213G1881G4493G7389G726系统的基G7424G5785G1929、系统G1025信息G3800G10714的G10378G1929、系统的G17176G9316G5785G1929G2462系统的各G12879人G2604G4557信息系统的G5589G5242。带着上述问题，我G3822次走访了图书馆的G20058导，G4557G4466际G6817作人G2604进行了G3822次联系和G16855G7609，了解了G4466际的G1006G2165G6817作流程G5785G1929。G16855G7609G13479果概述G726图书馆G10628在藏书七十余万册，分为G12050G1262，人文，哲学，4数G10714，工G1867，期刊G12573六G3835G12879。图书馆的G1039G16213G1006G2165是图书G1523阅，信息G12661G10714，G17176G7021G7609G16822，G17176G7021G12661G10714。图书馆的G13464G13467机构G16786置如下G726图21图书馆的G13464G13467机构图书馆信息G3800G10714G10378G1929G7261G1006G2165G12661G10714工作缺乏规范G5627，随意G5627很G3835，G4557人的经验G8712G5191很G3835的依赖G5627。2G17176G7021G3822次G6175工G3800G10714，如逾期通知G12573，出错G10587高，完全G2499G1209用数据库检索G14270动生G6116。A114A115A116A117A118A119A120A121A122A123A121A124A123A121A125A126A121A127A128A129A130A131A132A133A123A125A126A134A135A136A137A129A130A138A139A140A141A142A140A143A144A140A136A137A14053数据重复G10587高，G7389些G3332方人G2604G3822次使用G11468G2528数据，G7389些信息完全G2499G1209归G12879。4缺乏统计工作。22系统可行性分析G2499行G5627分析G4557系统的G5332发至关重G16213，G2499G1209G3835幅减少不必G16213的损失，保证系统G5332发的顺G2045进行。因此G16213G4557系统进行技术G2499行G5627、经济G2499行G5627、营运G2499行G5627三方面的系统G2499行G5627分析G726221系统开发技术可行性近几年来计算机技术发展异常迅猛，高速G5242G3835G4493量的电脑已G6116为许G3822G1856司日常工作必不G2499少的G16786备，推动G2162G1856G14270动G2282的软件不断涌G10628，微机的普G2462为G16825系统的G5332发奠G4462了坚G4466的基础。编G2058软件G18331用VFP编程语言，VFP是面向G4557象程序G5332发的G10714想语言，G5332发接口好，G17878G2524非计算机人G2604使用。222系统开发经济可行性一方面，G7044系统的G5332发不需G16213额外增加G16786备购置费、软件G5332发费、G12661G10714和维护费用，且人G2604培训过程简单费用不G3822。另一方面，G7044系统的G5332发G2499G1209较好G3332解G1927图书馆因G1006G2165繁杂而G17908G6116的G3800G10714G6940G10587低，出错G10587偏高的局面，并G2499G1209G2462G7114了解各项G1006G2165的进展G5785G1929，为G2462G7114G16855整经营G1927策提供G2499G19764的数据支G6357，从而提高经济G6940益，G2528G7114G17836G2499G1209减少人工G2183动、提高工作G6940G10587、G6205G3835G1006G2165量和竞争G14033力。223系统营运可行性计算机G1209G5390G3835的信息G3800G10714G14033力作为人G12879脑力G2183动的G7389G2045G2173G6175G11343上G2394G2502G14322G2500G2530，G1209G9195G17891到G12050G1262生G8975的各G1022G20058G3507，使G10628G1207G12050G1262G13464G13467、G10317G2047是G1237G1006的6信息G3800G10714G14033力G17878应G10628G1207G2282G12661G10714的G16213求，且系统G17892步从单项事G2165信息G3800G10714系统迅速向G13520G2524G7393G2165G708G1927策支G6357系统G709的G12661G10714信息系统发展。G7424系统使用G11040面G14403好，G7143G1122G6817作。图书馆G6329G7389一G6221较高G13044质的G2604工，G2494需进行G11713期的培训，G4613G2499G10099G13463G6817作G7424系统了。通过G1209上分析，图书馆信息G12661G10714系统的G5332发在经济上、技术上、营运上G18129是G2499行的。23系统总体目标图书馆信息G12661G10714系统的总G11458G7643是G6365G10043G12661G10714信息系统的G12661G10714和G5332发方G8873，G18331用G1820进的信息技术和G6175G8585，支G6357并规范图书和读G13785G17176G7021的G12661G10714，G1523G17836书和G7609G16822G6817作的全过程，并加G5390上述过程G1025各种信息G17176G9316的G12661G10714和应用，提高各G18108G19388G12661G10714工作的G10628G1207G2282G8712G5191，G4466G10628各G18108G19388信息的G1946G11842、G2462G7114G3800G10714和G8819通G2462G1861G1151，为图书馆G1006G2165G1927策提供G7389G2045的支G6357和G2465G20316信息，G1209G4466G10628图书馆的总G1319G11458G7643。24系统具体目标1G7693据图书阅G16284G6502行G8048G7368G7389G19036G4557G5627G3332G18331购读G13785G2928G8438的书，提高读G13785满意G5242。2G2045用G2465G20316信息，外G1523G18108提出G7368方G1427读G13785的G1523阅规程G708如G20056G16758，G13505G1523G12573G709。3加G5390并提高读G13785G7393G2165G1025心的G1006G2165G12661G10714G8712G5191，提高工作G6940G10587。4G4466G10628G5390G3835的G7609G16822G2163G14033，G7368好G3332G4466G10628信息的G2462G7114G8819通，为G1927策提供支G6357。725系统开发计划系统G5332发G2499分为G1016G1022G19466G8585G726G12544一G19466G8585进行系统G2033步G16855G7609、系统分析、需求分析、G16826G13466G16786计，G11023出G1006G2165流程图，数据流程图，数据G4395G1868，程序流程图。G12544G1120G19466G8585进行程序的编G1901。G2045用VFP进行程序的G4466际编G1901、G8991G16809、G4445G16025G2462人G2604培训。8第3章系统需求分析需求分析G19466G8585的G7693G7424G1231G2165是G16213G7138G11842图书馆在G1927策和G1006G2165上的信息需求，G1209G1427提出整G1022系统的总G1319方G7708。在需求分析G1025，G1039G16213G18331用G1006G2165流程图，数据流程图和数据G4395G1868来G6563述。31业务流程图通过G4557图书馆的G20058导与G11468关G1006G2165人G2604的G3822次联系和G16855G7609，G3835G14280了解了图书馆的日常的G1006G2165流程。1图书G17176G7021的G12661G10714图书G18331购G2604G4570图书G18331购G9177单G2462书籍G1144G1122图书保G12661G2604，保G12661G2604G4469核G18331购单和书的G2529G12228、数量是G2554一G14280。不G2524G7696G2029G17876G17836G13485供书G2842，G2524G7696G2029G13485供书G2842G18331购G3250单，并G4570G18331购单G8731总。图书G1849库分G12879G3800G10714，G2528G7114G5326G12447G16825G6221图9书G17176G7021信息。如果G16825书已G7389，G2029G10628G7389书数G12573G1122G2419G7389书数加G7044增书数。保G12661G2604G1075G4570G2162G1856G4472G4469核的图书G6265G5235单G2462图书G1144G3250G6922G12461G6265G5235G3800G10714，G4570G6265G5235单G8731总，G2528G7114G1474G6925图书G17176G7021库，如G7389图书损G3363G2462G13614G8466G3800G10714，G1075G1474G6925图书G17176G7021库。2读G13785G17176G7021G12661G10714读G13785G4570G3647G7389G14270G17535G4007G2529、G3332G3348、联系电G16817G12573信息G17842G2528G2162证费G1144G12661G10714G2604，G8892册G12661G10714G2604经G4469核无G16835G2530G2162G10714读G13785G1523阅证，G13485读G13785编G2507，并G4570G2419G3999信息G11053G5225G2530，在读G13785G17176G7021G1025G7044增G16825G6155信息。如果读G13785G7368G6925G3332G3348G12573G1022人信息，G2029在G11468应的读G13785G17176G7021G1025进行G1474G6925。如果读G13785G16213求G6776G9052G1523阅证，G2029G4469核G16825读G13785是G2554G7389逾期书籍和损G3363，如无，G2029G2162G10714G6776G9052G1006G2165，G2528G7114在读G13785G17176G7021库G1025G2036G19512G16825读G13785。3G1523书G6817作读G13785G6238G1523阅证G2462G1523书信息G1144G13485图书G12661G10714G2604，图书G12661G10714G2604进行G4469核，如G16825读G13785G7389G7422G17836图书G2462G1866G1194G2419因，G2029通知G16825读G13785。G2554G2029G7609G16825书是G2554G17836在书库，如G7422G1523G2029图书保G12661G2604书库G2474书，G1144G13485读G13785。并G1474G6925图书、读G13785G2462读G13785G1523阅库。如读G13785逾期G2029G2499电G16817联系。如G16825书已G1523出G2029在图书G17176G7021库G1025G16772G5417读G13785编G2507G2462联系电G16817G13485G1116G20056G16758。如读G13785G13505G1523，G2029G5322G19283读G13785G17836书日期。G4570每日G1523书信息G4396G7735。4G17836书G6817作读G13785G6238G1523阅证G2462书G1144G13485图书G12661G10714G2604，图书G12661G10714G2604进行G4469核，如G16825书G7389逾期G6122G11784损，G2029通知G16825读G13785G6365G8616G1375G13614G8466。G2554G2029书G1144图书保G12661G2604G6930G3250书库。并G1474G6925图书、读G13785G2462读G13785G1523阅库。读G13785G17963失书G7424G2029G13485G1116G2419G1227G1128G1505赔偿。G4570每日G17836书信息G4396G7735。105G7609G16822G3800G10714读G13785到G7609G16822G3800G7609G16822图书是G2554G7422G1523，图书是G2554逾期，近期图书G6502行G8048。咨G16822G7609G16822G2604G2499在图书到期前一天打印逾期G9177单，电G16817联系读G13785，G1209方G1427读G13785G1523阅。并G4570G7609G16822G13479果告知读G13785。G4570每日G7609G16822信息G4396G7735。6系统维护A14531A146A147A148A149A14532数据流程分析数据流程图是一种G14033全面G6563述信息系统逻辑模型的G1039G16213工G1867,G1075是系统分析人G2604与用G6155进行G1144流的G7389G6940G6175G8585。G7424系统的数据流程图G6238握住G4557系统总G1319G11458G7643与总G1319G2163G14033的G16213求,基G1122上述的G1006G2165流程图,从G12197学G5627,G2524G10714G5627和G2499行G5627G1849G6175,G18331用G14270顶向下,G17892层分解的方G8873G5326G12447了G7424G12661G10714信息系统的逻辑模型,G13520G2524G3332G2465映出信息在G7424系统G1025的流动,G3800G10714和G4396G1660,G1867G7389抽象G5627和概括G5627数据流程图符G2507G11013四种基G7424G6116分G13464G6116A150A151A152A153A154A155A156A150A151A157A158A150A151A159进G1849系统图书管理用户管理借书操作还书操作资料查询系统维护退出系统11关联图G726表G7138G7424系统作用的范围和边G11040即系统总G3800G10714的G2163G14033和输G1849输出的数据流，G2528G7114G11842G4462了系统的边G11040和外G18108项。G7424系统的外G18108项为读G13785，供书G2842，G3250G6922G12461和统计G2604。它们与系统间G7389信息流F1F14，F16。A160A161F9F11F10F12A160A161A162A160A161A163A164A165A166A167A168A160A169A165A166A167A168A170A171A160A162A172A173A167A168A160A174A172A173A167A168A170A171A160A161A175A176A173A167A168A160A177A176A173A167A168A170A171A160A175A163A164A178A179A167A168A160A180A178A179A181A182A160A183A184A185A167A168A160A186A184A185A187A188A160A161A189A190A191A188A160A161A161A190A191A188A187A188A160A161A169A172A173A192A193A194A195A160A161A162A176A173A192A193A194A195A160A161A174A178A179A192A193A194A195顶层图G726G6365关联图分析，G7424系统分为G1128G1022G1039G16213的G13520G2524的逻辑G2163G14033。即图书G17176G7021G12661G10714，读G13785G17176G7021G12661G10714，G1523书G6817作，G17836书G6817作，G7609G16822G3800G10714。它们间的输G1849输出数据流为F20F25，数据G4396G1660为G391G393。A19632A197A198A196F4F16F5A163A164A199A200A201A187A202A203A204A173A205图书借阅管理系统F3F8F2F7F6F1F4F25F23F21A199A200A201A204A173A205A187A202A203F9F1F1P1A206A207A208A209A210A211F20D1A196A173A212A213F8A163A164F2P2A163A164A212A213A214A215P4A176A173A216A217P3A172A173A216A217FD2A163A164A212A213F22F16F5FF22D3A163A164A172A218A219F24P5A178A179A220A215F7F23F26F23F13F12F1412A196A162A221A162A214A215A222A223A196A160A169A189A196A173A224A225A226A192A193A160A169A161A163A164A224A225A226A192A193A160A169A169A163A164A212A213A167A168A160A169A162A196A173A212A213A167A168A160A169A174A163A164A172A218A167A168A160A169A177A172A173A167A168A160A169A175A176A173A167A168P1G726图书G17176G7021G12661G10714图34数据流程图的G12544一层分解图图书G17176G7021G12661G10714分为1115G1128G1022子模块,G7044G1147生数据流F31F36,数据G4396G1660G3911G3914P2读G13785G17176G7021G12661G10714A163A164P21A163A164A167A168A227A228A229A230A231A232D15A233A234A165A166A235A236A167A168P24A237A238A163A164A235A236P23A239A226A163A164A235A236P22A165A166A163A164A235A236D17A233A234A237A238A167A168D16A233A234A239A226A167A168P25A163A164A212A213A240A241A220A215F1D2A163A164A212A213A219F41F48D18A165A166A235A236A167A168F47D19A239A226A235A236A167A168D20A237A238A235A236A167A168F49F33P11A196A173A242A219A231A232A204A173A205A187A202A203P15A196A173A194A195A220A215P14A225A243A229A230A196A173P12A244A224A229A230A196A173P13A196A173A187A202A231A232A196A173A212A213A219D1F9F8D11A184A185A188A194A195F31F34F10F11F32F33F35F36F20D13A244A224A229A230A173A188A190A191A188A194A195D12D14A225A243A229A230A173A188F3613图35读G13785G17176G7021G12661G10714读G13785G17176G7021G12661G10714分为2125G1128G1022子模块,G7044G1147生数据流F41F49,数据G4396G1660G3915G3920P3G1523书G6817作图36G1523书G6817作G1523书G6817作分为3135G1128G1022子模块,G7044G1147生数据流F51F59,数据G4396G1660G3921G3926P4G17836书G6817作F44F47F5F61F66F64F16F62A163A164A233A234A176A173A167A168D27P41A176A173A231A232A163A164A212A213A219D2A196A173A212A213A219D1P43A245A246A220A215P42A163A164A176A173,A173A176A173A219A247A248A245A246A167A168D2P44A176A173A216A217A240A241F13F26F63F22F23F65A163A164A172A218A219D3A199A200A176A173A167D29A245A246A167D30A163A164A233A234A176A173A167A168D27P41A176A173A231A232A163A164A212A213A219D2A196A173A212A213A219D1P43A245A246A220A215P42A163A164A176A173,A173A176A173A219A247A248A245A246A167A168D2P44A176A173A216A217A240A241F16F5F13F26F61F62F63F22F64F65F66A163A164A172A218A219D3A199A200A176A173A167D29A245A246A167D30F6614图38G17836书G6817作G17836书G6817作分为4144G1128G1022子模块,G7044G1147生数据流F61F66,数据G4396G1660G3927G3930P5G7609G16822G3800G10714图39G7609G16822G3800G10714G7609G16822G3800G10714分为5155G1128G1022子模块,G7044G1147生数据流F71F82,数据G4396G1660G3931G3936A160A162A161A249A231A232A250A184A185A188A160A162A169A196A173A184A185A188A194A195A160A162A162A244A224A229A230A196A173A212A213A167A168A160A162A174A249A231A232A250A190A191A188A160A162A177A190A191A188A194A195A160A162A175A225A243A229A230A196A173A212A213A167A168A160A174A161A249A231A232A163A164A165A166A167A168A160A174A169A249A231A232A163A164A239A226A167A168A160A174A162A249A231A232A163A164A237A238A167A168A160A174A174A233A234A165A166A235A236A167A168A160A174A177A233A234A239A226A167A168A160A174A175A233A234A237A238A167A168A160A174A180A249A165A166A235A236A167A168A160A174A183A249A239A226A235A236A167A168A160A174A186A249A237A238A235A236A167A168A160A177A161A249A231A232A172A173A167A168A160A177A169A233A234A172A173A167A168A160A177A162A172A173A167A168A160A177A174A249A231A232A251A172A167A168A160A177A177A233A234A251A172A167A168A160A177A175A251A172A167A168A160A177A180A249A231A232A252A253A167A168A160A177A183A233A234A252A253A167A168A160A177A186A252A253A167A168P55A178A179A227A228A240A241A163A164P51A178A179A227A228A229A230A178A172A173A254A255A247A248D31A173A53A0A1A2D36P53A178A173A254A255A23A219P52A178A172A173A247A248A196A173A212A213A219D1A163A164A172A218A219D3P54A178A173A53A0A1A2A199A200A201A178A173A254A255A3A172D32A178A173A53A0A1A2D33A247A248A173A110A188D34A196A173A23A219A110A188D35F24F24F6F7F71F72F73F74F75F76F77F78F79F80F81F82F23F1415A160A175A161A249A231A232A176A173A167A168A160A175A169A233A234A176A173A167A168A160A175A162A176A173A167A168A160A175A174A247A248A245A246A167A168A160A175A177A247A248A245A246A167A168A160A175A175A245A246A167A168A160A180A161A178A173A254A255A247A248A160A180A169A178A173A254A255A247A248A167A168A160A180A162A247A248A173A167A168A160A180A174A247A248A173A110A188A160A180A177A178A173A254A255A3A172A160A180A175A178A173A254A255A3A172A167A168A160A180A180A178A173A254A255A23A219A160A180A183A196A173A23A219A110A188A160A180A186A178A173A53A0A1A2A160A183A189A178A173A53A0A1A2A167A168A160A183A161A173A53A0A1A2A160A183A169A173A53A0A1A2A167A16834数据项的代码设计G7424系统G1861G18331用三种编码形式G7261G4557读G13785编G2507，为了G1427G1122G7609找G18331用层次码如0310010012图书编G2507，为了G1427G1122得到G7389关信息G18331用层次码如TP311101G8892G726G1881G18108编G2507G726G2528G7114G18331购了G1128G7424G11468G2528的图书，在G12879G2047和编G2507G11468G2528的G7114候，用01，02，03，04，05分G2047G1207表这G1128G7424G11468G2528的图书。G12879G2047TPG726计算机G12879VG726艺术G12879G50G726数G10714G2282G44G726文学G12879HG726英语G12879第4章系统总体设计41HIPO图整G1022信息G12661G10714系统G11013上而下分解为图书G17176G7021G12661G10714，读G13785G17176G7021G12661G10714，G1523书G6817作，G17836书G6817作，G7609G16822G3800G10714，系统维护六G1022子系统。它们位G1122G7424系统HG44PG50图的G12544G1120层。A126A4A5A6A129A7A131A8A5A6A5A6A94A916图41HG44PG50图图书G17176G7021G12661G10714又分为图书G1849库G4469核、G7044增分G12879图书、图书G3250G6922G4469核、G2036G19512分G12879图书、图书G8731总G3800G10714G1128G1022G18108分。G1194们位G1122G7424系统HG44PG50图的G12544三层。A3242A32A10A11A12A13A14A15A16A17读G13785G17176G7021G12661G10714子系统又G2499分为读G13785信息分G12879G4469核、G8892册读G13785G2162证、G1474G6925读G13785G2162证、G6776G9052读G13785G2162证、读G13785G17176G7021G2524并G1128G1022G18108分。它们位G1122G7424系统HG44PG50图的G12544三层。A32A10A18A19A13A14A16A17A32A10A11A12A13A14A18A10A84A85A20A21A11A12A13A14A56A10A84A85A22A24A25A14A16A17A135A136A32A10A11A12A13A14A15A16A17A32A10A105A86A95A96A91A106A93A26A32A10A32A10A71A72A25A14A107A90A93A26A32A10A32A10A64A78A95A9617A3243A20A21A11A12A13A14A15A16A17G1523书G6817作G2499分为G1523书G4469核、书库G2474书书G1523读G13785、G13505G1523G3800G10714、G20056G16758G3800G10714、G1523书G6817作G2524并G1128G1022G18108分。它们位G1122G7424系统HG44PG50图的G12544三层。图44A18A10A84A85A15A16A17G17836书G6817作G2499分为G17836书G4469核、读G13785G17836书书G17836书库、G13614G8466G3800G10714、G17836书G6817作G2524并四G1022G18108分。它们位G1122G7424系统HG44PG50图的G12544三层。A20A21A11A12A13A14A15A16A17A20A21A48A49A93A26A95A96A100A101A20A21A27A99A20A21A11A12A103A104A46A47A20A21A27A99A102A92A20A21A27A99A18A10A84A85A15A16A17A18A10A95A96A115A116A25A14A18A10A84A85A103A104A10A86A137A10A10A18A20A21A114A18A25A1418A3245A56A10A84A85A15A16A17G7609G16822G3800G10714G2499分为G7609G16822G1006G2165分G12879、G7609G1523书逾期、G7609书是G2554在库、G7609书籍G6502行G8048、G7609G16822G1006G2165G2524并G1128G1022G18108分。它们位G1122G7424系统HG44PG50图的G12544三层。A3246A22A24A25A14A15A16A17系统维护子系统G2499分为数据恢复、数据备份、用G6155权限G12661G10714。A56A10A84A85A15A16A17A56A10A95A96A56A10A84A85A103A104A20A21A56A10A86A108A109A25A14A22A24A25A14A15A16A17A22A24A28A29A93A26A22A10A117A118A123A86A22A18A10A30A111A22A10A119A120A121A122A22A24A28A29A103A104A35A36A138A139A140A141A142A143A13A14A35A36A144A145A16A17A135A136A15A16A1719A3247A16A17A135A136A15A16A17第5章详细设计51数据库的逻辑设计G7693据关系模式的G16786计，为G7424系统数据库G16786置G1039键、外键，G1866G1025G1039键唯一表示G16825数据库的属G5627。形G6116数据库的文件如下G7261单位数据G13479构G4395G8585G2529G4395G8585G1207码G4395G8585G12879G4395G8585G19283G5242G1039键外键单位G2529G39WG48G4395符10YG3332G3348G39ZG4395符20联系电G16817LXG39HG4395符11邮编YBG4395符62G1523书证数据G13479构G4395G8585G2529G4395G8585G1207码G4395G8585G12879G4395G8585G19283G5242G1039键外键G1523书证G2507JG54ZHG4395符10Y单位G2529G39WG48G4395符10Y读G13785G2529G39ZG48G4395符8读G13785G3332G3348G39ZG39ZG4395符20联系电G16817LXG39HG4395符113G13614G8466单20数据G13479构G4395G8585G2529G4395G8585G1207码G4395G8585G12879G4395G8585G19283G5242G1039键外键G13614G8466编G2507FKBHG4395符10YG1523书证G2507JG54ZHG4395符10Y书G2507G54HG4395符10逾期日期YQRQ日期8逾期金额YQJE数G43957经G2162人G2507JBRHG4395符34图书数据G13479构G4395G8585G2529G4395G8585G1207码G4395G8585G12879G4395G8585G19283G5242G1039键外键书G2507G54HG4395符10Y书G2529G54G48G4395符28作G13785ZZG4395符8G1227G7696JG42数G43957G1523阅次数JYG38G54G4395符2是G2554G1523出G54FJG38G