کامپیوتر و IT و اینترنت

Introduction to Database Development

صفحه 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

جهت مطالعه ادامه متن، فایل را دریافت نمایید.
34,000 تومان