My Tutorial C

The University Of Programming C

Tuesday, 25 October 2016

Employee and Department tables in oracle - emp and dept table queries in sql

18:38:00 0

 1. Employee(EMP) tables in Oracle.
 2. Department(DEPT) tables in Oracle.
 3. Works_on tables in Oracle.
 4. Department Location(DEPT_LOC) tables in Oracle.
 5. Project tables in Oracle.
 2. Dependent tables in Oracle.
_________________________________________________________________

Sl#
1.Employee

Sl#
2.Department
1
FName
varchar2(50)

1
Dname
varchar2(50)
2
Minit
char(1)

2
DNumber
number(2)
3
LName
varchar2(50)

3
Mgr_ssn
number(10)
4
Ssn
number(10)

4
Mgr_start_date
Date
5
BDate
date




6
Adress
varchar2(100)

Sl#
4.Dept_Location
7
Sex
char(1)

1
Dnumber
number(2)
8
Salary
number(8,2)

2
Dlocation
varchar2(50)
9
Supper_ssn
number(10)




10
Dno
number(2)

Sl#
5.Project




1
Pname
varchar2(50)
Sl#
3.Works_On

2
PNumber
number(2)
1
Essn
number(10)

3
PLocation
varchar2(50)
2
Pno
number(2)

4
DNum
number(2)
3
Hours
number(5,2)











Sl#
6.Dependent




1
Essn
number(10)




3
Dependent_Name
varchar2(50)




4
Sex
char(1)




5
BDate
date




6
Relationship
varchar2(50)





Sunday, 23 October 2016

Library Managerment Sytsem database project table in sql

17:31:00 0


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)