%PDF-1.6
%
2 0 obj
<>
endobj
76 0 obj
<>stream
2020-01-28T06:44:27-08:00
Canon SC1011
2020-01-28T20:47:58-08:00
2020-01-28T20:47:58-08:00
IJ Scan Utility
uuid:db716e71-5852-4972-8aaf-68dc136fc83d
uuid:bfc9486d-0eab-4902-8b84-4b13bd009ef2
application/pdf
endstream
endobj
3 0 obj
<>
endobj
12 0 obj
<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI]/Subtype 8 0 R/XObject<>>>/Thumb 4 0 R/Type/Page>>
endobj
19 0 obj
<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI]/Subtype 15 0 R/XObject<>>>/Type/Page>>
endobj
26 0 obj
<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI]/Subtype 22 0 R/XObject<>>>/Type/Page>>
endobj
33 0 obj
<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI]/Subtype 29 0 R/XObject<>>>/Type/Page>>
endobj
40 0 obj
<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI]/Subtype 36 0 R/XObject<>>>/Type/Page>>
endobj
47 0 obj
<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI]/Subtype 43 0 R/XObject<>>>/Type/Page>>
endobj
54 0 obj
<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI]/Subtype 50 0 R/XObject<>>>/Type/Page>>
endobj
61 0 obj
<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI]/Subtype 57 0 R/XObject<>>>/Type/Page>>
endobj
68 0 obj
<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI]/Subtype 64 0 R/XObject<>>>/Type/Page>>
endobj
75 0 obj
<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI]/Subtype 71 0 R/XObject<>>>/Type/Page>>
endobj
95 0 obj
[97 0 R 73 0 R 74 0 R 70 0 R 98 0 R 99 0 R]
endobj
71 0 obj
<>stream
names.
Table name
Fields
EMPLOYEE
EMPID, EMPNAME, EMPSEX
PAYDETAILS
EMPNO, EMPBP, EMPDA, EMPHRA
Part D(Attempt any ONE question, 1x6=6)
Question 22
Ci'eate relaiionship between these two tables.Question 23Create an Employee table with the following
DA is to be calculated @ 12% of Basic Pa,v.A) Display Gross PayB) Display the salary details of the employees whose name starting with 'S'.
Question 24Enter the following in a database table with the file name Emp-
Create database tables named EMPLOYEE and PAYDETAILS with the following field
EMP-ID100101102r03
EMP-NAMEARUNNISHAANILROOPA
EMP SEX
details.EMP-BASIC PAY30000600004000080000
MFMF
a) Display the name of employees drarn,ing BASIC PAY greater than or equal to Rs.60000.b) Display the name of emplo-vebs ending. with'A"
Xaaaaa"aaaatraaa!titrrtaa"a" ataaaXComputerised Accounting - 10/10
EMP-ID
EMP_NAME
EMP_BASICPAY
DA
HRA
201
SUVITHA
40000
2500
202
GEETHA
41 500
2500
203
SAVITHRI
48000
2500
244
ANILA
54000
2500
endstream
endobj
96 0 obj
<>>>/Subtype/Form/Type/XObject>>stream
H**B#cs=3C ` &`*9K3@%+ u
endstream
endobj
69 0 obj
<>/Filter/CCITTFaxDecode/Height 3507/Length 36484/Subtype/Image/Type/XObject/Width 2480>>stream
&K@()h'Gj@آ(2