图书管理系统实验报告

目录A1A3A0A2A4A53A1A6A1A3A0A2A4A53A1A6A7A10A8A9A11A12A134A7A16A14A15A17A18A194A7A6A1A22A20A15A17A18A194A7A6A1A6A1A16A14A21A23A24A254A7A6A1A6A7A16A14A26A27A28A295A7A6A1A6A30A16A14A26A27A31A327A30A16A14A33A349A30A6A1A16A14A35A16A36A37A38A39A21A42A409A30A6A7A16A14A10A8A41A43A44A17A38A45A46A47A4810A30A6A30A26A27A49A16A14A36A3710A30A6A50A16A14A51A52A38A36A3710A30A6A53A26A27A49A33A34A54A39A2112A30A6A53A6A1A26A27A49A33A3412A30A6A53A6A7A26A27A49A39A2117A30A6A53A6A30A33A55A58A56A57A59A26A27A6034A50A16A14A39A2141A50A6A1A63A35A33A34A54A39A2141A50A6A7A22A20A61A62A64A65A33A34A54A39A2141A50A6A7A6A1A61A62A63A35A33A3441A50A6A7A6A7A68A66A33A3442A50A6A7A6A30A70A71A67A73A74A69A72A58A75A59A76A77A78A79A82A48A80A81A33A3443A50A6A7A6A50A70A85A83A73A74A69A80A81A33A3444A50A6A30A29A84A86A87A88A89A90A64A65A33A34A54A39A2144A50A6A30A6A1A29A84A87A88A89A90A91A92A64A65A72A33A34A54A39A2144A93A94A95A96A97A98A99A100A101A102A1032A50A6A30A6A7A29A84A104A62A105A106A64A65A72A33A34A54A39A2146A50A6A30A6A30A107A108A104A62A105A106A64A65A72A33A3447A50A6A30A6A50A22A20A104A62A105A106A64A65A72A33A3449A50A6A50A29A84A86A109A25A51A52A64A65A33A34A54A39A2150A50A6A50A6A1A29A84A86A109A25A51A52A91A92A64A65A33A34A54A39A2150A50A6A50A6A7A29A84A110A111A64A65A33A34A54A39A2152A50A6A50A6A30A112A84A113A90A64A65A33A34A54A39A2155A50A6A50A6A50A114A84A113A90A64A65A33A34A54A39A2161A53A16A14A115A11666A53A6A1A16A14A115A11666A53A6A7A115A116A22A117A33A3466A53A6A30A16A14A118A11668A119A16A14A120A068A119A6A1A121A87A88A89A90A122A123A124A61A62A16A1471A119A6A1A6A1A29A84A104A62A105A10672A119A6A1A6A7A107A108A104A62A105A10674A119A6A1A6A30A22A20A104A62A105A10676A119A6A1A6A50A85A83A89A90A68A6677A119A6A7A121A109A25A89A90A122A123A124A61A62A16A1477A119A6A7A6A1A29A84A110A11178A119A6A7A6A7A112A84A113A9081A119A6A7A6A30A114A84A113A9087A119A6A7A6A50A85A83A16A1492A125A126A36A54A35A12793A128A129A130A131A132A133A134A135A136A137A13831可行性研究可行性研究的主要目标是进一步明确系统的目标、规模与功能，对系统开发背景、必要性和意义进行调查分析，从技术可行性、经济可行性、操作可行性等方面进行系统可行性研究，并提出开发系统的初步方案与计划。11可行性研究通过调查分析，图书管理系统的设计与开发有以下三个可行性1技术可行性本系统采用WINDOWSXP作为操作平台，前台开发工具采用DELPHI70,数据库管理系统采用SQLSERVER2000相关技术，该数据库管理系统，有数据间数据复制、备份功能，提高了数据的可行性和安全性，技术开发人员已基本熟练G6496G6581SQLSERVER2000相关技术，G6164以技术G990是可行的。2经济可行性G11840G1226设备G7393G2165G3132G7393G2165G3132G17731G1226WINDOWSXP、WINDOWSSERVER200G22G6122高G13435G7393G2165G3132G17731G1226数据库管理系统SQLSERVER2000G1237G1006G10268G6122标G1946G10268前台开发G17731G1226DELPHI70G1237G1006G10268系统的设计和开发G17165用、系统G17828行和G13512G6264G17165用G6922G11422本图书管理系统可G2474G1207G5468G3822G6175工操作G14422G11477人工开G6915、G14422G11477G17176G9316，提高图书G6940G10587，G1363G7393G2165G17148G18339G7368G990一个G7044台G19466。G22操作可行性该系统G17828行G10627G3671G1314，G11040面G2463G3921，功能G17751G4448G2904，G1363用方G1427，能熟练操作。从工作进G5242安G6502G990G11487G7114间进G5242G1075是可操作的，G6164以G1866操作是可行的。G708G23G709G8873G5471可行性开发的图书管理系统G993G1262G3324G12050G1262和G6931G8847G990G5353G17227G1417G7447G6122G1866G1194G17143G1231G19394G20076。通过以G990分析，开发的图书管理系统G3324技术、经济、操作、G8873G5471G990是可行性。通过以G990分析，开发的图书管理系统G3324技术、经济、操作G990是可行性。A139A140A141A142A143A144A145A146A147A148A149412工作进度安排数据库开发G3835G3423G4466G20576进G5242安G6502G3926下G17227G8502G7114间G19466G8585G1231G2165要G9869G272G97G27G25G1231G2165分工G4448G6116系统G19668G8726分析和系统设计G277G97G271G22数据库G4466G10628、系统开发G271G23G97G2717G2345G1815G8991G16809、调G16809G6788G1901数据库开发G3835G3423G4466G20576G6265G2590G271G27G7828查数据库开发G3835G3423G4466G20576G6265G2590和系统G271G28G4448G2904数据库开发G3835G3423G4466G20576G6265G2590和系统G2720提G1144G1457G4396数据库开发G3835G3423G4466G20576G6265G2590G11017G4388G12307G9316G12255G5219等G17176G7021的G1821G114362系统需求分析数据库G5224用系统开发的G12544一步是系统G19668G8726分析，G17837G7411间，要对用G6155进行G2465复的调研和G8731G5647，G4570G19668G8726分析G13479G7536用数据G8981图、数据G4395G1868和IPO图G6122HIPO图表示，得出系统对数据和功能的G19668G8726。21用户需求分析211系统现有业务通过对G10628行图书馆G1006G2165的调查，明确了图书馆工作由图书管理、读者管理、借书G7393G2165和还书G7393G2165G23部分组G6116。用G6155对G10628有系统功能的描述G3926下。G7081G709图书管理对馆内的G6164有图书按类别统一编码；对各类图书建立图书登记卡，登记图书的主要信息。G7044购图书要编码和建卡，对遗失的图书要注销G1866图书登记卡。G7082G709读者管理建立读者信息表，对读者统一编码。对G7044加盟的读者，G4570G1866信息加入到读者信息表中；对某些特定的读者，G4570G1866信息从读者信息表中删除。当读者情况变化G7114，修改读者信息表中相G5224的记录。G708G22G709借书G7393G2165未借出的图书要按类别G990架，供读者查G11487。A150A151A152A153A154A155A156A157A158A159A1605建立借书登记卡，卡G990记录着书号、读者姓名和编号、借书日G7411；G4570借书登记卡按读者G2345位、读者编号集中G1457管。读者提出借书请G8726G7114，先查G11487该读者的借书卡，统计读者已借书的数G18339。G3926G7536该读者无借书超G7411G6122超G18339情况，则办理借书G6175续。办理借书G6175续的方G8873是填G1901借书登记卡，管理员核G4466后读者可G4570图书带走。G708G23G709还书G7393G2165读者提出还书要G8726G7114，先对照相G5224的借书卡，确认书号和书名无误后可办理还书G6175续。办理还书G6175续的方G8873是G3324借书卡G990填G1901还书G7114间、管理员签名；G4570已还的借书卡集中G1457管；G6922回图书。G4570G6922回的图书G990架，供读者查G11487和借阅。212系统数据流图G10628行的G1006G2165G8981G12255通过数据G8981图表示，图书管理系统顶层数据G8981图G3926图21G6164示。A16121A162A161A163A164A165A166A167A168A169A170A171A172A173A161A174A175A176A177A178A179A180A181A182A183A1846A161A185A186A185A162A161A163A164A165A166A167A168A187A170A171A172A173A161G3324图书管理系统顶层数据G8981图中，“内部管理和“借书管理两个处理框功能都太复杂，对它们进一步细化后得出1层数据G8981图。图2G22是对“内部管理细化为图书管理和读者管理两个G4388处理框的G8981图。A16123A162A161A163A164A165A166A167A1681A170A171A172A173A161A188A188A189A190A191A164A165A192“借书管理”处理框中包括“借书处理”、“还书处理”和“查G11487书目”三个G4388处理框，G1866细化数据G8981图G3926图2G23G6164示。A16124A162A161A163A164A165A166A167A1681A170A171A172A173A161A188A188A189A193A163A164A165A192G8731G5647后得到的系统数据G8981图，G3926图25G6164示。A174A175A176A177A178A179A180A181A182A183A1847A194A195A196A197A198A199A200A201A202A201A196A197A203A204A194A205A206A207A198A199A200A201A202A208A206A207A203A204A196A197A209A210A206A207A209A210A200A211A212A213A203A204A214A215A216A217A194A218A214A215A198A199A206A207A196A197A196A197A196A197A219A220A206A207A219A220A203A204A221A203A204A221A219A220A206A207A222A223A224A225A200A208A202A201A226A227A197A228A214A215A216A217A206A207A229A197A230A231A200A208A202A208A229A197A232A204A200A208A202A211A208A233A197A232A204A194A234A229A197A198A199A194A195A196A197A198A199A194A205A206A207A198A199A214A215A216A217A196A197A209A210A235A236A237A238A16125A239A240A241A242A161A163A164A165A166A167A171A172A173A161213系统数据字典图书管理系统数据G8981图中，数据信息和处理过G12255G19668要通过数据G4395G1868才能描述清楚。图书管理系统的数据G4395G1868，主要对数据G8981图中的数据G8981、数据G4396储和处理过G12255进行说明。1数据G8981的定义图书管理系统的主要数据G8981定义G3926表21G6164示。A24321A244A245A242A171A172A173A246A247A243A248A249A250A251A252A253A254A255A246A247A171A172A173A28A138A0A140A1A21A161A163A31A3A161A163A145A4A5A6A5A161A163A145A4A185A6A7A147A8A149A86A9A10A149A11A12A149A163A250A149A246A72A149A153A13A155A156A14A5A187A187A187A158A156A15A5A187A187A1582A98A12A31A3A98A12A145A4A5A6A7A160A250A149A161A252A149A16A8A149A162A17A156A18A165A187A187A187A187A156A15A5A187A187A187A1583A164A165A91A31A164A165A91A145A4A7A22A19A250A149A166A20A156A18A5A187A187A158A156A15A5A187A158A174A175A176A177A178A179A180A181A182A183A1848A34A22A19A21A23A4A7A145A168A4A5A6A5A24A4A5A6A185A24A4A185A6A5A24A4A185A6A7A25A171A172A26A22A19A173A190A191A164A165A91A173A100A27A164A165A91A174A156A15A185A187A187A187A158A156A29A30A5A187A187A1585A193A163A103A32A98A12A145A185A6A5A147A8A173A163A250A156A15A5A187A187A187A158A156A29A30A7A187A187A1586A105A163A103A32A98A12A145A185A6A7A98A12A149A161A163A31A3A156A15A5A187A187A187A158A156A29A30A7A187A187A1587A161A163A33A34A4A185A6A5A145A185A6A185A180A35A163A249A149A98A12A36A249A156A15A5A187A187A187A158A156A29A30A185A37A187A1582数据G4396储的定义图书管理系统的主要数据G4396储定义G3926表22G6164示。A24322A244A245A242A171A172A130A38A246A247A243A36A249A250A251A180A35A180A86A254A255A171A172A28A130A183A186A39A130A183A40A41A189A42A59A5A161A163A95A43A4A5A6A5A4A185A6A5A24A4A185A6A185A24A4A185A6A7A163A249A149A147A8A149A86A9A10A149A11A12A149A163A250A149A246A72A149A193A86A155A185A37A187A187A187A187A191A156A15A5A187A187A187A158A192A44A45A165A194A195A46A47A48A199A194A244A245A49A201A44A195A46A163A249A87A50A51A52A16A47A172A53A16A59A185A98A12A95A43A4A5A6A185A4A185A6A185A206A4A185A6A7A36A249A149A160A250A149A161A252A149A16A8A149A162A17A5A37A187A187A187A191A156A15A37A187A187A158A192A44A45A165A194A244A245A49A195A46A45A165A194A112A201A44A195A46A207A244A36A249A87A50A51A52A16A47A172A53A16A206A54A55A56A57A58A70A209A73A210A70A211A73A60A61A62A63A64A65A146A66A67A66A146A66A67A66A68A146A66A67A61A63A69A71A74A75A76A69A71A62A77A78A79A80A81A81A81A81A82A83A84A85A81A81A81A88A89A90A92A93A94A96A97A99A101A102A104A106A94A107A90A193A108A74A75A76A69A58A109A110A111A216A217A113A104A70A74A75A67A76A69A73A94A63A69A58A109A110A111A216A217A113A104A70A114A63A67A63A69A73A94A62A77A78A79A104A115A219A64A65A116A117A84A78A79A221A60A118A119A120A64A65A146A61A146A61A119A120A71A222A110A71A223A55A85A81A81A81A82A83A84A85A81A81A88A89A90A92A93A94A96A193A108A104A106A94A224A121A193A108A221A223A55A58A70A122A123A124A93A125A73A210A70A126A127A124A93A125A733处理过G12255的定义图书管理系统的主要处理过G12255定义G3926表23G6164示。A128A129A131A132A133A134A135A136A137A139A1419A11323A106A142A116A92A93A143A144A148A150A113A143A144A76A69A92A93A143A144A151A152A154A152A157A92A93A159A190A146A85A67A85A114A63A124A93A114A63A124A93A111A119A120A163A164A60A85A227A114A63A167A169A55A170A175A76A110A111A228A114A63A176A177A178A179A181A111A182A184A185A114A63A64A65A113A187A146A85A67A66A74A75A124A93A74A75A188A196A111A119A120A163A164A60A66A231A197A74A75A176A177A113A111A227A74A75A170A175A76A69A94A198A200A74A75A64A65A113A116A202A203A204A205A208A212A57A221A146A66A67A85A213A214A63A215A62A63A218A220A111A60A85A68A119A120A163A164A62A63A218A220A111A114A63A176A177A198A200A225A179A114A63A169A55A213A226A114A63A239A225A179A63A151A229A230A213A226A114A63A116A212A57A221A146A66A67A66A62A63A92A93A114A63A176A177A111A60A85A68A60A66A68A60A61A62A63A64A65A232A233A74A75A234A235A62A63A82A236A111A244A93A62A63A237A246A221A146A66A67A61A238A63A92A93A60A85A68A60A66A68A60A61A68A238A63A218A220A111A114A63A188A196A111A119A120A163A164A60A61A227A217A240A241A116A62A63A242A111A232A233A63A69A243A63A151A245A251A247A248A244A93A238A63A237A246A221A146A61A249A250A124A93A124A93A125A188A196A111A60A118A119A120A163A164A68A60A118A111A124A93A125A188A196A253A143A119A120A243A252A254A111A232A233A119A120A163A164A111A255A1A16A170A116A249A250A54A2213系统设计数据库G5224用系统开发的G12544二步是系统设计，G1866主要G1231G2165是确定图书管理系统的体系G13479构和G4466G10628方G8873、工作G10627G3671，确定系统功能及G13479构，进行数据库的设计。31系统体系结构及实现方法图书管理系统采用C/SG13479构，G3926图31G6164示。A11431A114A63A124A93A16A170A0A16A2A3A128A129A131A132A133A134A135A136A137A139A1411032系统工作环境要求及支撑软件系统工作G10627G3671要G8726及G6915撑G17731G1226G7081G709G7393G2165G3132端的工作G10627G3671要G8726及G6915撑G17731G1226操作系统WINDOWS2000高G13435G7393G2165G3132G10268数据库管理系统SQLSERVER2000G1237G1006G10268G6122标G1946G10268数据库G5224用系统开发G17731G1226DELPHI70G1237G1006G10268G7082G709客G6155机的工作G10627G3671要G8726及G6915撑G17731G1226操作系统WINDOWSG28G27以G990数据库G5224用系统开发G17731G1226DELPHI70G1237G1006G1026833数据库系统结构图书管理系统的数据库系统G13479构采用C/S两层数据库系统G13479构，选择BDEBORLANDDATABASEENGINE技术为G6915持技术，G1866G13479构G3926图32G6164示。A11432A178A179A28A16A170A2A3A11434系统功能及结构数据库G5224用系统的功能模块设计一般通过G17731G1226G13479构图描述，图书管理系统的G17731G1226G13479构图G3926图33G6164示。A128A129A131A132A133A134A135A136A137A139A14111A11433A119A114A63A124A93A16A170A120A49A236A2A3A114图书管理系统包括用G6155登录模块、图书馆管理和图书馆G7393G2165三G3835功能模块，每个模块中还包括若干个G4388模块。G1866中，用G6155登录模块是为G1457G16789数据库G5224用系统的数据安全性G13792设计的，图书馆管理模块G4466G10628图书馆的内部管理功能，图书馆G7393G2165模块G4466G10628图书馆的对G3818G7393G2165功能。图书管理系统功能模块的G17767入数据、G17767出数据和G4448G6116处理等情况通过IPO图描述一个功能模块的G17767入数据、G17767出数据和处理过G12255描述，G1866主要G2454数G3324表31中G2027出。A11331A114A63A124A93A16A170A212A57A229A31IPOA114A116A106A142A216A178A229A31A151A66A4A109A119A109A119A152A154A152A157A92A93A104A5A119A120A22A65A124A93A119A120A22A65A205A208A119A120A151A6A222A110A119A120A163A164A7A8A9A10A243A11A12A213A13A119A120A64A65A111A232A148A119A120A235A5A54A111A163A164A243A101A102A11A119A120A22A65A205A208A119A120A22A65A124A93A16A170A124A93A125A163A164A97A99A119A120A64A65A113A178A179A97A99A119A120A64A65A111A202A219A119A120A111A14A204A119A120A163A164A114A63A15A122A123A124A93A119A120A22A65A124A93A114A63A64A65A205A208A111A74A75A64A65A205A208A111A119A120A6A222A110A205A208A111A85A157A16A170A92A93A122A123A124A93A125A163A164A111A17A18A19A20A21A161A23A89A24A25A26A21A161A206A17A18A19A20A76A21A161A23A27A29A89A24A25A26A21A161A206A30A32A17A18A19A20A206A33A17A34A35A36A37A38A39A40A41A42A43A44A97A40A41A45A89A24A25A26A46A47A48A50A128A51A52A40A41A45A89A24A25A26A40A41A42A43A53A166A40A41A42A43A53A166A54A55A214A56A57A58A239A191A59A60A40A41A61A62A206A63A47A64A65A206A67A68A61A62A69A70A76A40A41A42A43A71A206A227A34A72A42A43A63A47A73A181A239A234A74A60A75A235A98A77A42A43A44A97A40A41A45A89A24A25A26A46A47A48A50A128A51A52A40A41A45A89A24A25A26A98A77A42A43A53A166A98A77A42A43A53A166A54A55A214A56A57A58A239A191A59A60A40A41A61A62A206A63A47A64A65A206A67A68A61A62A69A70A76A40A41A42A43A71A206A227A34A72A42A43A63A47A73A181A239A234A74A60A75A235A78A79A80A81A82A83A84A86A87A88A9012A17A18A91A92A93A44A97A40A41A45A89A24A25A26A46A47A48A50A128A51A52A40A41A45A89A24A25A26A198A235A92A93A94A95A198A235A92A93A94A95A54A55A214A56A57A58A206A227A92A96A99A100A60A182A101A194A67A68A61A62A69A70A76A17A18A71A206A198A235A102A103A17A18A42A43A76A92A93A105A106A40A41A45A107A108A110A111A17A18A112A43A25A26A113A114A40A41A206A115A41A116A26A206A117A41A116A26A206A118A121A122A123A116A26A40A41A45A107A108A110A111A21A161A206A17A18A19A20A76A21A161A23A40A41A45A107A108A110A111A21A161A206A17A18A19A20A76A21A161A23A27A29A40A41A45A107A108A110A111A21A161A206A30A32A17A18A19A20A206A33A17A34A35A76A37A38A39A113A114A40A41A40A41A45A107A108A110A111A46A47A48A50A128A51A52A40A41A45A107A108A110A111A41A124A60A125A126A40A41A42A43A54A55A214A56A57A58A239A191A59A60A40A41A61A62A206A63A47A64A65A206A67A68A61A62A69A70A76A40A41A42A43A71A206A46A47A113A114A206A27A29A113A114A127A129A115A41A116A26A40A41A45A107A108A110A111A46A47A48A50A128A51A52A40A41A45A107A108A110A111A41A130A60A98A77A182A130A40A41A42A43A206A98A77A42A43A91A115A131A42A43A54A55A214A56A57A58A239A191A59A206A63A47A64A65A206A67A68A61A62A69A206A113A114A40A41A206A99A100A98A77A206A229A115A131A71A70A73A181A42A43A206A75A235A40A41A42A43A117A41A116A26A40A41A45A107A108A110A111A46A47A48A50A128A51A52A40A41A45A107A108A110A111A34A72A40A41A42A43A40A41A42A43A54A55A214A56A57A58A239A191A59A206A63A47A64A65A206A67A68A61A62A69A206A229A115A131A71A70A234A74A42A43A206A75A235A40A41A42A43A118A121A122A123A116A26A17A18A112A43A44A97A206A40A41A45A107A108A110A111A206A40A41A45A89A24A25A26A72A132A133A134A53A166A72A132A133A134A53A166A206A72A132A61A62A69A206A135A136A137A13835数据库设计与实现系统设计G7114已经确定了图书管理系统G1363用SQLSERVER2000为数据库管理系统，确定采用BDEG6915持的C/S两G13435数据库系统G13479构。数据库设计的基本G1231G2165是确定数据库类G3423及数据库G13479构；建立数据库；建立数据库G17842G6521。351数据库设计数据库设计的步G20600G7693据系统G19668G8726分析建立G8022G5577模G3423；G4570数据库的G8022G5577模G3423G17728G6454为数据模G3423；进行规G14551化处理，G1363数据模G3423G9397G17287BCNF。1数据库G8022G5577模G3423设计G7693据系统G19668G8726分析，可以得出图书管理系统数据库的G8022G5577模G3423，G3926图34G6164示。A78A79A80A81A82A83A84A86A87A88A9013A139A140A141A142A143A144A145A146A147A148A146A147A149A148A150A151A143A144A152A153A154A145A155A156A149A148A157A142A158A159A160A162A157A142A157A142A157A142A157A142A157A142A157A142A157A142A157A142A157A142A160A162A150A151A143A144A152A153A163A164A165A167A168A162A169A170A169A170A150A151A143A144A171A172A160A152A153A171A172A160A160A162A171A172A160A173A171A172A174A175A176A177A160A4034A40A41A25A26A122A123ERA402数据库G17935G17765模G3423设计图书管理系统的数据库名为图书读者库。G4570G40G53图G17728G6454为关系数据库的关系数据模G3423为图书管理系统的数据库名为图书读者库。G4570G40G53图G17728G6454为关系数据库的关系数据模G3423为G2524G8873用G6155G708G13856工编号，G13856工号，用G6155登录名，G4506码，G13435别G709，G1866中用G6155登录名为主码；图书G708书号，类别，出G10268G12050，作者，书名，定G1227，借出G2554G709，G1866中书号为主码；读者G708编号，姓名，G2345位，性别，G11017G16817G709，G1866中编号为主码；借阅G708书号，读者编码，借阅日G7411，还书日G7411，借书日G7411，借书经办人，还书经办人G709，G1866中书号和读者编码为主码；图书读者库中各表的G2001数G1393G17194集为G41A178A179A180A183G32G94用G6155G279G4506码,用G6155G279G13435别G96G30A78A79A80A81A82A83A84A86A87A88A9014G41A184A185G32G94书号G279类别,书号G279出G10268G12050,书号G279作者,书号G279书名,书号G279定G1227,书号G279借出G2554G96G41A186A187G32G94编号G279姓名，编号G279G2345位，编号G279性别，编号G279G11017G16817G96；G41A188A189G32G94书号G279借阅日G7411G96；G990述关系模G5347中G993G4396G3324对G19762码G1393G17194的表G17810G5347，G6164有的G19762主G4658性对码G4448全并G11464G6521G1393G17194。由G8504G16789明，图书G66读者库中各表G3355G7393从G37G38G49G41，G9397G17287G1363用要G8726。G3324POWERDESIG74NER中进行数据库建模，图书管理系统数据建模图G3926图G225G6164示A190A192A193A195A196A190A197A199A200A201A202A203A204A205A207A208A190G22数据G4448G6984性G13434G7475定义主码G13434G7475主G19202的G4658性G1552具有G2819一性和G19762G12366性，G3324G37G50G50G46数据库中G2524G8873用G6155表的主码是用G6155名；图书表中的主码是书号；读者表中的主码是编号；借阅表中的主码是书号。G3818G19202G13434G74751借阅表和图书表间“借阅书号”为G3818码，G2454照表和G2454照G4658性为“图书书号”，该G3818码G13434G7475G5224当G6203行G2475G19492删除、G2475G19492G6566入和G6310G13489修改的G12586G11065。A209A210A211A212A213A215A216A217A218A219A220152借阅表和读者表间“借阅读者编号”为G3818G19202，G2454照表和G2454照G4658性为“读者编号”。G3324系统中，该G3818码G13434G7475G5224当G6203行G2475G19492删除、G2475G19492G6566入和G6310G13489修改的G12586G11065。G4658性G1552G13434G74751G2524G8873用G6155G13435别G2494能G2474“内部管理员”G6122“G7393G2165管理员”；2读者性别G2494能G2474“G11019”G6122“G3911”；G22借阅借阅日G7411的G1552为修改记录的当G3837日G7411G30图书借出G2554的G21676认G1552为G1563。G23关系G4658性的设计关系G4658性的设计包括G4658性名、数据类G3423、数据G19283G5242、该G4658性是G2554G1813G16780G12366G1552、是G2554为主码、是G2554为G13046G5353G20045及G13434G7475G7477G1226。表32中，G16826细G2027出了图书读者库各表的G4658性设计情况。A22132A222A223A224A225A226A228A221A230A231A232A233A236A237A238A221A240A231A232A240A241A242A243A244A245A246A247A248A249A250A251A252A253A254A255A47A191A0A243A1A2A3A2A3A22A4A240CHAR8NOA250A251A180A5A6A49A7A8A222A251CHAR8NOA180A5A6A49A7A8A223A9CHAR10NOA50A91A10A11A51A252A50A16A12A91A10A11A51A52A13A14A15CHAR5NOA253A254A52A13A15CHAR8NOA222A223A223A15CHAR10NOA250A251A243A9VARCHAR10NOA253A254A94A86A17A18VARCHAR20YESA253A254A94A19A225VARCHAR20YESA253A254A94A223A240VARCHAR30NOA253A254A94A72A20SMALLMONEYYESA103A86A21BITNOA253A254A94A23A207A103A86A206A124A207A53A25A103A86A224A225A14A15CHAR8NOA250A251A160A240VARCHAR8NOA253A254A161A24VARCHAR20NOA253A254A232A9CHAR2YESA70A209A73A252A70A211A73A162A26VARCHAR12YESA103A27A223A15CHAR10NOA250A231A232A224A225A14A15CHAR8NOA250A231A232A103A27A28A29DATETIME8NOA253A254A54A207A30A235A31A4A230A32A33A28A29A105A223A28A29DATETIME8NOA253A254A54A207A30A235A31A4A230A32A33A28A29A103A27A55A245A56CHAR5NOA54A207A52A13A14A15A105A223A55A245A56CHAR5NOA54A207A52A13A14A15A34A35A36A37A38A39A40A41A42A43A4416注意“借出G2554”G4658性类G3423为BITG7114G993能建G13046G5353，BIT类G3423的