SPS

Date:

in Page No

(Casandna DB

CREATE Quoy
Queoy
end table )

CREATE KEY/PACE 1f NOT EXIUT mhlbyee

CREATE TABLE 1f NOT EX1/T enloee-ddan

yo char 50)
'nane
depetmert" chon

4oble be óp olbwn;

enployce _id ngme pday

Abice Mokdiny J0000

2Jane HR

VELECT Quey 10 peled all olumn am the dab le we

(amirond)

/ELECT * fRoM emjloyee

will othn all hows and col 1tom ihe emyee
tuble)
 SPS
Date:

Page No

nloye -fd
t0 000
J6ne HR 62. 060

add data to teble)

iNSERT LNTO enhloy ee enmployee_id neme, dopujnat Dal ohe

VALVEJ 3 '8ob'HR650o* J

name dehorment

Alie 0000
Jane HR 62000
65000
Bob HR

Ipod to the
able )

ELECT nplbee id name FROM enloyee*1J

Alice
2 Jane
3 Bob
 SPS
Date:
Page No

CoUNNT UM Av4, MÍN MÉ.

(onoider the folluing tuble i

name dept
4 John ÎT HO000
HR 65000
Jane
Bob 1T 2000
3

41 CoUNT:

VELECT (UNTB) FROM enjhoy ee;

Count
3

B)

Duhut:
Dyotom. un |pd thy
Q07000
 Date:
-SPS
Page No.

VeLECT Av4 |pda) fAoM enploce

69000ettka

JELECT MINaloy fRoM emplyee

65000

e) MAX

2000
 SPS
Date

Page No.

Databue olkcion, and Docunent

Databape (olle tin and documerd
(piltout thm yu e at cble toooe dota on the

A4 dab aoe (antaing a olle dion

documonto nd the dounets ontin dota

Gritetfor alletioA
Doeumen Dottumen

botumnt DocOufhen

1) ommundo) for Dat abaoe

DB pehve e wi the
|Ohow db)

Jalahole rneme
 Date: -SPS
Page No.

i Commano fon olle don -

doa boo attsed allo wod fo otoe malipl

bllecioryd
the t (olle cHon io Created win

db. colle disn _num. inaort Dnekey: VvalheJ

hee inntone, io wal to ploe dda
in ,a aheied ollecbn

db. Aulho,inoent onelname "Ankila"

nome -Ankt Ja
y
Autho

DB theo dioamentale eheated

Ky1ivaluet
Ke2 : vdue 2
 SPS
Date:I

Page No.

db.iyatudert Daa, innontone

neme "Rokil"
oll: 21
: Lo20
b\onh CIE"

Rohit'
in the alle din naned 'mypdnt t'da

CRUO oherims
( ’ (REA TE

UPDATE
DELETE

CREATE Gomnnd
mothed | tomhond) deocipion
it io uped to inoe a docaument
db. (alledin.insetnel)
db. (alle diorn,inpotMny]
it to uod to (neste an embty colletion
db. (reste ollecion neme
 -SPS
Date
Page No.

cledisn.inontke;
vabveJ)JE,
db. otudent, inaot one l

n&me "VumtTt
: 20
6hnch:"CVE"
Made

e: Vuni
fe : 20
bhanch:" CèE"

nane: Rohi

bhonch: "1T"
 -SPS
Date:

Page No.

b i READ Cohand
melhod deshiplioM

|db. olle diw. indl ) doc umono

fom the (olle iorn

o en, În þheyíoua tal pludt lolle din

db.ahudend. lindlage2})

name: "umit" ae :20 bhondi"C/

obute
íü) VPD TE (ommand
melho d den (ipHion

db. olle Cin.update One)

bolletisA, thdae doumont in the colle dfion h oaly,
the ivoe chiteja

db. ollecdion. uhd ate Manyyi to used to update nolliple

do Cuments in the colle din thal Dahoy
he qiven Citori

db. (olle Gin. ngplace Oney

n the ol echion that phoy the
fiven
 SPS
Date

Page No

in phey audnt ollecdin

the

ptdnt
urder 'ptuder' olle dionto 26.
0ne

Muni

i thne fa aroy douamentih nsme Mi

haplee tht whale

Roho.
 SPS
Date:

Page No.

iv Dlde (anmand
mottd des citlin
db. alle din. del ete one U it io uogl to delete 6 pingle
decomen em he Colle dion Iha
Oifeia

documota the Colletian tho

Citehía

I delete one

i wfll delee dl he douament fom olle cisn >