Date
Soo Emgjnttig
Databaàe Managammamb Syatan
Conapl and couanNLOO
Dams (Databahe Mamagamant SyAlam) Solcne that
mamages
ta accta etniNA ,
dalabasea,proviling a dyalemalic coay
updata Cmd mamage data
) Funcioma : Data sfonage atievalupdaba, Lnd
LadminiAtaalion.
Erampls MysQL, PastgrusQ, anade Database
)) Data Madals
Hienanehical Madal: Doa is ongamid imta a
Nataank Modal: Dada is ogamiged imagnaph
lionalip.
allauing man
(omplar
)Ralationaladel: Dada is angamidad imta Jables
aith soL.
Caalalin),malling
d) abt-onientadmadal Date is napnahamed
Las ohjecta Simi lan do abyect -onimtad pragamni
A Daaasg lam guages
Là DDL C Dota Doniion Languag)
Dalims databa sthut x CREATE TABLE
b) DmL (Dala Mamipuladian Lamgug
Maniplctes dea Ex: TNSERT 'UPDAIE, SB
DLCDala Conhal languag)
Contnol aces fo doa Ex: aRANIREVoKE'
d) TcL Tansaon (ontaa language
MonageA Anansaion EX: 'Commir,RolL BACK'
Date
) Datahani AdoniA nadon (DBA)
Rale: MamagesSnd
Rabpomb b.liea;
md mimtins tudbas
Tndol aiom,
upgada, bauky, (onlgunabon
acONSny, sluny amd
pananmamce Juming
4)Daabase USNs
.End uUbanb: Dinoimtanc uDA detaba
thacaugh gpliations
Appicaion PaagnannmaA_A:wnibe cpplical ians
Data Abataaio
a) Phyical leNal : Hau) deta toned
Anliomahipa
) ;Haw data
Vio laval is viaiad by UAeA
Thaee- Shem Pachleun
8)
Tontnml Schem
stauctue
of DDm
:
Debcabs phical Sanage
Dencabes he lagical stnucts
vious o hedatabas
9) Nad hon F-R Madel
Pnoidea ViAualehomtoion data omd
Date
. Halos im Undensfamdiog
dasigmimg dtbabeA
dada náinements Gnd
Simplilis (omplea databaAe design thnsugh
abstnaion
) Canaphual Dasigm Cecke n F-R diagrcam
nalehn al sehema
Relimimnt Nonmali 4he schema
iv) Schema
Aa emave nedumdamey
)
y Physicl Denign
mhsda.
Design an Aanagi bmd
mdncing
v) Tmplmentaion Gaaate the daabase Ubing
a DBMS
) Mappimg lonbaciat
Candmalty Combtncinnta: Dalime he umben
enfioa 4hat Gn b imvaled ima
(onbnain:Detenmiml whehan
A Pancpakon
600 an omly Jomi ntiy imaoas panipte
DIiondipota pantia)
ima n
on
E-R Diagnom
.Enb:ti: Rspnenmbad by ndangles
.Relaiombhips. Ropnobantad by diamonoo
Abubuts: Repaesened by ovals
atta bule
Krim any Kay: Undanlined
Date
13.Sblass
Jpenclashs cohich imbenits atbnbut pnd
Gasmanalig aim Coombiming mulkiple smtily yps
into a Simgl gmunaligd smbily. Comsman alpibabe
abahaad into Ae gemen aliged smtity
16 SpecialigaionThe paiscus of dellimimg man
peil entitia lnom a gonenal entiy Diangu
dillnnl nales on yp oi im a gaminaliged
antity
Bagasgako
modals a
: Rapnahonda
nalaionblip
a"cahale-pad" nalalionhip
botem a nalahomsip Ae
18. En:ly: Am
Snang Enly an ily that an ba umi Sualy
idsmad by its am ttaibutes. TA has a
paimany ky tmd aoiba imdepam olam ly al othen
anbes
B)Weak Enly: Ann onniy hol amae be GmiAusly
dapunda
a primaay Key ind i aai, oly im_elation.
Aomg
19) Babic Staucun
SoL (ammandA (onpadd aubsa nprhdim
EX: SELECT Columm 1, Colam2 B
FRoM able coHERE Condion.
Date
20) Sat apanaon
UNIO TNIERSET,EXCEPt
N
Ex >SELE CI Namme FRoM Sudona UNTON SELECr
Nam FRoM Aumi
2) A9ggat lmciona.
CouNT, SDm, Ava, MX MIN
EXSELECI CouN T )FRom_sudenta
22) Nullvals
uakonoam dta
Repnsamta mising
Ex
Handlimg'
SELET
TS ULL
on
,
TS NOT NDLL
FRoM Shudenta coHERE Nama
IS NULL
23) Doman Conatnoimta
Rentism
EX CHE CKCAge =18)
24) Rabenemlial Tniagity (onahoito
Enuns Bersign Kays Caanacbly nafanascL
paimany KoyA
EX FoR EIaN KEy (Dapl1D) REFERENLES
Dapantmamls (ID)
23) Absanios
Gamonal Contnaint anae databae
Ex> CREATE ASSERTToN ágeComdthaint
CHECKCAa 18),
