Page 25 - Math_Genius_1 2

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