Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 25 - Math_Genius_1 2
P. 25

    fjys'kuy MsVkcsl (Relational Databases)
                       vkvks tkusa!

                                             +
                       fjys'kuy MsVkcsl ,Mxj ,IkQ dkWM osQ n~okjk izLrkfor fd;k x;k FkkA mUgksusa rsjg fu;eksa dk ,d lsV (dkWM dk fu;e)
                       fjys'kuy MsVkcsl eSustesaV flLVe dks ifjHkkf"kr djus osQ fy, fn;kA

                                            s
                         MsVkcsl iz.kkyh d ykHk (Advantages of a Database System)
                     MsVkcsl iz.kkyh osQ dbZ ykHk gSaA oqQN egRoiw.kZ ykHk fuEufyf[kr gSa%
                                  +
                        ;g MsVk IkQkbyksa dks ,dhÑr vkSj lk>k djosQ MsVk osQ nksgjko dks de djrk gSA
                        ;g HkaMkj.k LFkku cpkrk gSA
                        lHkh mi;ksxdrkZvksa dks oqQN ,Dlsl vf/dkj ;k fo'ks"kkf/dkj vkSj vuqefr;k¡ çnku dh tkrh gSaA
                                                               +
                        tc Hkh dksbZ cnyko fd;k tk jgk gks] rks IkQkbyksa dks vklkuh ls viMsV fd;k tk ldrk gSA

                         MsVkcsl dh lajpuk (Structure of a Database)
                     MsVk dks MsVkcsl dks Vscy esa lax`ghr fd;k tkrk gS] tSlk fd uhps fn, x, fp=k esa fn•k;k x;k gSA

                                                                  +
                                                                 IkQhYM~l
                                  jftLVªs'ku u-        uke            firk dk uke         tUe&frfFk        d{kk

                                  187/11       Ñ".kdkar            Jh osQ-,l- dkar    15/08/2007            VIII
                             fjdkM~lZ  156/12  ½f"k 'kekZ          Jh ,u-osQ- 'kekZ   22/10/2008            IX

                                                                   Jh th- ,l- iVsy
                                               lwjt iVsy
                                  194/11
                                                                                                            IX
                                                                                      16/04/2008
                                  123/12       fç;ka'k lkxj        Jh ih-osQ- lkxj    18/06/2007            VIII
                     fjys'kuy MsVkcsl osQ fy, vkerkSj ij bLrseky dh tkus okyh 'krs± gSa%
                        Vscy (Table)% ;g MsVkcsl esa dkWye vkSj jks”k (rows) esa O;ofLFkr lacaf/r MsVk dk ,d lewg gSA dkWye esa
                                                                                                           +
                         dbZ 'kh"kZd gksrs gSa] tSls fd jftLVªs'ku uacj] uke] firk dk uke] tUe&frfFk d{kk vkfnA bUgsa IkQhYM osQ :i esa
                                       +
                         tkuk tkrk gSA IkQhYM osQ fy, ekuksa osQ lsV dks fjdkWMZ dgk tkrk gSA fjdkWMZ Vscy dh ,d jks (row) gSA
                        izkbejh dh (Primary Key)% ;g ,d vf}rh; {ks=k gS] ftlosQ n~okjk ,d Vscy esa fjdkWMZ dh fof'k"V :i ls
                         igpku dh tkrh gSA ,d Vscy esa osQoy ,d çkFkfed dh gks ldrh gSA mnkgj.k osQ fy,] ,d Nk=k osQ fjdkWMZ
                         esa 'Reg No.' dks izkbejh dh dgk tk ldrk gSA
                        ç'u (Query)% ,d Dosjh MsVkcsl dh lcls 'kfÙkQ'kkyh fo'ks"krk gSA ;g vkidks oqQN ekunaMksa ;k 'krks± osQ vk/kj
                         ij fdlh Vscy ls tkudkjh çkIr djus esa enn djrk gSA vki osQoy Dosjh cukdj vkSj pykdj MsVkcsl ls MsVk
                         iwN ldrs gSa] <w¡<+ ldrs gSa vkSj iquçkZIr dj ldrs gSaA
                        fjiksVZ (Report)% Mhch,e,l esa Vscy ;k Dosjh ls vkus okys eSuhiqysV fd, x, MsVk dk vafre ifj.kke fjiksVZ
                         osQ :i esa tkuk tkrk gSA ;g fo'ks"k :i ls iQkWesZV osQ rjhosQ ls MsVk dks çn£'kr ;k fçaV djus osQ fy, fM”kkbu

                         fd;k x;k gSA

                                                                                      ,e,l ,Dlsl 2010 dk ifjp;      23

| 20 21 22 23 24 25 26 27 28 29 30 |