The University Of Programming C

Sunday, 23 October 2016

Library Managerment Sytsem database project table in sql



Sl#
1. LIBSubjects

Sl#
7. LIBusers
1
SubjectID
number(2)

1
LUUserID
number(9)
2
SubjectName
varchar2(20)

2
LUUserCat
varchar2(10)




3
LUUserName
varchar2(20)
Sl#
2. LIBTopics

4
LUMaxTextBooks
number(2)
1
TopicID
number(3)

5
LUMaxGenBooks
number(2)
2
SubjectID
number(2)

6
LUIsActiveUser
number(1)
3
TopicName
varchar2(30)








Sl#
8. LIBFines
Sl#
3. LIBTitles

1
LFFineID
number(5)
1
TITitleID
number(6)

2
LUUserID
number(9)
2
SubjectID
number(2)

3
BKIndexNum
number(9)
3
TopicID
number(3)

4
TITitleID
number(6)
4
TITitle
varchar2(100)

5
BSDueDate
Date
5
TINumCopies
number(1)

6
LFReturnDate
Date
6
TIAuthFullNames
varchar2(80)

7
LFFineAmt
number(3)
7
TIEdition
number(1)

8
LFFineNote
varchar2(100)
8
TIPublisher
varchar2(30)

9
LFFineType
varchar2(1)
9
TIPublishYear
number(4)




10
TINumPages
number(3)

Sl#
9. LIBBookStatus
11
TIISBN
varchar2(18)

1
BKIndexNum
number(9)




2
BSBookStatus
varchar2(2)
Sl#
4. LIBBooks

3
TITitleID
number(6)
1
BKAccessionID
number(5)

4
LUUserID
number(9)
2
FPIssueType
number(1)

5
BSIssueDate
Date
3
TITitleID
number(6)

6
BSDueDate
Date
4
BKCopyNum
number(1)




5
BKIndexNum
number(9)

Sl#
10. LIBBookTrans
6
BKBillDate
date

1
BTBookTransID
number(6)
7
BKBookCost
number(5,2)

2
BKIndexNum
number(9)
8
BKReplaceCost
number(6,2)

3
TITitleID
number(6)




4
BTBookTransType
varchar2(4)
Sl#
5. LIBFinePolicies

5
BSBookTransDate
Date
1
FPIssueType
number(1)

6
LUUserID
number(9)
2
FPIssueDays
number(2)




3
FPNomFineDays
number(2)

Sl#
6. LIBIssuePolicies
4
FPNomFineAmt
number(2,1)

1
LUUserCat
varchar2(10)
5
FPPunitFineAmt
number(2,1)

2
IPMaxTextBooks
number(1)




3
IPMaxGenBooks
number(1)

.