DBADesign Class v1Word格式文档下载.docx
- 文档编号:21201256
- 上传时间:2023-01-28
- 格式:DOCX
- 页数:13
- 大小:47.47KB
DBADesign Class v1Word格式文档下载.docx
《DBADesign Class v1Word格式文档下载.docx》由会员分享,可在线阅读,更多相关《DBADesign Class v1Word格式文档下载.docx(13页珍藏版)》请在冰豆网上搜索。
Version:
1.0
1.Introduction
1.1Objective
Thisdocumentprovidesguidancefordevelopers,designsthedatabaseoverviewcorrespondingthesystem,andhelpsdeveloperstodeveloptheOnlineLibraryManagementSystem’srelationaldatabase.
1.2Background
a.Softwarename:
OnlineLibraryManagementSystem
b.Databasename:
OLMS_DB
c.DatabasemanagementSystem:
MySQL5.5
d.Usersusingthesystem:
thelibrarymanagersandusersforbusinessandindividual
1.3Decisions
Basedonuserdemandforintegrated,inductionandabstract,forminganindependentofthespecificDBMSconceptmodel,weuseE-Rdiagramrepresentation.
1.4Terms
a.OLMS:
a.
b.ER:
entity-relationalmodel
1.5supportsoftware
a.Supportedoperatingsystem:
Windows2000/WindowsNT/WindowsXP/WindowsVista/Windows7
b.Developmenttools:
MySQL5.5+SQLyog+MicrosoftVisio
2.ConceptDesign
2.1TheglobalERmodel
2.2ThelocalERmodel
2.2.1localERmodel1
Usercancheckpersonalinformation,butcanonlymodifythepassword.
2.2.2localERmodel2
TheAdministratorisdividedintogeneralmanagerandsupermanager.Supermanagermanagergeneralmanager.Generalmanagercanonlymodifyhisownpassword,whilesupermanagercanmodifyalltheinformationwhichincludeallofhisowninformation,alluserinformationandallgeneralmanagerinformation.Ofcourse,theyhavetherighttochecktheirinformation.
2.2.3localERmodel3
Administratormanageuserinformation.Notethat,thegeneralmanagerofallrightjustresetuserpasswords,markwhetherauserisinviolationofstate.
2.2.4localERmodel4
TableBookInfmeansakindofbook.ItsprimarykeyisISBN.TablebookInStockmeanseachbookinthelibrarystacks.ItsprimarykeyisMageticbarcode(bar_code).Theirrelationshipisone-to-many.Thatis,therearemanyofthesamekindbook.
2.2.5localERmodel5
Generalmanagerentrybookinformation.Thisinformationincludestobeontheshelfofbooksinformationandfromtheshelfoffthebooksinformation.Finally,thesuperadministratorofthisinformationisconfirmed,informationcanbedepositedinthelibrary.Notably,thegeneralmanageradministratorinputoninformation,tohavebeeninthestacksofbookstosearchwhetherthereisaduplicateISBN.Ifno:
twostepstowalk,
(1)thefirstentryofnewbooksinformation.
(2)thenewbarcodebookseditor,editentrybarcodeinformation.Ifthereare:
directlytodepositbookeditingcode,editedaftertheentrybarcodeinformation.
2.2.6localERmodel6
UserbasedonuserTypetablecanreservebooks,borrowbooksandrenewbooks.Theusertypehas3kindtypes,namely,undergraduate,graduateanddoctoralstudents,schoolteachersandadministrators.TheuserTypetableisusedtoexpressthedifferentcategoriesinthetotalnumberofbooks,canfirstlenddays,canrenewfordays,theoddsofbookrecordsandsoon.
2.2.7localERmodel7
Userreturnbooks.
2.2.8localERmodel8
DBMSeverydaycheckstheuserhasnoduethebookalso.Ifauserexceedstheshouldbereturnedtodatewithoutthebook,thentheuserismarkedfortheviolationofstate,atthesametime,recordingthenowillegalinformationusers.
2.2.9localERmodel
Usersreturnedthebooksshouldbeduealsodidnothavethebooks,theadministratorwillprocesstheusercorrespondingtoviolateregulationstherecord,atthesametime,thecontentsofthebooksinthelibraryfromstatetostate.Whentheuserreturnedallthematurityalsodidnothavethebooksaftertheliftingoftheuser'
sillegalstatus,theadministrator.
2.2.10localERmodel10
Administratorreleaseinformation.
3.LogicDesign
3.1Overviewofrelationaltables
AccordingtothedesignofERup,wederivetherelationaltableasshownbelow.
3.1.1UserInfTable
UserInftableisusedtorecorduserinformation.Attributeuser_stateisusedtomarkwhethertheuserisnowillegalstate.Attributeborrowed_amountrecordsthenumberthattheuserhasborrowedbooksnow.
FieldName
FieldType
Constraints
Description
user_id
varchar(20)
notnull
Theuser_idis18characters.
user_password
char(6)
Thepasswordis6characters.
user_type
char
(2)
Forexample:
A、B、C
user_status
boolean
notnull,defaultvulueisfalse
Onlycanbe(Yorno).
borrowed_amount
null
Theamountofbookstheuserisborrowing.
user_name
user_sex
birthday
telephone
phonecall
varchar(30)
address
varchar(50)
degree
varchar(10)
comment
text
3.1.2UserTable
UsertablesimplyrecordstheuserIDandthepasswordoftheuser.
3.1.3UserTypeTable
UserTypetableisusedtoexpressthedifferentcategoriesinthetotalnumberofbooks,canfirstlenddays,canrenewfordays,theoddsofbookrecordsandsoon.
forexample:
book_amount
Thebiggestnotmorethan100books,Thetotalnumberofbooksout
first_day_number
Thebiggestnomorethan100days,Thefirsttimethenumberofdaysout
continue_day_number
Thebiggestnomorethan100days,Cancontinuetoborrowthenumberofdays
odds
numeric(4,2)
3.1.4BookInfTable
BookInftablemeansakindofbook.ItsprimarykeyisISBN.
ISBN
char(13)
Onlygetthenumber.
book_name
author
publish_company
publish_date
date
price
numeric(6,2)
book_type
book_introduction
check_out_number
int(4)
defaultvalueis0
Thenumberoftimesrecentlycheckedout
look_up_number
int(5)
Thenumberoftimesrecentlylookedup
3.1.5BooksInStockTable
BooksInStocktablemeanseachbookinthelibrarystacks.ItsprimarykeyisMageticbarcode(bar_code).
bar_code
Everybookhastheonlynumber.
book_status
canbeborrewedinthelibraryorcannotbeborrowedinthelibarayorhasbeenborrewedout
3.1.6AdminInfTable
AdminInftableisusedtorecordadministratorinformation.
adminId
adminPswd
adminType
char(10)
defaultvalueisordinary
adminName
sex
3.1.7ReserveRecordTable
ReserveRecordtableisusedtorecordtheuserappointmentbooksrecords.
reserve_date
3.1.8BorrowRecordTable
BorrowRecordtableisusedtorecordtheinformationaboutthebookyouborrowed(Hasbeenreturned).
borrow_date
actual_return_date
3.1.9BorrowInfNowTable
BorrowInfNowtableisusedtorecordtheusernowlendbooksinformation.
should_return_date
renew
defaultvalueistrue
Itshowswhetherthebookhasberenewed.
due_status
defaultvalueisfalse
ITshowswhetherthebookisoverdue.
3.1.10ReaderIllegalStateRecordNowTable
ReaderIllegalStateRecordNowtableisusedtorecordthecurrentstateofillegalinformationusers.
Readersnumberiseighteen
Eachbookmarks
illegal_date
Bookshallbereturnedtodate
money_number
numeric(5,0)
Befinedmoneyquantity
3.1.11ReaderIllegalStateRecordDealTable
ReaderIllegalStateRecordDealtableisusedtorecordtheuserinviolationoftherelevanthistoricalinformation.
handlingtime
3.1.12TemporayUpBooksTable
TemporayUpBookstableisusedtotemporarilystoretoputthebooksontheshelvesofinformation.
3.1.13TemporayUpStockBooksTable
TemporayUpStockBookstableisusedtotemporarilystoremustbeputontheshelvesofeverybookinformation.
3.1.14TemporayDownBooksT
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- DBADesign Class v1
![提示](https://static.bdocx.com/images/bang_tan.gif)