صفحه 1:
اه ع 21 COOOE: Tetrocduction to
ها | مه سیم
(. Outabases ved Database Desicqa
صفحه 2:
© dina Paterson
Row 99
9 07117 2/۳ ۳ Deveape هت توت
UNIVERSITY
صفحه 3:
“vw
Ones resvurves
©» @lackboud
* 09 5
ما یوق و
© اه رو مرا 6 tutpridl sheets, ptr
را و to ان resvurces
سس 9
تا
صفحه 4:
و 5
© Oo set text — utes wil be provided
© Dke Pollowier books wy be usePul addiizcadl
:عد لمجم
نزن و Outabuse Design! Pow Oovive to
ProPessivcal (Chie Churcher, Opress, ISOO 4-
SOOG9S-7S9-9)
» Weed Pirst SQL (byaa Beighey, O'Reilly, IEBO O-
S90-GCo0F-9)
= Ovuap viher books oa dotabuses ud GGL iu the
ما
0 یت
OARS
صفحه 5:
Oket te database? . |
© Ow ovleniioa oP dota cod be described us u dotcbose
° Computerised database systess une ww very
مور
© ماكو رصنل is stored too database every te Wwe!
© se a book wrt
© book v treet ticket
© woke oo uppoicte edt Wwitk a doctor
GAR هه موی
INIVERSITY
صفحه 6:
6 © dotabuse ان میامن علا اند وا dota whick pou
او صا لو
۱ usePul
wit #, pou ceed a Dutobuse Qucageweu Gpstew
(O®MC)
©» )5 OBOG vous the wup the date is stored vd the
powputer, wad provides ways oF yetticg cata ict cord
put oP the spstew
CR
NIVERSITY
صفحه 7:
سوه و لتطممس وا ول منرت Dke way io و
datubuse is kaput us the data wodel
® Cay cowputer databases developed ic the
(990s used o hierarchicd wodel
© Gisvir to the wap Piles ood Pokders are sill
و مه woderd pow;wputer Pie systews
© Oost dota does oot Pit very well oto ou siople
hierarchy
GAR همم
Niversity
صفحه 8:
Duta wodets
© Wierachicd data
6 Local Disk C3}
{© Documents and Setting:
۵ ماع جع
جمدلا اله جع
0 Go Default User
#2 DVD-RAM Drive (0)
=< Local Disk ©:
2 “Reakwordd” data — a clear hierarchy
Ter Booting
Pastas Tour
صفحه 9:
Rehticcd dotubuses پچ |
© Covoplex dota tke this is better koorded wits the
اس شا
© Oevised by Edyar Codd امه 00
databases امه ore مرجم مرول و( و
© otkough there are others! vbievt datibases, XL
databases
. 08 ومجاورره اأمججوص هوض ووودجادادك whick uses the
صفحه 10:
Qeseatatios tier
Qustaegs ter
صفحه 11:
J oa 3 Qeseutatios ter
| ce
و ی
واه
8 Cowwody used Por swuler systews
© Ovesu't sve well
© Can be harder مت وا
0 ] recon 0 ه94 02 1 0 a aan
UNIVERSITY
صفحه 12:
| ۲ ۱ 0000800085 سل
© Orcs Orvese
و اوه مرو متاخ او ما و و و و
users و ای ام و رن
° Oreck
pr yrcisatircer ها بو لح راو له ,موه له لین و
راوعمرن ۰
oad que pre, widely weed ia web ates ورن
ول ©
* ,مرول وا مت 000۵ موی oad sutable Por coche devices ۰
صفحه 13:
| 3 طامط 00006005
6 Ovst 30۵0) امه وج 9 مها لیم
۱ ی
© Por deskeers - رجات جا dato eoiry Pores to اجوج جط
Por the user interPoce
© روج deskmers — to presrot dota to the User
© stored procedures — 7 perPors provesstey oP cota
woorday to busicess niles
Gans هه هم
NIVERSITY
صفحه 14:
6۲060 aad vier جات re |
© Coo use pour RO@OOG ued its tovks Por
ارو
و له موه و جه 0000600085 هذا ص مون) ۰
the هه 9 ومممت بمتمومم سم له vikter tools
مهو viter
© Por exnople the BOOT ous cuse study:
© data euiry Pons ced reports une oreuted us web popes
© busters Inyo uses devo
CR
NIVERSITY
صفحه 15:
تسس تسه
امه use ای اه تال بو ©
databases pou usp ceed tv ue GAL
مورا بر تمسق و
Wwhick is used to dePice queries مها ما با و
Por sowe 00605 ١ه ما اوصسدوجم ه ذا بصصيو 08 ٠.
سوه سوه
nePerred to os تمه چاه دول Rebtiogd ©
GQD dorbases
صفحه 16:
GQL exavple . |
© GQL NETS oot be م ۲ 9 سانو
© Por pxuwple, the Polovieg query Pieds the fost
ewe oP dll the cusiowers ia u dotobuse:
SELECT LastName FROM Customers;
2 GQQDL veo dso be used to odd, update or delete dota,
coed ty build the database io the Pirst place
Gus Cana recon a Daas BaRap
Niversity
صفحه 17:
GGQD standards پچ |
© GQD is supposed ty be a stocdard hragquage Wwhick
is supported by dl ROODGs
۰ de Pact, pou weed to be corel becouse there ure
oP GQD wed by diPPered spstews
© OPercu versiow oF GGL standards (GQGLSS,
) 6 01,6© (.صاع,
© OPPeredt ope wectaicas by RDCOGS vectors
GAR هه هم
NIVERSITY
صفحه 18:
Qesiqatay 0 database پچ |
© 08 weldesiqaed dotubuse helps to woke sure thot the
data stored is ucrurdte ced pousisteot ood oot be
retdeved rusiy
© Ato, Por exaople, be tarvusistedt to store a
bookicy without storag the details oP the custower
waokicy the bovhicy
©» Dik corel desiqa, we co woke sure the dotcbuse
wot chow this to kuppeo
CR
NIVERSITY
صفحه 19:
database ” | 0 وداوي توصك با Gteps
6 Ortercviciay the ioteuded uses oP the spstew
. Creuttag a data wodel
. Ieopleseutioy the database
asa ] recon a Dabass BaD
UNIVERSITY
صفحه 20:
اس
|
مس[
۳
ar ero
esr
|
[otter
as
دسج
[cece
=
مج
ی
ی[
1
UNIVERSITY
۳
0
EALEDON'
5
صفحه 21:
باا0() اش ججسوتحادجا لجامجضج-اووزتات حاص صمو ج(]) ©
desiqa pur data wodel
© rere oe oer wethods whick ore dsv cower
used io dotubuse design
© Ove widely wed wetkod is cohed Cutiy Qebaticashiz
Oveelicey (ERO)
2 Represecuts the dota wodel us oo اه !)رش
Ong (ERO)
صفحه 22:
Crow dota wodel to dotubosr . |
© Oped to cousider how the dota wodel coo be
represeued ia a specific RDOOS
۰ Dis requires sowe ی
© ROOOG svPtwure kus spevitic ways ve
هه له جامجوج اوها the eutties, uttdbutes ord
rebtivaships ia the data wodel
2 (Por exavple, 0 dota wodel eutiy is represeued us a
fable iu the reloivod database
صفحه 23:
Qepreseuiny the data wodel
5
Feature in data model 50۲۵5۰۱۵۸9۱ ۱۱
Class (or entity) Add a table
Attribute Add a field (or column) with an appropriate data type to
the table
Object Add a row of data to the table
Relationship Add a foreign key — a field containing a reference to a
particular row of the related table
صفحه 24:
——— iad
° bustess tier
© Por exnople us duu closses und وان
° busicess logic io dave wetkods
© راهب fier
۱ وكمحادكلك د
© syste queries dotubuse to yet dota ft weeds tp curry outu
تست انوم
© Dre حول ول وهم صا كلججم مصاوررو
tubles to chusses
(@estcontan
UNIVERSITY