DATE PAGE N0.
EXPT. NO.
26
ata Retrieval - yiciemt
guyng ig
.
) Sate ecuity Covtrals accels llougb athetia
dion, enenydion, and aces contsl lees
) Concurveney contral -Manages dimultameou aecel
do malutaind olatoa
(S) Bata Jnteqity - Emor es acewnacy and conl
Condtrats.
more
(ate - 13 /03/24)
(b) ohat do meam by RDBMS ? Hoo is
R DBMS
Ad RDBMS 8tand Relationl datalade manage
ment yltem . t id an extendion DBMS
The baic dilletence betsln DBMS and RDBMS J:
() DBMS data us otoYeol ad a ile coea! in
RDAMS dlata isd toed uin yam talale.
|(2) DAMS dupotr alile wder Only oheos
RDGMS lupport
(3)DBMS dloes mot Buppoxt noYmalisaton whvcea
RDBMS
LOKENATHO
Suyports mormalisetion (Proc vewny
DATE PAGE NO. EXPT, NO.
27
(YDEMS demands ow dotave anod haelar
neds and RDBMS demands highex doftuae
and hardwae demandd
Q-19 ohat ae tlhe adwandages oy DBMg over the
draditional baded
And Advasdagel e DBMS Svet traditional le badeol
Traditiomal yle basec syltem had yallowing probled
n accelsing data
(2) Redndat duplicatl data
(3) decwity Problem
uin data baclp an ucovey'
(Date - 41- o3- 24)
s the table genecate dhe Rueicd
the Liu tt - Accel :
a) Pisplay the Cowese cnol
dowe Coude feed
all de Courded pwdeod the
POR
LOKENATHO
DATE PAGE NO. EXPT. NO.
SRolo lname lCowede ection Medium College Toto
Tet ol
Pees
lol Rajnda B-Com GemenalEgisk Aße 550D
Auind B- Com Genenal Englsh POR
550O
Kilhma B.com |Genenal Hinoli ABC
Hail B.Com Cenenal Hinoli PeR
Rojell B-Com Computes englishABC
|o6 Haidh B- Com ComputesEnglist PaR 2500o
And Step 4 ’ apen Ms Access )
wYite Pite mane
lo cation create
8lep 2 Go dlo Vie Ceate
wYite table nane pe westio
8tep 3 ’ write yield Neme anel ata
ype
Bawe.
Step 4 Geo to oodashet iee
Go
dhe clata proviclecl question and thn Bave.
Steps After creading dable and yiling all the
clada as pe Cceale
Step-6 Queny delign, double cice n lable
an Jeleet cobede, College cmd Tadal yees
LOKENATH®
DATE PAGE NO. EXPT, NO.
29
om youk table do aocd them do the guey
grciol
Btep-7 ’ n the 4 Tatal fees" Calumn, clhange he
Cideia do = Min (I Total fes])
8tep- & ’ Run the guvy do aee the Cowele aml
College with the louest fees.
Caltge
Coeade nes neecleel
Itep-|0 ’ Wouale - clicle 46 Cowde
om toble to eee it do the qggvid
ede the ceite
ad PQR?
8tep - 12 ’ Run the quy cdo see a l the cowlel
the
- |3 > owe Queie.
Step-|y -’ Run &wniel.
LOKENATH®
DATE PAGE NO. EXPT, NO.
30
(Bade - 13 /03/4)
-21 CMeale Employee database and table EMP
Badic
|EmpnoEname |Debignation Deptno. DoJ Salay
Aj ay Managen I2|12 l20o1 2so0b
Axined Dy Manager lo/o/2002
lo3 Radul Pzog rammer 22/03 /20ol
lo4 Hai ol/o4 /0o1
los Sahil Acoutat 20/09 /ao00 12o oo
update Balany by adoling the morements ad per
the
(a) lo7. dnelment cin Badic falany who at <20000
< 20oc
(b) 57. noemend in Badic Salay who gt >2000o.
Ad Step-1 : reate the dlatabale and Table
pen Micadagd
b) click ou
Acels
Bak Dataloale" and it a name
like Employee DB"
c) cick on Creade' to create the neo olatolode.
d) dn the ns dataloabe do the e Ceate)
lab cnd feleet Table Delign?
talble oith the
Emame DedignatioM, Deptno. DoJ , Basie talay.
4) ve the talble with te wamne "EMP?
LOKENATH
DATE PAGE NO. EXPT. N0.
31
Step-2 : Ente ata uto te EMP Talsle
a) apen the EMP talale in datadhect vieo.
b) Ender he provided clada ciuto te talble.
`tp-3 i pdate dalary ad po tnoement oriteria e
a) Go do sthe e« Guate» tab ao seleo Suey
Deliq"
b) Ald the EHP talble to the quxy
) litc to QL
designee
Vitlo.
Step-y: a) Poy I07. ineement Jor thode who
<20O00
UPDATE EMP
SET BasicSalavy - Basic Salayy " 1-1
WHERE Basicalary <200oo
b)for 57. in Cement You those woho ged >o000
UPDATE CMP
SET BaSic Salary* 1-05
OHERE Basie alary >20000
Step -5: Eneeue each quw paratuly by cladeimg
the «Rn' button a
rom the tocllba
LOKENATH®
DATE PAGE NO. EXPT, NO.
32
fallowing thele dteps oill Ceate the Employe
databa, table EMP, and update the salay accovoling
to the provideol Criteia wn Mg Acceld.
(ate- 2o /03 /24)
22 Cxeate a tudet atabale , table nawme - STD anel
allo Creale a a Report iun Ms - Access.
RRollno Sname Clald 3tate DoB Makd Gulade
Rajesh 6Com-I AP 2l-09-84 81 A
Ramesh 8Com-I MP 72
Rakesh 6-com 30-06- 29 A
Sucesh B.Com-II AP 36
5 Vignedh B-ComT MP o2-02-83 45
And step - I opem Mioosoft Accead.
Step-2 clicle Blank katalase and give it a
name ike &ludend Dg"
Step-3 i- chick Create do ceate te ne cladabale.
Ceated datalade Jo eeate
tab, click
the yilds the table ad pen
Question:
LOKENATHO
DATE PAGE NO. EXPT. NO.
33
Step-6- Save dhe table wHh the name 6 sTD?
Btep-7 - Double - click Gn dhe STD" dable to oper it
Cnder the provided data indo the clable
step-8 :- Go do tle @n Report
wijard"
Slep-9 -
Beleet he Qn clicle ok"
Step-10 - choose the want do ineluo
du cthe repor t
yiclds you
clicle "Net"
|Step-11 :- Choose dayout yor yowr rpord anod
clice Net)
slep-12:-
:- Choose
Ned).
dtyle fo your vteport and clicde
Step -13 :- Name wt report c d cicle fnis?
you han Suelyuly ereateo a etuolet databae
with the ta lale 6 sTD and a repoT t nawnel o Sludend
Report" MS Accels.
LOKENATHO
DATE PAGE N0. EXPT. NO.
34
Q23 eate a
ibray Qatabade uding fom layout
ASSels hating yoowing yd and eteatleast
field Name Bedeription
BooK Code
Book Title
Primay ey
fubieet Nome
Publishe Book Publish Name
No. Copied Quanty in ene twoice
No Total Pages in book
Edition Book Pating Etion
And
Ha Stcp-l opem Micodat Accels and click on Blank Qataloade
|Step-2 : Give name do claabale and eate nes databade.
Stp-3 : dn new dadalbode. go to ceate and deleot Talble Desg
Step-y : Relign yowr table wth the filels as pu queltlon
-S 8awe cthe table witl he ame
me ^Lilorary Table".
ibrary oble" in dadolhut view.
Step-7 : Endor atleat lo waco Ted co Ha dhe provielecl
tield!
Step-&: Go do he i oeate" tals anel Selet formm ellqw
Step-lo Add . ßave the
-ll: pn"
Arronge
ibrorg form, Emte oada directy do the
form yoYeaek tecord cnd ove he
LOKENATH®
25
DATE PAGE NO. EXPT. NO.
35
(Qate- 29/04 l24)
Q"24 a) ceate databade and table Emp')
Emplye
MS- ACcedd.
|Empno Ename Delignadion Dept-no DOJ | falany
10| Ajy 1212/20o1 250o0
HanageA o)02 /2oD2 20 000
102 Arvind Dy Managen
103 Rabul Progrmn 22/03 /20o|| 00
lo4 Hani Matkeling icor lol/o4/2ool
05 lail Accountaut |Ro/D912o oo 120
b) Caloulale DA ad 407.
) Caleulate HRA as alay
d) CalCulate PA a 12-677.
e) calulate Goss pay = fala + DA 4 HRA
) Caleulate Ned - Gross
A1)0Pen your Acces datalbade
step-2 Go do talo and the Ceeate
"Qwy delig n'
ltes-e :- Adal dhe "Em" table cto the quey des igne
3tep-y :- cick n uthe f6 QL Vi' button to luilch
to oL víw.
the ing cto
DA, HRA
calculade DA, HRA , PP , eoss Pay audl Nd pay
Hene
(b) DA [s X 0.4
LOKENATH®
DATE PAGE NO. EXPT, NO.
86
(c) HRA -[salany 1
(d) Pp - CSala J X0-1267
(e) oross pay loAJ +CHRA +Cfalay]
(4) Nel CarosS
8tep-6i- Run the quey
ResullJ wil disalay the Ewmpno, Ename, slga
dion, eptno, boj, Salagy DA HRA, Pf, cras
poy ond Net pay yov eack employee
(Sate - 8/o4/24)
.25 Ce ate datalbale tudend 3 in Me-Acebs . Aso
Ceate dabe STDMARKs and emecute the yollooirg
BRollnol name CM PA 200 IT
lo1 Rajenba 9s g2
lo2 Arvind 52 53
Kulna 89
Harih
Rojedh 66 75 77 6S 79
upoote table by addng Grade ad pen the yoloolg '.
(i) Total %age = 907. arade E)
) Total 7. age 757. Gracde "A»
(i)Tot a Yage >z 60. arade B
(i)Tatal 7ge So. arade
(vyTotat
viTot
LOKENATHO
DATE PAGE NO. EXPT. NO.
37
And stey-l:- OPen Micro fa/t Acceds amd
and Ceate a n
databale mameod Student 3".
tep-2 lhe w dalabade , cate a talale
nameo gTD MARK
e STDMARKe'' oith
oith icldl ,Enlet the Provided
yieldA,
S{udent the 6o
data into the STDM ARK table
Step-3 i- uling the
allowing s9L UPDAT E
Caloullte qyudes baleol
bas l an tata Percentage.
foy Total
[ToTALJ= CBE]+ CBMI+CCMI CITI tCPAJ
Tadal in age [ToTAL] /5
NO w,
fo Garade,
A L ( [ TOTAL]6o,B' 1(CTOTAL
(ep" ))))))
Step -y:- bRn the The
o e be polate d aceodny do te provicdedl
Giteria.
LOKENATHO
