
	Trending ▼ ICSE CBSE 10th ISC CBSE 12th CTET GATE UGC NET Vestibulares ResFinder

GSEB, 10th Study Material, Computer, Chapter - 1 (Gujarati Medium)

14 pages, 0 questions, 0 questions with responses, 0 total responses,

	kamalnik	+Fave Message
	Profile Timeline Uploads

Home > kamalnik >

Formatting page ...

1. DBMS ni[ p(rcy an[ MS-Access p[k[j 1. DBMS ni[ p(rcy an[ MS-Access p[k[j (vgt (Data) an[ mi(ht) (Information): - ki[e y(kt, AYL, vAt& aYvi ki[e GTni a>g[n) tmim p\kirn) hk)kti[, ai>kDiai[ an[ (vgti[n[ Data kh[ C[. - D[Ti ki[e pN Av$p[ hi[e Sk[ C[. t[ l[(Kt, mi](Kk, k y*TrkZt k[ (bnk y*TrkZt pN hi[e Sk[ C[. - D[Ti a[ni m*LB*t Av$pmi> k>e Kis upyi[g) bnti[ nY) - upyi[g) an[ aY<p*N< mi(ht) t]yir krvi miT[ D[Ti pr yi[ y p\(k|yi krv) j$r) C[. - mi(ht) (Information) a[ D[Ti prY) mLt&> aiv yk p(rNim C[. - mi(ht) a[ (nN<y p\(k|yi miT[ piyi smin bn[ C[. - sci[T an[ s>b>(Ft mi(ht)n[ aiFir[ smysr (nN<yi[ l[viY) aipNn[ AviBi(vk r)t[ j fiydi[ Yiy C[. D[Ti mi(ht) p\(k|yi - GN) vKt aipNi miT[n) mi(ht) b)ji miT[ D[Ti bn[ C[. - di.t. p\(k|yi kici[ mil t]yir mil K[D*t S[rD Ki>Dn&> kirKi Ki>D k>di[e m)qi D[Tib[z (Database) an[ D).b).a[m.a[s. (DBMS): - s& yv(AYt r)t[ s>g\hiy[l s>b>(Ft (vgti[ {D[Ti}ni[ sm*h a[Tl[ D[Tib[z - MS-Access ni> s>dB<mi> D[Tib[zn) yi yi: D[Tib[z a[Tl[ T[bl, kv[r), fi[ s<, (rpi[T< an[ (v(nyi[g mi[Dy& s tr)k[ ai[LKiti s>b>(Ft D[Ti ai[ j[kTni[ sm*h . - aipN[ bFi aipNi ri[(j>di Jvnmi> jiN[ - ajiN[ a[k yi b)ji p\kirni an[k D[Tib[zni[ upyi[g kr)a[ C)a[. (m#ii[ an[ sgi>-s>b>F)ai[ni nim, srnimi, fi[n n>br Frivt) Diyr). T[(lfi[n D)r[kTr) SiLimi> (vwiY)<ai[n) mi(ht) ni[ F riKvi miT[n&> hijr)p#ik (vwiY)<ai[ni> p(rNimn[ ni[>Fvi p(rNimp#i F>Fik)y a[kmi[ oiri riKvimi> aivti (hsib) ci[pDi, j Yivh), v[ciNpi[Y), ri[kDpi[Y) - k y*Tr aiFi(rt D[Tib[z pr n)c[ m*jbni kiyi[< krvi pD[ C[. nvi[ D[Tib[z t]yir krvi[ jyir[ jyir[ yvhir sji<y Ryir[ trt j t[n) (vgti[ D[Tib[zmi> um[rv) jyir[ jyir[ x(tai[ yin pr aiv[ Ryir[ Ryir[ D[Tib[zn) (vgti[mi> s&Firi vFiri krvi D[Tib[zmi> ji[ ki[e (bnj$r) (vgti[ jNiy ti[ t[n[ kiQ) niKv) D[Tib[zn) (vgti[n[ yi[ y k|mmi> gi[qvv). Kamal Jotangia Fi[rN - 10 1 1. DBMS ni[ p(rcy an[ MS-Access p[k[j - D[Tib[zn) yvAYipnn&> kiy< krvi miT[n) p F(t an[ r)tn[ D).b).a[m.a[s. tr)k[ ai[LKvimi> aiv[ C[. - D.B.M.S. n&> aiK&> nim Database Management System C[. - aim aivi p\kirn&> kiy< krvi miT[ aipNn[ Kis si[fTv[rn) j$r pD[ C[. aivi si[fTv[r DBMS si[fTv[r kh[ C[. - FoxPro, MS-Access, Oracle, Ingress, SQL Server, My SQL vg[r[ ji(Nti DBMS si[fTv[rni> nim C[. MS-Access: - MS-Access a[k Relational Database Management System (RDBMS) si[fTv[r C[, j[ USA n) Microsoft k>pn) oiri t]yir kr[l MS-Office p[k[jni[ a[k Big C[. - Access D[Tib[z a[ T[bl, kv[r), fi[ s<, (rpi[T`<s, m[k|i[z, p[(js an[ (v(nyi[g mi[Dy& s tr)k[ ai[LKiti (v(vF p\kirni s>b>(Ft D[Ti ai[ j[kTni[ sm*h C[. {T[bl}: - D[Tib[zmi> (vgti[ sicvvi miT[ni[ t[ m*LB*t a[km C[. - t[ a[kb)ji siY[ s>b>F Frivt) (vgti[ni[ yv(AYt s>g\h C[. - t[mi> a[k aYvi a[k krti> vF& UB) hri[L C[, j[n[ (f D (Field) tr)k[ ai[LKvimi> aiv[ C[. an[ a[k aYvi a[kY) vFir[ aiD) hri[Ln[ r[ki[D< (Record) kh[ C[. (1) Table Roll No Name 1 Piyush 2 Girish 3 Mayur Marks 300 275 250 Records Fields - a[kb)ji siY[ s>b>F Frivti a[kY) vF& T[blni sm&hn[ D[Tib[z kh[ C[. - di.t. (vwiY)<ai[n) simi y mi(ht), p(rNimn) (vgti[, f) a>g[n) (vgti[, (vPyi[n) (vgti[, (s( a>g[n) (vgti[ vg[r[ tmim (vgti[ alg alg T[bl Av$p[ t]yir kr) t[ tmim s>b>(Ft T[bln[ a[k siY[ Student nimni D[Tib[zmi> riK) Skiy C[. (2) Forms {fi[ s<}: - T[blmi> (vgti[ an[ mi(ht) diKl krvi, s&Firvi t[mj (nhiLvi miT[ e( Ct Av$p, S]l) tYi (nyt rcni Frivti ai[ j[kTn[ fi[m< (Form) kh[ C[. - ki[epN y(ktn) y(ktgt j$(ryiti[ an&sir fi[ s< t]yir kr) Skiy C[. (3) Query {kv[r)}: - D[Tib[zn) p(rBiPimi> ki[epN T[blmi> pD[l) (vgti[mi>Y) j$r) mi(ht) m[Lvvi p&Citi p\ nn[ kv[r) (Query) kh[ C[. - di.t. dSmi Fi[rNmi> 70% krti> vF& g&N m[Lvnir (vwiY)<ai[ k[Tli C[? (4) Reports {(rpi[T<}: - j$(ryit an&sir s&vi y an[ yv(AYt Av$p[ mi(ht)n) rj*aitn[ (rpi[T< {ah[vil} kh[ C[. - Access mi> kv[r)n&> p(rNim UB) an[ aiD) hri[L Av$p[ dSi<viy C[. ji[ ai p(rNimn[ aikP<k an[ yv(AYt r)t[ dSi<vv&> hi[y ti[ (rpi[T<ni[ upyi[g kr) Skiy C[. Kamal Jotangia Fi[rN - 10 2 1. DBMS ni[ p(rcy an[ MS-Access p[k[j - Access mi> u c g&Nv_iiy&kt asrkirk (rpi[T< t]yir krvin) s&(vFi C[. (5) Macro {m[k|i[}: - DBMS mi> avirnvir {vir>vir} krvi> pDti> kiyi[<n[ Avy>s>ci(lt krvi miT[ a[k svlt aipvimi> aiv) C[, j[n[ m[k|i[ (Macro) kh[ C[. - m[k|i[ a[ a[k s*cniai[ni[ sm*h C[, j[ yid)mi> dSi< yi p\miN[ an&srvi tmim kiyi[<n[, a[k pC) a[k a[m k|mb r)t[ amlmi> m*k[ C[. (6) Modules {mi[Dy& s}: - D[Tib[zni s>dB[< Modules a[ ki[e ci[ s kiy< pir piDvi t]yir kr[l Visual Basic n) Procedures and declarations ni[ sm*h C[. - T*>kmi> mi[Dy&l a[ VBA n) s*cniai[n&> s>g\ihk C[. - mi[Dy&lmi> gm[ t[Tl) s&cniai[ riK) Skiy C[. D[Tib[z t]yir krvi[: - Firi[ k[ aipN[ ki[e SiLi s>b>(Ft mi(ht) sicvv) C[. ti[ t[ni miT[ School Management System nimni[ D[Tib[z bniv) Skiy C[. - Access mi> D[Tib[z t]yir krvi miT[ n)c[ni pgli> an&srvi>: 1. a[( TT) (Entity) n ) krv): ki[epN y(kt, vAt&, AYL k[ ki[epN a y ai[ j[kT k[ j[ni (vS[ aipN[ D[Tib[zmi> (vgti[ sicvvi e Cti hi[ea[ t[n[ Entity kh[ C[. aipNi udihrN an&sir aipN[ (vwiY)<, (Sxki[ an[ (vPyi[n[ lgt) (vgti[ m*k)S&>. ai miT[ dr[k a[(T T) miT[ a[k T[bl t]yir kr)S&>. aim aipN[ Student, Teacher an[ Subject nimni> #iN T[bl bniv)S&>. 2. (f D (Field) n ) krv): hv[ dr[k (Entity) miT[ kyi (f D {a[(T^ y&T} sicvvi t[ n ) krvimi> aiv[ C[. udihrN tr)k[ (vwiY)<, (Sxk an[ (vPyi[n[ lgt) ke (vgti[ sicvv) t[ n ) krv&>. (f D {a[(T^ y&T} n[ T[bl {a[(T T)} ni g&NFmi[< tr)k[ pN yi yi(yt kr) Skiy. Student, Teacher an[ Subject nimni> T[blmi> n)c[ m&jbn) (vgti[ sicv)S&>. Student: Field Name Grno Firstname Surname Address City Pincode Birthdate Gender Standard Join_date Leave_date Description General Register Number of the Student Name of the Student Surname of the Student Address of the Student City Name Pincode Number Date of Birth Male or Female Studying in which Standard Date of Joining the School Date of Leaving the School Teacher: Field Name Tcode Firstname Surname Description Code of the Teacher Name of the Teacher Surname of the Teacher Kamal Jotangia Fi[rN - 10 3 1. DBMS ni[ p(rcy an[ MS-Access p[k[j Address City Pincode Phone_no Email_id Mobile_no Subject: Field Name Scode Subname Details 3. Address of the Teacher City Name Pincode Number Phone Number of Teacher Email-ID of Teacher Mobile Number of Teacher Description Code of the Subject Name of the Subject Description of the Subject dr[k (f Dmi> kyi p\kirn) (vgti[ sicvv) t[ n ) krv&>: aini aiFir[ t[bl t]yir krt) vKt[ aipN[ dr[k (f Dn) D[Ti Tiep n ) kr)a[ C)a[. D[Ti Tiep a[ ki[epN (f Dn&> s>g\hmiLK&> n ) krvin) a[k r)t C[. MS-Access mi> upl F D[Ti Tiep: T[bln) rcni kr) vKt[ dr[k (f D miT[ D[Tini[ p\kir n ) krvi[ frJyit C[. D[Ti Tiep a[ (f Dn&> s>g\h-miLK&> n ) krvin) r)t C[. MS-Access n)c[ m&jbni D[Ti Tiep Friv[ C[. 1. Number: Access mi> ki[epN s> yi {p*Ni k k[ ap*Ni k} sicvvi miT[ ai D[Ti Tiepni[ upyi[g Yiy C[. di.t. Marks, Roll No, Salary vg[r[ 2. Text: Access mi> 255 k[r[kTrs< s&F)n) T[ T sicvvi miT[ ai D[Ti Tiepni[ upyi[g Yiy C[. t[mi> axri[, a>ki[ tYi (vS[P (ch`ni[ Frivti[ D[Ti sicv) Skiy C[. di.t. Firstname, Address, City vg[r[ 3. Memo: Access mi> 255 k[r[kTrs<Y) vF& mi[T) mi(ht) sicvvi miT[ ai D[Ti Tiepni[ upyi[g Yiy C[. t[mi> aiSr[ 64000 k[r[kTrs< {32 pini} s&F)n) mi(ht) sicv) Skiy C[. T*>kmi> t[mi> vN<niRmk mi(ht) sicv) Skiy C[. 4. Date/Time: Access mi> tir)K an[ smyn[ lgt) mi(ht) sicvvi miT[ ai D[Ti Tiepni[ upyi[g Yiy C[. di.t. Birthdate, Join_Date vg[r[. 5. Currency: clN) niNi>(ky mi(ht) sicvvi miT[ ai D[Ti Tiepni[ upyi[g Yiy C[. cir dSi>S AYin Frivt&> t[ a[k ci[ s miLK&> C[. di.t. Tuition_fee, Term_fee vg[r[ 6. AutoNumber: T[blmi> dr[k nvi[ r[ki[D< um[rti> MS-Access aipm[L[ k|mi>k Br[ t[ miT[ ai[Ti[n>brni[ upyi[g Yiy C[. ai D[Ti Tiepmi> aipm[L[ 1, 2, 3, 4, ... (k mti[ le l[vimi> aiv[ C[. upyi[gkti< t[n) (k mti[n[ bdl) Skti[ nY). di.t. Roll_No, Bill_No vg[r[ 7. Yes/No: ai Boolean p\kirn) D[Ti Tiep C[, j[mi> b[ (vk pi[ p]k)ni[ a[k (vk p s>g\h) Skiy C[. di.t. Pr_Ab, Fees_Paid vg[r[ 8. OLE(Object Linking & Embedding): ki[e b)ji si[fTv[rmi> bniv[l mi(ht)n[ Access mi> livvi miT[ ai D[Ti Tiepni[ upyi[g Yiy C[. di.t. Paint p\i[g\immi> bniv[l fieln[ Access ni T[blmi> livvi miT[ OLE D[Ti Tiepni[ upyi[g kr) Skiy C[. 9. Hyperlink: v[b sieTni URL aYvi e-m[el a[D^[sni[ s>g\h krvi miT[ ai D[Ti p\kirni[ upyi[g Yiy C[. di.t. Email_id, Website vg[r[ Kamal Jotangia Fi[rN - 10 4 1. DBMS ni[ p(rcy an[ MS-Access p[k[j - hv[ aipN[ bniv[l T[bln) D[Ti Tiep n ) kr)a[: Student: Field Name Grno Firstname Surname Address City Pincode Birthdate Gender Standard Join_date Leave_date Data Type Number Text Text Text Text Number Date/Time Yes/No Number Date/Time Date/Time Teacher: Field Name Tcode Firstname Surname Address City Pincode Phone_no Email_id Mobile_no Data Type Text Text Text Text Text Number Text Text Text Subject: Field Name Scode Subname Details Data Type Text Text Text n ) krvi: D[Tib[z t]yir krvi miT[n&> ai a>(tm pg(Yy&> C[. T[bln&> ki[e a[v&> (f D j[ T[blmi> aji[D mhRv Frivt&> hi[y t[ (f Dn[ k)-(f D (key field) kh[ C[. di.t. student T[blmi> a[k j nim an[ aTkviLi a[k krti> vF& (vwiY)< hi[e Sk[ C[, an[ t[Y) SiLini dr[k (vwiY)<n[ ci[ spN[ ai[LKvi miT[ ai jnrl r(jATr n>br mdd kr[ C[. aim, aivi> (v(SOT (f D GNi bFi r[ki[D<ni sm*hmi>Y) ki[e ci[ s r[ki[D<n[ ai[LKvi miT[ mdd$p n)vD[ C[. 4. Key Field {p\iY(mk k)} : D[Tib[zn) p(rBiPimi> dr[k r[ki[D<n[ aji[D r)t[ ai[LK) Skvi sxm civ)$p (f Dn[ primary key tr)k[ ai[LKvimi> aiv[ C[. Primary key n) (k mt kyir[y b[ vir (duplicate) hi[e Sk[ nh) t[mj t[ kyir[y Kil) (NULL) hi[e Sk[ nh) . Primary key Kamal Jotangia Fi[rN - 10 5 1. DBMS ni[ p(rcy an[ MS-Access p[k[j MS-Access S$ krv&> an[ nvi[ Database bnivvi[: {p\iyi[(gk kiy<} - Start Programs (aYvi All programs) Microsoft Access pr (klk krviY) MS-Access p\ - i[g\im S$ YS[. File New pr (klk kri[. j[Y) n)c[ m&jbn) Ak|)n mLS[. Blank Database - Blank Database pr (klk kri[. j[Y) n)c[ m&jbn) Ak|)n mLS[. Kamal Jotangia Fi[rN - 10 6 1. DBMS ni[ p(rcy an[ MS-Access p[k[j - D[Tib[zn&> nim ai yi pC) Create bTn pr kl)k kri[. aim krviY) n)c[ m&jbn) Ak|)n mLS[. - nv&> T[bl bnivv&>: D[Tib[zmi> nv&> Table bnivvin) #iN r)t C[. - 1. Create Table in Design view 2. Create Table by using Wizard 3. Create Table by entering Data (Datasheet view) aimi>Y) Create Table in Design view pr Dbl kl)k kri[. j[Y) n)c[ m&jbn) Ak|)n mLS[. Kamal Jotangia Fi[rN - 10 7 1. DBMS ni[ p(rcy an[ MS-Access p[k[j - ai p\miN[ bFi j (f Dni nim lK)n[, T[bln[ s[v krvi miT[ File Save pr kl)k krti> n)c[ m&jbn) Ak|)n mLS[. - ah) T[bln&> nim Student Tiep kr)n[ OK bTn upr kl)k kri[. j[Y) n)c[ m&jb Ak|)n mLS[. - ah) Primary key bnivvin) n hi[viY) No bTn upr kl)k kri[. j[Y) T[bl Save Ye jS[. hv[ fkt T[bln) (v Di[ b>F krviY) n)c[ p\miN[ l)ATmi> Student nimn&> T[bl ji[e SkiS[. Kamal Jotangia Fi[rN - 10 8 1. DBMS ni[ p(rcy an[ MS-Access p[k[j - hv[ ai T[blmi> r[ki[D< diKl krvi miT[ l)ATmiY) Student T[bl ps>d kr) Open upr kl)k kri[ aYvi Student T[bl upr Dbl kl)k kri[. j[Y) n)c[ m&jbn) Ak|)n mLS[. Navigation Bar - Navigation bar n) ai[LK: Total Records First Record Last Record New Record Next Record Current Record T[bl pr krvin) (k|yiai[ 1. (vgti[ um[rv) (Addition of New Records) T[[bl bni yi pC) nvi r[ki[D< um[r) Skiy C[. T[blmi> a[ T^) krt) vKt[ t[n) (v Di[mi> n)c[ m&jbni Icons ji[vi mL[ C[. 1. - r[ki[D< pi[e Tr (Record Pointer): hil aipN&> ks<r kyi r[ki[D< upr C[, t[ dSi<v[ C[. 2. - a[ D ai[f F T[bl mik< (End of the Table mark): t[ T[blni[ a>(tm r[ki[D< pC)ni[ r[ki[D< dSi<v[ C[. 3. - a[(DT aieki[n (Edit Icon): D[Timi> s&Firi krvi miT[ jyir[ tm[ t[ (f Dmi> kl)k krSi[ Ryir[ r[ki[D< pi[e Trn&> aieki[n a[(DT aieki[nmi> f[rvie jS[. Kamal Jotangia Fi[rN - 10 9 1. DBMS ni[ p(rcy an[ MS-Access p[k[j 2. T[blni r[ki[D< s&Firvi (Editing Data in the Table) T[blmi> Br[l (vgti[mi> s&Firi-vFiri krvin) (k|yin[ a[(D(T g (Editing) kh[ C[. ji[ ki[e Ki[T) mi(ht) diKl Ye hi[y aYvi ti[ ki[en) mi(ht) bdlie hi[y Ryir[ a[(D(T gn) j$r pD[ C[. n)c[ni (kAsiai[mi> aipN[ T[blmi> s&Firi-vFiri kr) Skti nY). 1. AutoNumber D[Ti p\kirni (f Dmi>n) (k mti[ bdl) Skit) nY) 2. ji[ a[ T[bl b)ji T[bl siY[ s>b>(Ft hi[y, ti[ key field n) (k mt bdl) Skit) nY). 3. r[ki[D< kiQ) niKvi (Deletion of Records) T[blmi>ni r[ki[D<n[ kiQ) niKvi miT[, T[bl ai[pn kri[ an[ j[ r[ki[D< kiQ) niKvi[ hi[y t[n[ ps>d kri[. n)c[n) r)ti[mi>Y) ki[e a[k r)t[ tm[ ps>d kr[l r[ki[D<n[ kiQ) Ski[ Ci[. 1. k)-bi[D< prY) Delete k) dbivi[. 2. Edit Delete Record (vk p pr (klk kri[. 3. (v Di[ni T&lbir pr aiv[l (Delete Record) ni aieki[n pr (klk kri[. 4. ps>d kr[l r[ki[D< pr mius pi[e Tr le jen[ Right Click kr) mLti m[n&mi>Y) Delete Record ps>d kri[. jyir[ aipN[ uprn) ki[e a[k r)t[ r[ki[D< kiQ) niK)S&> Ryir[ trt j aipNn[ n)c[ m&jb a[k (v Di[ mLS[. ah) Yes bTn upr (klk krti> r[ki[D< kiym miT[ T[blmi>Y) delete Ye jS[, jyir[ No bTn upr (klk krti> t[ r[ki[D< delete YS[ nh). 4. T[blmi> D[Tin[ gi[qvvi (Sorting Data) Sorting a[Tl[ ki[e ci[ s k|mmi> D[Tin) gi[qvN) krv). D[Tin) gi[qvN) krviY) mi(ht) zDpY) an[ srLtiY) mL[ C[. T[blmi> D[Tin) gi[qvN) krvi miT[ #iN r)t C[. 1. j[ (f D upr D[Ti si[T< krvi e Cti hi[ t[ (f Dni nim pr {di.t. Surname (f D} (klk kri[. Ryir bid T*lbir pr aiv[l (Sort Ascending) aYvi (Sort Descending) ni aieki[n pr (klk kri[. 2. (f Dni h[(D g pr right click kr) mLti n)c[ m&jbni m[n*mi>Y) Sort Ascending aYvi Sort Descending (vk p pr (klk kri[. Kamal Jotangia Fi[rN - 10 10 1. DBMS ni[ p(rcy an[ MS-Access p[k[j 3. (f Dni h[(D g pr (klk kr), m[n*bir pr n)c[ m&jbni (vk pi[ pr (klk kri[. Records Sort Sort Ascending aYvi Sort Descending 5. T[bl kiQ) niKv&> (Deletion of Table) D[Tib[zmi>Y) T[bl kiQ) niKvi miT[, D[Tib[z (v Di[mi> T[bl ps>d kri[ an[ Ryirbid n)c[n) r)ti[mi>Y) ki[e a[k r)t[ tm[ ps>d kr[l T[bln[ kiQ) Ski[ Ci[. 1. k)-bi[D< prY) Delete k) dbivi[. 2. Edit Delete (vk p pr (klk kri[. 3. (v Di[ni T&lbir pr aiv[l (Delete) ni aieki[n pr (klk kri[. 4. ps>d kr[l T[blni nim pr mius pi[e Tr le jen[ Right Click kr) mLti m[n&mi>Y) Delete ps>d kri[. jyir[ aipN[ uprn) ki[e a[k r)t[ T[bl kiQ) niK)S&> Ryir[ trt j aipNn[ n)c[ m&jb a[k (v Di[ mLS[. ah) Yes bTn upr (klk krti> T[bl kiym miT[ D[Tib[zmi>Y) delete Ye jS[, jyir[ No bTn upr (klk krti> t[ T[bl delete YS[ nh). Kamal Jotangia Fi[rN - 10 11 1. DBMS ni[ p(rcy an[ MS-Access p[k[j Practical Assignments: (1) Table Name: Student Field Name Data Type Grno Number Firstname Text Surname Text Address Text City Text Pincode Number Birthdate Date/Time Gender Yes/No Standard Number Join_Date Date/Time Leave_Date Date/Time Description General Register Number of the Student Name of the Student Surname of the Student Address of the Student City name Pincode Number Birth Date of the Student Male or Female Standard in which studying currently Date of joining the School Date of Leaving the School (2) Table Name: Teacher Field Name Data Type TCode Text Firstname Text Surname Text Address Text City Text Pincode Number Phone_no Number Email_id Hyperlink Mobile_no Number Description Code of the Teacher Name of the Teacher Surname of the Teacher Address of the Teacher City name Pincode Number Phone number of the Teacher E-mail address of the Teacher Mobile number of the Teacher (3) Table Name: Subject Field Name Data Type SCode Text Sub_name Text Details Text Description Code of the Subject Name of the Subject Description of the Subject (4) Table Name: Class_Teacher Field Name Data Type TCode Text Standard Number Year Number Description Code of the Teacher In which Standard In which Year Kamal Jotangia Fi[rN - 10 12 1. DBMS ni[ p(rcy an[ MS-Access p[k[j (5) Table Name: Standard_Sub Field Name Data Type SCode Text Standard Number Description Which Subject Which Standard (6) Table Name: Sub_Teacher Field Name Data Type TCode Text SCode Text Standard Number Year Number Description Code of the Teacher Subject Code In which Standard Current Year (7) Table Name: Attendance Field Name Data Type Grno Number Date Date/Time Pr_Ab Yes/No Description General Register Number of the Student On which Date Present or Absent (8) Table Name: Fees Field Name Grno Date Tuition_Fee Term_Fee Data Type Number Date/Time Currency Currency Description General Register Number of the Student On which Date Tuition Fee paid by the Student Term Fee paid by the Student (9) Table Name: Result Field Name Data Type Grno Number SCode Text Month Text Year Number Term Number Marks Number Description General Register Number of the Student Subject Code In which Month In which Year In which Term Marks Obtained Kamal Jotangia Fi[rN - 10 13 1. DBMS ni[ p(rcy an[ MS-Access p[k[j (10) Table Name: Sports Field Name Data Type Grno Number Interest Text Achievement Memo Description General Register Number of the Student In which Game Achievements in a Game (11) Table Name: Cultural Field Name Data Type Grno Number Interest Text Achievement Memo Description General Register Number of the Student In which Activity Achievements in Cultural Activities Kamal Jotangia Fi[rN - 10 14

Formatting page ...

Additional Info : Study Material
Tags : Study Material, Gujarat Board, Computer subject, Gujarati Medium,

kamalnik chat

Horizontal lines at:
Guest Horizontal lines at:
AutoRM Data:
Box geometries: