KEMBAR78
Database Management Concepts | PDF
0% found this document useful (0 votes)
198 views14 pages

Database Management Concepts

This document provides an overview of database concepts and components. It describes the main entities as records, fields, and tables. Databases can be used to store various types of data like employee records, customer profiles, financial transactions, etc. They allow data to be retrieved, added, updated and deleted. The document outlines key database terms and components like records, fields, tables, queries, forms and reports. It also discusses different types of database models, users and applications.

Uploaded by

wahitha banu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
198 views14 pages

Database Management Concepts

This document provides an overview of database concepts and components. It describes the main entities as records, fields, and tables. Databases can be used to store various types of data like employee records, customer profiles, financial transactions, etc. They allow data to be retrieved, added, updated and deleted. The document outlines key database terms and components like records, fields, tables, queries, forms and reports. It also discusses different types of database models, users and applications.

Uploaded by

wahitha banu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 14

BCon CA TL

S / 8 / d

Oohue monuu
a t c h a x tste~iaiclutecu

Roic Con@pts atoSqsle


7iaJ kapin
Conpuley- ba
X T s
7aLord uuuin i

A alo Stored i Ste


ato
pant tionud to
DB
uOne u t u hae)
v e datahae n g t

, al
Aecords, OK
EMPLOYEE

oth
Cntain
e u l o a e s

delollnent it icividua
distoc
Con
FCCod
i c s

a
Dteunt we to
t o aa
* Jkercud

SonalinMe
velusuy
tine Stova
S a e cnda
c
Tt Const s daobwe
Csikes ,
HoUnduan!

n uu i s t a Laen
isks, dums,etc.
ysin
ruanacent

Softuuae: Betu0a d akabae


dalabare

CaCCe
Calkd
uall
Softuau

Ob
Tarue types u w e s dferct
wE ppLLoion
pemas
pooqre-
pplicatin
) a l l +eo
u a d uLQys.
into
new
n t o ->CT¬atinq
Reti evina
O t i n intouatton

>dsetina can database fo a


ie
te
use:Acccsina
2)End-

plication a e
wen u w u l n Aunctios
c T E e mevad,
-uen pexf
Creotion ,dclchmd ugditi Ceation
Dalalhae dninisbator
Sv
=plgsicol

ouls CoCopLel=Couty
Titernal
Tve
Fefernal, =XnCUinRa Cua

Vieig
dale
bu individd

xneg Lev
vieud)
individua onaptum v e

C o n n u n i t s usen View)

Tndone
L a v e

CtoroaR
Vew)

voluno3- d i k s ,c b s gko
.

S e u d o a v S t d s e g c

auc

Opeual ionaQ dala


operotiousl l o t
a CofOoceion Stored
ao
d
de
patidlen etep
el picotion Sustem SouC
nkenpnse >aniøruont qecuc
tem
an suao tor

Sel-Cotaund Cowwce0 , Scietitc, tecluni Col, Os O


%aan tton
Monutochuouna Cowpa bok, HOspit), uief
Aerkerpase mut rowaily Aualain a ot 7
olbnuk u5 opuo CoI09 operoiad d
T i ma tnct.de peduck date, A/c dale feties
Sfudet data, ponuna dola ,

beosk c cudo impeoas


e Pea btient in
Adol.bu

acul,
uur tHe
entitios

acoydod Cn Co

in dh Suste
we
undele
idelu ef
shaike object
TeTe7A

M a a n
di
dh.
ropeatt
in
o be velafios,
o c C o u p m o
4
o0,
etiti o>
etiti o loqete
togeHoo,
aic
nlina C

S
d s

>bept
opeotionol dola.
e s e

estgsplc
-
pds- pcjecis)
pes
ass: Catoin ro Supp Crtaun foss
Cartaun PvDje&)
)Tua diaarun s velui
erbtyCP
CPes).
na type
aa
Sene entities re
3)
en
n enral,
wnser clodioslips.
ardee i n Kue
a

ex, prteb 4 @p
elcrkionas. aNatiosps "wosks aa'
1 aat
raprenot t

w datokave? te
to S to
Store
cleese
sluauls
on enbepnise ?
w calerts
dltabar

d an
dala
Ho
t s c p e a t i o n e

priva
a sib
cuun

plcation ar
Eo
a d6 Suptem
uit
An edeprise
Peun
o
idetitiabe

one
Re operotto
Sonu
cuille FOr
Ccttrd
repousib: lity
as Heu

k uducad.
Can
* Redundarcy
apli Cati
eaclSa
on fo r
need
duun
cd orr.
lo

nodls Ssters fo
u d h Cen
wudch
a
4ilo.
n pvola
i Stovec d a l a e tecluca
ugetE

Se Sanatina
mavlain
n a r a i s
utiple
dtiple

reasns
to
wine»
rusunse
Oy
O haween

dala, L AG,
Soua
Copie
extet
Can he Cubrla.

avoidad:(to Son te
InCogstec Con be
tLc
depavdtmet
D8
wucskò u
Ca E3 +¬c Sqs o
cies t u dla. S ,
clufinct +E uuplicc.kiom, ( i d r c h c t

Ccntellc
CCComps
uid he Sowe
uwd r e t a c
a t i es

Cie,oG ona uo bacn upcias J>4

SO, d t inCnoistest Stak


Copol uppenniP iKoeet

CCossertu Connat

T 400 uddort
dalalb.ase
a oTar +Cat tee

* T dato Ce beluare
AAo Net onyte exktina
dle databose
Ca Shae
ttu
Can be
applicotiou
une
ao te
k aonst
tCe Sanc
to o e a k e
eve
eeCzed
Ste &al
Con se ena :
Sladords
Caáal Ctrel o dai
w (Laf os appkicebl
eSuc
Can

4C DBA
Aadands ara te
dt
Acprenation6 e.
Con ho s44
Seuwuly 2strict ios

pOTadional
dal
feo
Ove
eue
Can
te DBA ( )
nrd,
ar
prop
T ua Jsh
auJZi
hana)
Con dafi Aurl,sLS,
.a
(etne,

oK eodlh
a in cds.
1nto
eocl
piere
to
T t a a u u n s

alCuuul

chete dlh
e
elliin
n uunn
aios,
,

uclundoao
Even
Even d n c e r r e c k do
arkain
may sH
b 3 a nog
o
a
mploR
e
an
u*a
waak, or a t

Cuorkad 200
hau do
apa
otnmaa s
s

Fos
fos a e
Mul ep
Onp M non e b t o r t cacida
jnuda
aClude
t
Cabrol ea lnps i
ontrcIu
SHuotiond,
voeldokn
n
tee dana v

DBA t dat
a
Pentd ena
to be
C o i d cut
Psoadunas

pdala Opeakion a t a m p a d
*Lnfictidna requewmaks Con a bedonad:
DRA krsura Re ovoraW
Pauramnt +eaenlanpi se , DEA
Cen Srueluu tea dh systa to pvevida
C Ovea9Q Seice R a t a best ffor
best

enlanpiso.
Data idopercdonce
->Tu wau ca uilich Hee data id
org
Secnda Storog od es uma culucs
celurs
iaaturod ae bot dictales
+ e a cpp ' Codiem
eaeeen
Taa ppication usttee krow Jeak
ndex existi hust Knoo +e He Saquanc
TAna Sbctwo ohPPucotion uuM ke
buist Osraund t i s kneulaslsye.
a d& susten, it wuds be exbremel
cndairabto aWao applicabios to
data-dapondart. acase a2reason
uII nea feet
DiAKinent opplicatiors
yieus o t ama data
e aBefone ea Rkenpn se inkoducy ib

t e e l s AA, we have appuTati ou.


}ea
A 8 . each has a Fe Containing
d Cstonnen bolone"
Suppee, tEa opplicain A ecada t
Vaa decunuas 2 Be s it in bina,
Tt wlo Stillbe poss& to taoraks r earelk
Qiunta e dunda.

u s t ae neaclem to l a r e
)DBA bt )
acto StrategrCin
StoroR uarwnantG
wi
ittt
w ou
ut

Jospe
to CQong

Juowi o odig
exatiane
P pplicati

adpE
now Stadarb
TT etenpise m a
>ea: nes

ay dLangg i k e ,
pioifies
oppicatio
becae vallel
awadLo
devia a
StoTaog
23 D
uppucatims aUe
data daperda
->IF CoTTepndanq Clor
cnvole

Such Cle oes prtranur


effort
e fort

an +eus tuca we
ERen s,
,
be
p p ctiony

ien
DBMS

te-St
Sie Specsic e
C
Stored N
n dh.
Cotoa,

each sh Severtpa stoed iNo.


S d b Ca iafo oau pous incmde
Storred ie tyee Ce pot
uwu oo on oCnadu 6f e s Stoved tik

red OCord: Chtion 0 o5R Calek storcd


oY fonse
Stored r e x d o cwont
TOLoded Stor ey Rek

ood OCCueno ConUsts o

pouk u m b a , p paunk nealL pcat lor


po uia
T ascCatim

J a n pot.
puperu
Somepadi

Stored o d ,
OCCLUUto Cno e
Kpaaluen umRue doto
Storad iInno9
Nunwic elda may
Corolr Strun
A
Cae DB
L eorh
a l k hield.

oulr dto
et
ation o
stoved A
C n dlae rvo

Code
nches t tinutT
D

ale Ceine Ca
ti

- a Sane

Volues
Cosy
Cooles
BLUE , GREEN
RED', 6LU
P Stored o

Oole aluald Vieuo:


sat daaived
Rre-Copud dlala
Laker we
Stoed f
Spehicatio

Soudu Stored 20cesds TaCord


Stoed
tuees 6t
exöting
TLD
TLO

ba Coudainescn
Gles. Fu
Stonecd
e plaio
c U u

Soe+ile
mo
Vaiekj of
a wida
ke in o a o e

extianuo
v c l u e e i u n e

ConCoptuolf
inana,
3 ovel
storaqe (ulucd,
ppical
inlEnad - ose to dale
d)
ulih dala ib Vic..
T way
extene b yincdivicluwa

induechion
bofu
Qove
Cncptua

tndiNidue
Va
naptuuoD ive Cantains ia fO o
edit tyre Co MPLOYEE.
cace EMPLOyeE EPLOYEP _NUMgER
Caun can)
Cep NuM R SaQoru Five dial
en Stoed reard
Inono apraanbed by
yee Co00kSTOREP eMP=>e ab
STOREDeMP Telords oa indaved n EMp #fre
b an indax C«2
MPK.
PL a s etirua vew hdeu ulues
e a n odoueo TP bu t / T zcacesd
Contau

terna CPL }I)


E skaunal (CoBo
DCL EMPP

2 MP a ( s ),
02 DEPT AD AIcx
a SAL fixeD 6N C3I)
ConCeptuol

Umkba
COaraclan (6
Coaraclin (S))
pioe
Dectunsnt _Nukron CQLarain

(6)
Salau

STred EMPZENGTTH =(

o), afset - o
Prelix Te B
EMrTe B (G), o f t s6, index
Dept 11

Tee FuN RuTd , cset=IG.


DBMS

Host Loaun HoSt


+DSL L

Exanal VieuA Cxteua VeB


lEol/Ceu aptu tlane/Conaphu Dooa

B A

CnCsptta view Sute1


Ceapku
S c l a A G

ConCeplua/inCernes
DEMs)

SHova
inreac dofintio

(aS Dotobo Saln ouuCutectu

ufn a feckre
DeMS desion dperd
upon
haw ev
DBMS a n c l i t e e u
doped
eeia
to
Cannecked
to d h
T p k o

Intana

duulbus
t e r a

Rinfouaiom
Cenkes H e
odocdna u
ugool
i
decide al
DBAS Toh

1ntoatton

ad o
uiu
Storaq
Decidre t s dacd
u e del

DBA
DEA Aust
also
e
7 e te
ace huus dalingi
(Tuva
ACti
Lovin

The uinss DBA Counectia


tes dala
a
HEat
oens
extama Snos
avoebN to w t
Vaidation poa
Dokuno Qutthorizatim deds

Quttsitie C&cchs 4 Vakidatt o


Csnsidewd. os

oC exfesiou Coptua Sclma

DefinunqA a stralec tor backrp recoe


Eve 1 it k h a k/w huur
a k l to rupa
it erertics t
a nuinuMMN dlay
dolo Conaxnadwt

Cbachup) to aa
4 TOpondinq
Moutona peroTo

Te DBA ponsie for So


to a t
Susteu
Osgani nual
enterpo Se. 4
\a a la
bot fos
a pappvepvale
t odwtnts OTequr

datu dictioa
Auct npostot ttcl
db Catains dato olbout dole
Vazuow unno3
urua
poticukan, alltc
aau plasicol Stered
Xtnol CnCaptcintera)
bote Stwu L oae for didio
Dotnbuod d a i o e
->dotahase iat C owtsts
Conslt

Ste t7

coied
itewt
ditferret

O
O
CTe t s entineu
ffet w
Sonne nduunsK O

PoTtion e d Storas in

oCutioy 4 Po CCiq
uultp pluusica
dalubae ncic
outhbuias onncna

D i t h butad D B s

You might also like