0% found this document useful (0 votes)
126 views111 pagesBasics of Data Base
data base basics
Uploaded by
hosnyabdelghany3Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
0% found this document useful (0 votes)
126 views111 pagesBasics of Data Base
data base basics
Uploaded by
hosnyabdelghany3Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
/ 111
ro, Sere rt] ET) PT
Ra Pett ey Pe
rte mv
FDTC
Fundamentals of Database - V.3
Rv MT NMC BES eT ert ane ae Der cna a creer er ein Crp ey AyJASI GSloII Joho
GK9829 WAS) QALoI ga
-OboglzoJl Ladi Aj ole Wa dj Spo] 6aagU
Ulzolad ote uaa!
ol awl So_is of Qolsdl Gono! Aww jo-ay Vo
gi FDTC p05 VI gail Wlwlul dala ple Jana ago!
gi Qyrd5 G19 wl gi Vou wl Lala Ail gi Lay siti
62-A0/I Lo Quid Val We Ugo. Ua Lae gf GLyigyi4I]
UL GLogizoll LiaggiSi Gile UL ya Gyj4yol
Wleolal oteill
Agi! AQUgimo/! Wi 698s! 0Aa Ole GaALl lao! vic il sutsoll dun fils v
und 16 lalU Jgaill lac like 1993 Lalla stall Ji B
(gt JE yg all pstg Gotta Lani malgal lanl ALS 6
SLiuuigall lio 8 ya ll Joa dll jt ga) Gj eal gall
qnml G4yy al olay ai gl Jgnill $204 ite adlg
(am bing Jf JS.ny i algal Yo aya uy S159 «agin
sLiaclg Qudtogallg libs Jorg Jumutig juuirs fio . Jgailt
Gannbg! Siloaillg “soglonll I jus ium
Ayla 6ctHSN Gat, jg «abs oullg autwill aga yy wai Slag
ALL 21 318g aca 6 Lmin 6alaiwlllg “iloglonllg “sil 61a] y1—_wr.ig
gpa Lani cl ga 4951 Sud 6 nent} (yg dams
ole pail yillg (F 0) ainto 6 gyal spitwall pail actig
Gu Bund pip tlamll doi te A__ salto as. 2p) dlgall pj
gota aug Gyan mays al aeayy pjilig cil guna. pibolgall
2 Gonaw duin jae’ Gig S59 4,120
2g Yo al YS Nal: gpl ygiuwall oul pai Log Gxt pull! ald Guid 1} Gam ill aol pil yo yall wali aly
Shuma
usS fala JUS go Slymlg _uaugall Jor yy 8 dtl ys
Andy agi le ay Jnl pune ole fins mind ya
tubal ple ane Sloe ayaa gay Siar (po fli loaill Jagd
lc ani Jif += dolai_uall uni }_ep8g) (yong citaiutng AL
sui amy ola gai Gung 2y29116 yma ly 8 a I gal
‘oj ogi toa jana goLeaiil gal jj 9 yo lami yo asa
‘Gyballgeinal aun ggliua uusig GuogsI dletualg AAs
Pate ae ea)
(go 22c Gill} 84 Jhon lly «saul all ae Gyygmaall jun Golds Ble) Sia39
gitla mac jo dyyraalogSall i jo darnal cg ill
(0909 JL 29 8 el 9g. 99 304 Je Eng lleloal Apa Ly Anal yitoigal an uy alii -8un5 Nagel eg io -|
(Jaoaiuuall Gala! aig SI loa 3c BaLjg dun plogeall loa jobs 1}, aus Eg plio gong aig, ISIN ogi gaya -¢
yas hoghnallg il jaitig, ola gli yb dango dl cLusolg abla jy je 41 me €g pilin gong dng piaIM insagall ex pio -
gnaildating dis
«gal gel pil ig yal i 8 Stent tel ulna gb Jp Guead pene Gat jaulg CM pany gotilaig
Gaia tay ui yd Jgait ull alma aly 8 kao gc yulpal aol xd jal] mail egna a! and ghyol 9209
cota / Joi Siku es mua Le elig fyp endl noes en ee ot dg) 39 le ll td sles
Ugaill lull Satan te Jg- eal engl gol yl wil S59 yalal spin pobaig Miya 8yg js. olmotal teil pulaall juni
asa elo silaac
ojala 10000
ayjat owl 9000
45 ulenlqun Go Eosdll lyaglhen r8/GHSlr9 L4G Eqp0ll axe Ullosl 4Jox9
abslaoll Eo 0ll sac
6salaJl 20
qyaiSwul 8
fy © 20n4ay NondySoihggb OUsolalhylellyuigel-Lioslzal UpoklMoteuusalayryetersot |g w ylaolil
aililull aig atti
Lajos dalin UA pe 4 OH) Jorsilg 3 as) Jara OS GULWI Ul Aswi
lodio AayAluto Lail Yo Lp! ode 2705) Yoraig (OS) Yor! ys Ayla
Grhliw 40.4) Jgralig 3 25; Jorall Vo AWW! Gle Ubas 15 déj20I9
}olic iprocessing Gallzoul . information Culoglzoll data GULWI ~ogadod
2 Files WilaloJig database model and database objectsULWI acig6 @iloig
Olle Ja 70d (Log GL! cies Lay25 AAgiM GUL! rcigs ~egaeo coo
Lailioog Los!
Jol WALA! LeLagUl yi CogLeod Quoi! LAU! 690! a data GUL! °
galo Ue 8) Gal] Ladi! Lails UAL duals! GLU! Wind Lo
loAq 140g... oN Jo UIQUUI Ylgisal ow! JA to Aa44 29 Ua!
(2.5) ow Youll UW! yo aLosdl GUly ULS GLU! Jol oo
Ulgisd,dSUa
ul Gayalé Laializo CLod OU! UUW! oo information Gloglzoll «
lp ddlao Vo ellos! aac Us Glu! Ulioll 4.69 4451 doid9 Vizo
Uo loW asi jl rigor elpalasy lale tas QU Gloglzoll ua
370.8) Jar al 46 dado! Ulogl2ol 95 5.59.1 Jos os ail
J45 06 €9)8Jl 3.c9 ellos! aac) lodule Joaal (Od VU! 44) JgaoJl9
Gololl sail E91 Yoo YLiy jd SLi YAU! Wo Atal (AAsta0
6jqeal YMigy 2 (oS) Jgrcig 1 pos) Jgrcul yl ani La (Yog aati!
06 Lave WAS GU dogl2ol Goul olAJI 6jqzallg clo sil Ue bajo!
Apo.) Jgrrig 370.5) gaol
GUL! Gle Gi GU! Glelaullg Glilosil 4a -processing dallzoll «
dallzoll Ylo Gill! Jil og (Ciloglzoll) Guz. Yae ole Jana)
mJ dyle elug dA dla L445 ellos! aac d6j20) Waa Cu Ci Ul
(.. Ulgie — pouul) datio! GLI Qle eH Ul Lay GUI Glelyaul ddj2.0
ane G40 705 05 Ylgisdl ode «ly GUD jd Joc id ello dU dalall
6 Galleo)| duos) GuAaro)! Ul Eig .j}6 @egor0 U4 U6 ellozil
Uo Aa5W! GlaAdollg 2pad) Jorailg | po8j Jord! yo Gill lio!
UU! acio6d 4.69 40.6) Jorcuig 3 4) JQ! Gs Gallzoll duoc
Database CLL! acigé djlal (OUAI ga Galleoll Glos) (og) Gall
Lay Jun dill Uglii ody oq1u9 Management System (DBMS)
WLS 1S Le bedbel oe gt Yy cabpoall V pull gale jlaodll - calilull acy stil
91 uw! Qa GUI acigd palic database object GUI acigs pnlic ©
@Sooil 69 LALLA) Yag GULUI acid 0694 OS UAY UII bbAoll
WUly rcigs dylal PUAI (Lo gl GUL! Gui porAiod! GUL! acigd
AU
lay OAT GUI 4a:j)1 Ya database models WL! acid eiloi *
Aol! jal Yo Yasil ragig leo LabijIg Lazu) Loo9 GLU!
@dgaulig hierarchy model Gisiall @dgoil Vio GUL! acigs @alou
Ika GO Aogliiiw Glo yLisiil ISU! gag relational model ysis
“OWA sgiaoll
62alg 61294 UjAollg wo dayjoICawl dcgoao gafile@loll «
eNLasU! 44 pin uated! GUL! daclé Yl aad @yluw! Jol! 20d U9
Layeg WWrollg EgsSilg alosil Gola! Wlaloll Yo wasil ual
WU! UjAo lalioj9 POMeo2I 622210 Lig) gl Luly Maiy MALLo>9
Joli GAll ule joSioll PgMBoll AL 5 Yo GS yi) ELD Yall
[20 GUjpollg ASunio I WU! Yo 6415 d4oS Lal GUL! acigs ways
GWe 2! eljoja/ Lal) E9ay! UA! Gil 9 BSlg/ US L2o Lali) Lo59
AAW Uypillg jjHlo BijlBollo Uprvillg Cals Lae Goliroll
Auoul GUI G4 dublo dygcy dasdlo UAT POU GUWe Glooleo
6jlal PLAS g@ Lainilzog GUL (yjJAUI GUloe JS Yasg GjAoll
SOU acios
Ll! aclos pA Guay plaAiwy aliol
GWaUZI9 GUL 8 AUT oLAI «
Gotu Syn GaUDig Ulli jasapolAi «
W/Laollq UIgil 6 allosiig QUlo WI OLA «
Ulzolalig Uujlao/l V6 Gyles Ug! sylal~OUAS
LLY acigs polsAiwl
1b Lo (WU acl) Leo Laidilss 299 HULU! Guulig PLAT UILLo.0
(G5Ld GUo-4Sy CLS 29 Vis LAS Alo Wlogledl fren han ©
saLbwloaa ple wAbasi glealatool «
USos Cnas tijjo9 AXinog duyddo Gdyly SUL! dols Grori ©
Aol Ugauig GUL! Aa to Glu Eaay!
USI Gloglzo eljalw! Ho VAo9 GUI Uy Geilo Ugaw «
-6ubUoIl Lajgay jadi - cliLull acl atuutul
AYLoJI GUL! dold DUAR] ©
AUgibo)| GULWIg! dogizoll ule Jonalldcuw
JWLGU! ebALWIG Lae siiwig GULWIWAT
gy JG hd ranig USo Yb eu GU gf WAI UL od GUL! dacls Yilg
a NWI UAuidU argo 9a lo. WU Orel Jol QUIS LIIlg Aol ols
= Stage ts
UsiILAd ULosAlitig) 84115 loss IGoA8) Urol} Bo ASpiilo SULYSscls
»WWLS LaaypAgi Joli Lailj100 Uo DIG
Aubuinyl Aug GU! 6aleil .1
ULI del6 Uo Qyslial dui jroo oly GUL! dacs palAi 169i
Jac giagag Js Yo GUL dalziwl (935 Aoly) 930 GSLAL a
AWW Glew Yo) GUL! jedi Js yo yiag GUI port pe
dyauiayl
Ula gy9deuaas 2
LY! puro yagig LolSig/! QuByG JSsiUy GUY! Oacls reyowai
gl Wad US claw CHaai sl Ui yo uy WLS eI 6S Lagi QUI
UUW! dacls PAA GUIGLyh! A514) 4 jad 5 0l 45LAL
OU! Ai dja 3
- 610 Uo siST aa peiW Yly Gls 6rdig GULy dacls LAW WAI
Gus poSAL JAuiy GUUU! Jo95 Uo 238) agar jILSI AOS Caayg
084 Yolig VASu! laAsy OULU! by Jal Wo GUWWI 6acls Dodo
29 Uo LOad Un dL Gg Lig foreign keys Quialll QilooJL Ugdal
adglig aaalig WAU! Ha Flud Gioy kag ULI! acid puoi
USS Uso) jlaodll - calilull acy slut!
UUW! Golgi gl Uwilai .4
Ul agag pac baslg WLW dacls J4la SUL! JS5 Pac Ole Wy
Yo als ms gi Lala sig dogleo wi Jat YUC ASdlgi0 We GULY
0 Min) 6a cll Joli GUI ULoyadl 46L5 wy sitio GUL! dacls Ua
2S WADI Iie Jal) ipso blo Hel s3¢ ya 95 aie AxoLall olAI
Gril Uglarg LaLa Jglas
GigloJl $905 «5
Ujasild dyuldllg du4J! diguoJl GUL aciod Galle plas Lol)
WAaIl Yio) dASArin 4914UI QIWug [aa Lay aang lidg ULAtig
(GoLAyIg
GuwS)! Glazigol 56q5 .6
lailalle Oleg GU! ole laqds GUL! dacls odo GA) dal! Wo
Go Uslolaiell los ole UAL! ladjO) 3918/1 odd YASUI LaAgY
Uo ayia] Lal ule Guys Glonigo 169i Voy loo GLU! orcls
Ul Ua}2y Willa dojo Jal aic dhe Uo wSi dja Uda W Alle) LALIT
(423 100 aula! peo sq silda jl
O54 A4yjLiLo .7
PAL Yordimo Go SyA A4SyLiro GUL acts wi jogi
AWyaazioll
Gi VUeaw .&
0 ei 393 6 elo! ule GU! dacls Udi Jol UL uLotI OW As
UniAgI! Quggie Cag pug Ugauy GUL! drcld 6 alg Ago
Jala ole 6yiile Wasill iy yoo)! Glcuw rare Jjasi ric Mio)
{Gullo 6AsLwil
OULU Gye 9
Qi GWubU! Uc Gasio UST CyAs GUWW! bacl6 oni
mY 6ya5 Weasel Diag! Wlaubi! o8a Gila Very lors
LU! dacls Y94i Ul USoy EUO4 lawle 36) Wg daca! EL Uc laysy
oda CHA sig) Cys) Gal dial le Voz) Gui slo orld jlas ole
UU GUUldacls sity Olea
daa dulce CULT dyjw9 Woi10
Uo @egoro JA) 63350 Gail Uae! GUL! acgd PAI Yow
epaoll pe WrorAluoll a4 Whe Holi WULW! Yod hag UWror Aino
oad W jlaodll - calilull acy alulaal
ULI acios ptosis
SUL! SaclA) agall pyounUU agiafoll Lo
20.819 GUI cles yond alc Laci ody GUI é5aoll LAs a99)
jai Lou Lajaws ody Y (rdI] GUI) 6y540J! GUL! Jolll LxpoJl 1
GWU poac UUlag eLoAlll AUlolal Uo aujio Aaluall
Lakai rol UA UW to Lastiiial oo) GU sla sUI faoll .2
Aplus Cilol2o ail Gl Janu oy Vc isto! 3
dan Uor9 lomo Iai az) laianng WU! Jloid| :€ulyl iol 4
oii GL! drcls Cuils l[o Aaiiimoll gl deayimoll Glogleoll
Uo Ologlzo gl GU padi plas Gi Ylo dann ye Olly Yle
J og dasa pie Wilogleog WU ole Lay! Golaiw WU! 6acls
GSS Yo At wylLail Ylo
PromUlGyloe |
> SWS G2 Pyoni! AWoc Highs YLo GUY daclY) sialon YloAd
UWI dacls Wo Wass ya3i 1
Lay do la di! 669i) GUI AA pal dojz0 od GUL! cigs Uo WassILo
duro) 6us6 GUly dacld) QuuJUS Laor iu gall YaAuiillg
VALU GU acts 2153" io Uayuy Gul Wid 26 WJloll Ju ole
Asxiliog PaAWAT Gis UilI! Gilaw Gle Bloall UAss) poailayy
EAU! Crowell Slow Go AU! y/LSUI elii}g Gwhall aordig Dalasi
Guujro/) Lal
LaoAiig Ggloo)l GUL yaai 22
LIS 9) Migs AVL UWU [au Lagi tig dugding/! ULI Ye CLL!
@dloj WO Uo) CLL AWidy! gf SWI yi03 Yo api! Lolo! uni
Elail Wo €qi US shu9 Wlalimoll Rosy OS Wala! Gj Ys A549
aul WAI Sagago ealoi sl UU YAY UIA] @SgoUU jalAI QU! UL
ws gil GW! Ga lo uo! WUly Wawi @agoi muon Us
qyaalsas Sachi! 95 Gil A2I leo Ve lo Mdqoill ys Lasdg
Aoild; Whs A9i5) EL Me UAsisl .oryw9 poUsil Aa Uo pic 4S
(2.2) Guol4J! business cards Guido) | pa mige GLbUay JUS (Lo ello zl
é a) 20040) 018Soliggda WcAeolo lg lel yulaaky-closiag ooh IsIulewinalealsyotonaa |] jlaodUll - calilull aclgé atti
sos! pul ule yglal Adley J4 Yi WLSLoy! oda Yarns pay a8
05.4 Uo 4 Uins9 SILA! /O.5)9 GA! LoVIg Ugwig Ayrosig Ulgiwig
J929 Ys Ilene hgee polis!
Lol Wo Gag Uo-4l ole La jlo] Yin G18 U ctlo si! doi Walac] eli
Wl Yo lias UU jal aie US ay Ad CVS Wo Vu oil
clit) La oslo! dej29 Ullal LW! dacld) jal yaaa plasiul
Ga C159 yb doilAI! ad
JOU) Lagyngi) L269 Yglaa yo Laxyjgig GUL poLuei .3
HSU Leo Alas ls GUL! polic F403 OY Jol. JP GUL ows)
Gui! Ug ls JW! LS lod Lad Qui! Guglizs! gi Jors Ue
s NW! Suid Jas lo. GULllg elLo-2Jlg Wassollg Ulalioll ua
ehteal!
anit
Spat
Sap joys Wg Anal
tanh see od
ais ant gic
sits a oss.got
owed Spo aot
coal sual
SLaS1Sayell joys gaits dual
alt
way
WiS0 GUL daclS) Jolas 6 GLUT osuSig fo
6p0 (UUM Alle) 4065 JS Jiauii pod GUY! dacld poo ric
io Wo Uo JS] yd Lad) GUT 4) EL a9 15] 484 6239
GUIS! aic Ladin Jars yo GU! As &Ag18 Wu. 30 Uloic
Alay] Gls GUL! ole daectl y9iad Ul Way Jal ios! Yigizul
Jos UbLWWj53 Aliod! Jars Klee sy Jol uu ole 296 Ylgissu
4885 Yuulg asgoll Jaa 45485 ga aol Uloic UI .AS6 Ulaiioll
doll U9 v4 oll gms ALi! Joa
6roci WJ] J929 US U8 GUL Loic W935 4
AAU grail Wo ager adyc peg ids pic JS away Cy
Qo Jao Udi WSs) lastiag QUI WUWWIra9.J919 Yd dre!
Au! GUL! Jiod Melos)!” Joaad Gul Stoll Ju ole gral
AYP! JoUVAPQAroig Ylgizlig PUUU! Brocl) days Aylay AoiLs
. Qig HSU ay Ulgicg GaUlg yig 54! ayy Jlujl9
roel Wai cliSo) 9a U4) olsill daocill degoro ayaa ass
PouwU Wybagsin Wage25 Utosd! uw Wi UA) wJUio Us le
EL GuyaSllg Caylg Ol oud! LLido) Cua Ale! pole Uoill jlaodUll - calilull aclgé atti
WUgAo dues Wo Wes Ylgisd! YoAT) Wiloo JSuting 86 6rocil
Cys Aah iol/ lo G2! Loulg QgUlg Ay roJlg YlgiVli.a Ladio
ol C1ay elpol ayy C1iS IS] Aladin drocl Yo LaujA faieo EUS ass
wads aic Gi Gaile Uaig -AyNg/l Wo deni Gf jpo duoc
:Jglaall 48 daocull
Uay Will! PAL Ys quad! GUL! Yost VYylua
Joh vo dull Gos dau WyjAjpoac
ral Jd Ll] Qliai ad ysl Shi alial ys GUlul Wiad ~
C196 |S] @lio/! Wag! Lila UJ] GLaios| elo of QLol4! cLowil)
Uo UsSuue Boil oo GUL Wo aale Eai Uo Hal dow
oid) Jgla Bal Cid9 OS Gasol BiG! slay! Ue!
Jods elit es WJliol! uw ole Gydinrio elial ol] GULWI
10.2199 Aiid9 AiiolI OWWY gi Lz puwlg Jol! POW dLadio
Iola Quai Jors JS OS GLb! dace! Gua 98! Loaic
«J9a9 UA! yuulwill cio jyiaul
Gulu ill auileoll aaai 5
py lagoe Quulwill eUgoll jisy gas JAI Quvlwill elidel! 5!
Ulo .6Aio He dials UoAig Loo VAsiN Lan J4 LQ si Aolariwl
oo Primary key Quali elie cir] gl UIA! acigd9 Ua) 3945
JUS
PrALW WV Miad WWW elidel! ys 640 lols 5959 US UY
USo) 66 ye slow! YY juni elidoS YoleubUl clowi
Joa] Ud 98 rou Wwe Vigbaau cya) U4) Ul oa
He ago2/! dots CUS 15] sw Aol Lola dod d9i Usa %
40) 6 all Yass 64 (629820 Go1d) Goqyz0 Le ol Gitzo
«Www Alidoll 56Ud404 Lao Alu!
USos Tors HST W Quuuul etide jUiAu Lola eed) Ul Us ¥
Yo GALI Jalaal yo &ajo5 Y9aaW Quwlwill eli®oll olaaiw!
ati@oll ju195 pod [3] ora Uo JAl erat QU! Gul sacle
Od] BLAIS UMS Bl os Lay sill Bula Way unlwill
QUloia! Wwes QUI si YW Quulul eliey polari! jad) elisoll
Oy! ju 54l Jglas Go Ailolio foac jlaodUll - calilull aclgé atuutul
vie gull eli@os Gilguie ayo pos) polariwl poly lo We
Uap! lb J4) a6 UL 0.5) Wel) 098) 26 Uo Luu
Udo) Udine sy.0) Ul! aaj oa Ul! SJ aingll
Losi
HOU Leo JL4T of YylO9 polariwl GJ liad a5 Wllall Yass Qo
Jno" Jgaad US0) Jo! Jun ole gaa Quulwill cidoll
Wagec plasiwi GULeU paw! police (yj si) pogdy gl "ib!
loric Alio/! Wjz09 LWA asx 1 Vala! QuuLW @LBo/l Wo
alidoJU LAW ELIS Gout) agoe Uo JST puulwill 2ti®oIl oa
WALoll
leo GUI UN L859 Jglaadllbilc alac] .6
LLL lo Y9rs yo GLU! bu! Gas sasg Jars JS Gal)
LI V989 G64] oy Gols)! EL uLalg.y1SiIl Jglaaul yo 629290)!
Uglas elit as ol ( foreign key Jini! elid.oJl Wo) 2) lo gag) Jalacl
Elgi ab Ug roduw9 dota! ysis) oS ULoils/I ALA daa
All) BaSoll 6 Bay OLaIl
GLb 6acls JolSdsalo .7
ay lay] eliad QUI GLSiL slg JoBalg Jalacl Ole eign aic
LLU! Flay! elaog duasgoil!l GUL EL Gola! glaall dinsig
Wasig dajas Oilew d6lA] gl Glolsiw! eli Cleglsoll eliiiwig
GUY! aclod) Aor Atul Qoljillg dy) sldloo4 doy Gly
ole Jana GUbyl dacls plaAiw! elise YS Id] lo ule Wysi
CUS [al Lo Galo WjWillg @aloW Glaquto aL OS Lary QUI JoLall
aicg Cyjoall ue GUI 455 Uc aul 2.5 dxdgioll GLb! Waysi
Iho Wacluy -Laio UAW myo.oU! Wasi 6 iLaio yi ule joisdl
Galay aliad 38 JUoll Ju Gle Qoiaoll USuioll jos Ule oll
Ua) Jana CL Y9-4s 26 gl Lon! Us jo cll dala} Cw 2d agoc
UiLoiodI WLU! GUljy 92-9 J] Qo LLei
G46 Words 64) Alio/! Gley0 Gly orcls YS Alio U4 loll Jaw ole
Jord Won 26 Ayal Gig Sloll of ioill of ulgyitell ie AS yiito
yor) Yard as) Ul UAJIOU alin US did Wass) tds "Ulaliol”
15] Laouwl Wika GJ] died! ang WyjAI GyL6 diguatg GLY! dacls
(81994 JAI ay Walla Jgas Yod Hal ong JB olay ind
A AshoU laps Us soil kd ae) UA58II ord AG) Alin VAS AI4II jail - cliLull aclgii stuatil
lay8si Ugldo!l GU! drcld) was Ulgic WAI Le. Ja asl
U922 Wo yuu! Algol! Lola] ELi40) od .yuwlwill e2ollg Joa JU
dacls dyad Uglao ric yayld elidod Slaiiol! Ugrs Li] Wal
Huai GulS 9] AayUl ple out Si Aug GUL!
tLaio @G5UI LAY pill joolll WAZ) Oh Lol
LJ] Gloglzoll oli ms U4 oll YLS 13] Sorc! gi cu Ja v
dl @liad 286 al egal ga Wlogleall WLS 13] F6agagoll Uglaal
ol delay! J} elias Uy JAI ag0e eli os AT J9ao eit]
Uod Sill Saocil Wo Gloalsoll eliiiwl jAsi 15] dolaAtul
sla Yad agae G6L4] DJ] elas Ui Uoiaol!
Joao)! Uo lajlus YSo) ail dyguA ye droel yi wisi Ua v
Gall drccill Lo Gloolxol uaic Wuus U4ol 15] Tagagoll
Guu! jew (ho ous) pew Gus (od oJ! Jun Ole dagagoll
aps ages cli] Wing hd6 CVs pol Sil Yu aimoll Yes jal
ULS 1S] SUgall aslo 6539 GUL Sal S19 JAuiy gd Ja v
Galle loa! Uwloas Ud] gral oud) Ui! aliad ade LAS oll
azlooJaaig
Uo aaa 31¢9 J9kall Uo was! ole V9iai Uglaa Chal Ja v
US 15] SyS}O)! Claw! 5 AéjLOl JoGaJl Yo ss silg AW!
Uo iol Uouliy Jgrall aro) dale} 6 SS Lay cL poll
-J.6| Ugg Claw!
Galas 1145 15] 96a180 peul isi QJ] Cll paie VSouudi ida v
pais! Isa Gao Uy poie Guus gf Ciay gl jp6 al p85 GS OI]
Qyyalall sgosil yd
Uowrly oJ ll SUga al Ylgic Jos G6165 Ole agoc U5 yoias Ja v
JAIJ9AS Vd) Qol 106 Jor iulgic Jos Ul ago!
ic gl G4yiio Vasu lol Uglasl Uy OLUsJ! US Wii pu da v
aavig WJ) adig GsileIlg alg Ll Adig GSusII Cis SLU Ygaa
WU gas rasin ll savin Uldle UL A4siuito doc!
A 1) 20244 018/Soliggda BeAsololhgleyulaahi closing lsh Istulewsnalausyokonaah [5 P jlo - lial aclgd ctu
QowUlacio6 Gui .8
fod Weg aule Laj4S Gulu! Galo! GSA Cow! acios Gio py
Gui YA) CLs .AaiW! jylillg Ulodlzollg Yoni! Gan Ylod
eLL6 eb Wl! yon! YO QU dghA45 GUL! Gow acigs
Polio UL GolAll Jglaall cuilS 1s] lp G6) 20) acigsl oA poAAW
ub dloe Gow) CUS YAS OU Ul Laojo.n Galelg aye July
acigd of LY dacts Gyqui uu! GUY! 6acls oye) le acid
All) BoSoll yo aN Lsilsd! Elgil ess Jol oie yg
Jglasl Uw ClsueJ! il
Goal dy ol) elal Wolo ye dlooleall ums cod Ul ass
léile plaAiu! Wy Ue E49 Vivo Wd Gey GLAl dj0 Gloglzoll
WWI edgotl Uo) Wlios! Juw ole leo Ulogleo/l &oal Jalal
Jolaadacyotloglzo
-eo2i"Joan eo
© ansqysovdisial gods EAsetallsleUyLlseli—Lioslaalicoblstuieussaayyetarsot [46 | jail - cliLull aclgii slut!
WuLbilsJl Elgii
alg J) ralgdsile «1
aio! Gilogleo YAS! Jan Ol) Gala) ELT Ways! loll Lu ole
Wlalis ule h46 Gi VW! ol Yau Lay) ea QI! datas! dyoLayl
JAuly Glogleoll elias UCL Lua gio Jaan Wo laxdg ELiSoy Ls
Olaiiol! Ugrs YS Glogleoll WAI Ue aly Ul Uo) Gilg yALo
eliSo) Glaliol UgaaS ale Gili U alio JAI Géjl6 Goluo
Jgac! bo Yy GdieIl yisi uuu! eid. aiiall Wie polasiwl
Jgaa 96 Jaw JAI asig ol] aslg G6ilc Alio/! Uoang QhoAUl
alle sjan5 ale SLAY Jor alls rag Gilloo Jaw sag) iLaiioll
sSphiitg JSa) yUgrall yun Yiiay.cra Yio
&4 LLU drcld Bd 25/9 VJ] A3I9 ASile LJ] dala! We aI! aie
alg J939 96 eo Ua all Uo logl2o Bg Uli So) a Eye y.6
Uo Hid 6 UUW a6 Lal Loy Lo Luu ELS) OUI 4.6 EH (OU 15]
yo Asilell Utiod Gas GU! Aoi! ade) dejloll Slot!
:o.nil
Ads! dlac| Aoi Ule CliSo) audi Ylgis!! Worn UlS la] °
UWgr oul 46 dud QuuLwill AUdoJI ols
aol jiAls Gotits Guwlul agloo) GeliAd Wglic Wor al UL IS] ©
eti2o4 Jail Joao yo Y Lola! Q4wLWU! etleoJ! alal radg Ugaoul
walls
asin G}raI9ddule .2
GUL 6rcls YS LWyrgoll Ulaiioll Uglas sJlioll ha Wylie! yo xs
CUS Ole Uy Wlaiioll Wo aac wf 1169) ajaol USo) .Aiio/! SLL
U922 Yo aj90 GU ULaiioIl Ugaa Yo Glalioll Wo yas! aga9
Ulsiios! Jgasg Uso! Jars UY Abi! Lisi —JWug .wsjdol
HSU aaig dbiLe
4 ) 20044 018Soligg8a BeAeotolhgleyulaahy-slasiag lsh Istulewsalaasyokonaah [7 jlaodll - calilull acy sata!
eUi2o)l aA! WU! 6acl6 Puo) Ys JST adig Gdilc Util
90245 CSLAL (0.59 ASU! (Lo "2aI9" LULU! Wo re2gol QuvLwl
Yo "arzio’ Wlall 46 sga9oll Uaaall oJ] dll dxocl ol Wot!
ajgoll Wj20 sgoe Ayal Jol! Yuu gle GLa ose yo salt
- AAd0 08 lo. lala Jo29 VI) WI90/IU9AA Lo
csr)
Jora yo Jo sll J}2 05) olALWI Uo Access USol US a2)
W120 AQOe Voll) Alig JA! Alaa! ago! 6890 wai! ULaiioll
alido 64 GALA! Alida pail! aidoJl ULaiioll Jord Ys SIdol
Ulli Jara V6 "aigoll 6120" a902II Hiss Al Joa) Quel
Wa joo! J939 8 QwLUU! alidoll LAY! 192) Gi paylA lid
Uuuwt Gb We Caso)! Jol cl uJ] loa Ulwill yd05 Cli4Soy
Uy QU Jglaall Uo la Stio UAI OJ IS] duayld avldog Gull aviloo
UugacJl Ul aaxio oJ)asig Géule asi Yor) bole Igoe SLL Ui
-jitito ingore YUL digi W4iorol
Alo LJJsaziodsuec 3
Vow 16 ULI Jgaag Glaiioll Jars Uy aie Uyuicl yo 644
Allo yay Yl U4) YAU Uilal Ole asig Allo Wo JiST adie Ulla
"OULU Joan 6 Jaw JAI U9) VIVA) CU .GULb dc 96 alg
J9aa Yd Jaw J4) W945) Ul UAog "Glalio)l" gaa yo Cilaw 6ac
SUSU! Uo EU! a Voy “OWAI! Jars 26 iA 632 "Ula!"
GUL Wo Wasi Alto Gi) Uo5d Ul US.) Gil savio UJ] aazio d6ile
Quills 24) pao! Lo Ui OJ] JUNI a3 Lai! Yo asd! LLL ile
-Jolacul Uy sasio ul) aasvio wléile BULLS jLicUL Adal
4 ‘) 20n4ay Nondytoihdgde Osolaiglellyulgols—Liootzal sbi soteuunaeysyeresso! [yg | jlaodUll - calilull aclgé atti
2avio YJ] 2azio Géile Wiaiio/ig WULAI! WW gral Wyglic YoAll
eUiLi} Cg La 15] Ga ay [alo WAI Cadi (ad) 4th KA Jia)
Jona Glial Jars J] diiol! Woj20 Jao delab yeas Uy doll
Jone Qe Jaw Wo 445) Gul eliniw Ul JAI lio Uo sid! ole
Ul iyo Vn 4S) La Logo JA) Lido) UL JAY GLI!
days Ye GUL od] Gads 36 WLS Ye poo) dic aly lo sig
Jord Yo Ul] Wiz. Ja Bg rod 15] Auto! Udi aigiw
JAI Glaiioll Jas Ye Jaw Yo HST Eyal YoSpyy Cys ilaiioll
FULAuiroJOAa U9 ELA) 215.Alio
mod) Cun Uunalll Jara WE Kou CUU Jgas eli! oa Jal
elidos sazio Gl) aalg Qisile Ul] aa si Gil saxio dile mumadiy
G45 CUW! Jgrcll yo Utgrcl Yo US Yo Quulwill eligol lj}
loS Lalihiin of dus Gy AI JS Wuauiy CU! gail peggy EUs
syJWW! Ua ago 98
Sus
| eoall Sime tbl Sno
tet Jee
40S 359M yes Quail Dime Abt Dim
12 21.00 it 10248
1044.00 a2 so248
5S 34.80 72 10242
6 100 “2 s0311
7 ~~ 20.80 oy 10311
Ub 6 laslg Haw pric Ub Juste Joss 56 Jaw JS ios
Wo! WBS Yo “La! Junta Yorsd Quuluill elidel! oily
Ula! Wjp20 Udo plaaAluw! Wlalio/l 9 Gu! Uglas Wo Gayl!
Ulbt Yo4y Ul V4.0) ail Ugrall kad Quwlul aliae+ oz U orag
Jaw paie J4) lls 620 AI oy oul police Yo was! adigIl
WJ2o0 JH> plaAiuig 624.6 045 ole JO sgiay U Cys Ul G6
Uo Uarsil y6 A5Iq Aliol! pa Ui USo) UY Lavi oz V 0239 Ajo!
Gord loils CUS Ue aly Leo WuLOsI! aos rie YAIg GoliAg|! GLA
Jaw JS) daypo jlaodll - calilull acy slut!
‘LiigJ! Jgaag GUL! Jgas up Valio/I Whee UUW 6acls yo
Jas WH6 We Lil we J4uiy Uoty leaitd 6uile Lad laAsy
La II Jali
Gaels Oo Ulaligslg WULoI! (WW casio Ui] aalg Gétle Uuloi my *
Davin VJ) asig WLille olaAiWY GLY!
2asxio UJ) ralg déile ole UL ULalai Jaane GUL gas yo ©
Jia How pole 5 US) pow paic Yo si5/ Lila JA) 94) Ui US
+86 aslo uly
ull aalg 46le Ole “Ub! Lalas" Jgaag "SLailioI Jgas ely
USI Gy Casijoll paul polic Yo Uasil Allo JAJ Ug4s 26 .sasio
49.86 dig Adio OJ! Haw poic JS yuiy
0 63gagoll GLii|! US waa elise) "ULI! Unaley” gas Wo
as) 2920 Alio) Gall! GUL 5 ayaai Layi ELiS0) 3330 Ub
lo! Uiloo UoSaulo Uolacul oils gai 28 "ULI Lula" Jor Wal
Jglall ule Ego Ylod ole Uglaall Uy Wléllsal ayaad Sacuuy
aio VJ) aalg gf dl9 LJ] Aslg Asie s959 sie dasa! daocillg
agag ric @4Syiio é6racl of agasx! dioroll Uglacd! d4jliio Uay
AdiL9II Jule CU Jord 149) Lay .2a Bin VJ] 22 2i9 ASE
é © 20n4ay Nod tolibgde BAe otalelyilgoNi—Lioglzallnoblstolewaunasaysyersnsss | 9q jlaodUil - calilull acy tal
GQomiUlacigé5 Jil
palic JS Elio se) siST 6.426 normalization forms Gyquill asi
Uo 2S! ole 649)! 08a Jacl yJal 408d OJ] Uenallg GUL
Auwlio! Uglscul Ud) GUI Lolic oa c1e6 ELT
36 PloDU! Ul 694 JS V6 SSW Go Gigill ule selgdul GUAL os
(oy @5lo/ Guug Wkia normal form dyalsJl @aloLU ow Lo uJ! Lag
-SNF UuolAll gall @Sqoill GJ! Vong INF Uolll galsil @sooil Lalgis
UgagU QUti! 6acld)! ya @ulaU! LLY! Go Puy Glau! PAL
Uo HSI lo! Bu UI py Lo [Jag standard design wh)! yoo! LJI
xeUS
Qo Lang ager G18) J4 Yo ang: al Uglil yalel egal aAq
Uo VJlioll Lu ole O40! Uo Geils Yu 62.I9 dol Joao
Uo Aldi JS yo Cy46 Is] jes! omy Udo Y.6 Jew Uo HSI JlSal
+96 625I9 dos) HL@Iayl 1A JAI US.0) CUIAS Or0cVl9 O92!
SECOND NORMAL FORM — 2NF uli! walsdteagoill .2
Juin Gu elid.o U Uw sgoe JS YoAY Ul pil! Galsil asqoill UL)
loric 6aclélioid Bibi .hS6 dip ejaJ Uno Quulull elidel) UolS
JUoJ! Ju ule agec Yo iS] Yo ly Qunuul eleo EL) Yody
ati2oll) LAI L8jx0 AYU drocUl Ole Yoiay Hors EL Ui WaLioU
QiiioI rou! A guululll iGo) @tio/I S320 (wll
le roizy "Allo! oul" YU QJW! Gals! edgoill Yo! a Ay
eli@oll ule riz) U gms 18) Willi Wj20 Ole U9 aiiall Wix0
Ol oly GY Jorall Uo "Aiioll rou! Uj] Elle Lay Le Sb gan!
(Glaiios!) alia Jgaa
THIRD NORMAL FORM ~ 3NF CuJUil! jalsJl @Sgoill 3
GU eli2o U Uw agor U5 Uoty Uf CUWI gals! @dgoUI Loy v
Adin Aligo Yas 6rccll YoAI Yi UAIg 86 AoSh yuwlwil alidol
J5 aloicl 6)91.4 Quadg Ie Gul ju Gal Aayo oj -Lasz las Uc
Ju ode Sl egui ole uo uuLusll clidoll ule aide U uu agoe
WaLaSl SS Le bedel op cage Yy algal V gull ggesle W jlaodll - calilull acy suatul
Alig! Lo120 WWI drocill ole Joiay Ugaa eal Ul UAsiol toll
fUOAI!, (SRP) iGo! Gia Gul pew pou (p1wLWwil tio!)
Iho Bay e180)! BiaUy Gul pew ode aol; puasd yi wayei
aolzy oll gag lids Y9> 3go2JI UW CHUL! gala! egoU/! Ugaal
Ul Vise! elidel! GjiaUl Bul jew gag elido Usa JA! ago le
U9 eli2o gs agoe gl yei Ole Ials YgSi Ul ay drocill Judit
Gi2Uy Gwi pew 89 406 dowd Jue C104 1] Jal aoe wi ule WWI
o 62clBl08d WLI QJWU9 LUA) [o.s9 POAI RI ELi4os .Aidoll
QO DAs! WI Al Jars CJ]! U8 PL VIVA Goll Uo Ulatlora
CGoIGjAUY Gul pow
UY aclgd jlo} le Ugoil SII
dlal Uc Ueis Woe G6 UW dacs Lazy djlj9 gi Cou iyo a3)
Uo UgSiu9 GUL! 6acls
QU! daaJl GUais Julai Ya PAU! Jiao Gusto AU! Woo 1
laAzu Laidileg GUL! d6lS Wasi 0) Veg LAU! Pari Wow
+ Layle QdgsGoUl aq1d/I9
QUI GUY! ysa4 GUY! 6rcl8 oro 98) UWI dred oro .2
JAY Julai 6b Ucg JHAU! azo ait le Waa Cys Ujdiw
oaIlUlaig Pad YA) Wi GULWldacls porArinig
Gayo lasdg Ws GUlWI drcls jLidlg clini] asUl dacs jaho 3
ULI dacld 613] G15 Laci rai doao)lorauogsy Wlég Usui
OULU! 6acls Jali QU doll UaAL Aojollrogds Aopoll .4
PO Yigg WLU! dacld pro Gyo! Wwiy wal dacld yao 5
lailola Aig GLU! dacls Gis 9! G64 Yo pAaill Uc Ugo
waljglad Glo daclUl Uoe dyél.o9 Ghatlally assy! EUS Woraig
Aull Qiloe PLA Pmol@o Wo ELAS UWLorrimioll Wo Lani
wbliaul
Pag Yoordiuo/ GUI drcls porAiuo We Gli: UgorAiuoll 6
of Gullo! uruniy 9.098) WU! io UW! 6acld Bo Ulolzio! dos
adil! Gle Jaws Goal GL! dacls Ai j59i9 Ullal jas
JU ula! 9.6 v2.04) 92 CUI dacls pola! Gilad!
G4oyiUl Uo cldci po.ag lea! UpeuiUY Yoo! pom sUglsutiloll .7
+ QoUHWUSdaiall
4 ) 20244) 018/Sioliggda BeAeololhgleyulaahi-slasiag lsh IsIulewinaleusyokonaah_ [79 W jlaoUll - Still aclgd lula
Qaloll WUg4ollg WUaoW Us Uc Ugigiwoll aa dlwall Igigimo .8
- AOUWh 6 LAAT LAAT Ig GULWIdaclé LAU
SWI Qual
(da163 150)
Aulaliiaal
de [jal6 Gatos UoSy qual Gull dla 4d
WLWlacigddjla|Owiaoly ©
AUSSI SWI Ug40 vlc Wi Rilg UU aio
ARS GosUSrcls clini]
Auwalligal
Wail wa
Wadi yaye
Jost oyal
Gols Galstt
ULI aclgd Sylal eB aoly
Lailily la] Ue Uo Ueay lag dey Glo yi! pe GUI aaa ali
Ao) GI GU! solos 6yls] Aol oa WLW! dls JA oll Wasi! CUS
Syl Glee a. usig GUL oJ] Jga9I QS of Gums CL ol)
(Database Management System or DBMS ) GULWIdacls dla] Aol oa lo
Ela pig Gyaaig Wjrig GUY rcigs eli Yporarimol Qos Aol ga
Microsoft SQL) J! g25 uu! (Oracle) JSlj9l «io GloUsimill JUA Wo GULull
(Access) ju 5! (Server
(UmswAill Access 2019
Qulla Microsoft office doja Uo dull Aol asl Uuuwdt aolp 223
aol) Lagnl! Qlxo aol: Uo GAl aol) Aol! a Lula OJ) ould
Aoja Si! VAg sl Ao YU Ayiq iS IMI Jgla al
Database Management System WUWWI acigé dla] do 4 anal ga yuuwSil
ladyeg Lacloyiuls CLL UAL UWS! Aol p09, JAI ylsz.o19 (DBMS)
Ula! @Slo) alae] Uo UNS JA (og Caglul Yo HdSu9 pb bas,
GLoglzoJl Eig loglzoll JlS3] LAWS (Lo oy. PIAALWIIg gli! Claw
AaliAo Bib bass ladyeg laclasulAos jlaodll - clilull acig atu
Lali! gl GUILAI! Uo Acana. ule Access 2019 4.0 WLW! dacs yaiaig
iio Lajjlalg GsloglzoJ Wass laolaaiw! U4) il
Uo Ug! Uo Aig daclHl ns GU! WAI U4 yao: Tables Yglaal
(46920) Gila aoc) goa
Ug. al yo laes Yo Wey) Yill WU! Jaw YL4 pag Forms @Aloill
Laysig
2.0 Gijxo UL Ue prulzil Lag! Uo AWAY LoS yang -: Queries lei
Was Yolaall 6 Gl yle Ghee 4ydi) WUILS gl dale Gulaii daclal
Lay Cau JI GLsJ] of Ugla sul eLiiu] of Laiya ai ol au
wloswiig Bylag Jui GL! delag Vase GUIS a9 —-Reports j)LoUl
dcoiio
rUuwAl Aolijs Cljroo pal
WISU! gi VALI @Se0) slac] aJno) djJSioll poladoll Uo WISI jog) ¥
‘wlio!
US, + Object Linking and Embedding ( OLE) JI Guidi agaq) dayii ¥
+ yg! Jio UNS! Ale Yost Aawlg) 120 Joc Vi
