Thursday, August 23, 2018

Class-43 (Relation)




gvwëwgwWqv †Uªwbs GKv‡Wgx , wSbvB`n
mvwU©wd‡KU Bb Kw¤úDUvi Awdm A¨vwcø­‡Kkb

wi‡jkb t
wecyj cwigvb WvUv wb‡q KvR Ki‡Z wewfbœ iK‡gi WvUv †Uwej ˆZwi Ki‡Z nq| GK WvUv †Uwe‡ji mv‡_ Ab¨ WvUv †Uwe‡ji Z‡_¨i g‡a¨ m¤úK© ¯’vcb K‡i wewfbœ cÖKv‡ii WvUv‡K B”QvgZ Dc¯’vcb I e¨envi Kiv hvq| GKwU WvUv †Uwe‡ji WvUvi mv‡_ Ab¨ GK ev GKvwaK WvUv †Uwe‡ji WvUvi m¤úK© ¯’vcb‡K wi‡jkb e‡j| wi‡jkb ˆZwi Kivi Rb¨ KwZcq kZ© gvb‡Z nq| †hgb t
: wi‡jkb WvUv †Uwe‡j GKwU Kgb wdì _vK‡Z nq| †h wd‡ìi bvg, WvUv UvBc BZ¨vw` ûeyû GKB n‡Z nq|
: wi‡jkb WvUv †Uwe‡j GKwU wdì‡K cÖvBgvwi Kx wn‡m‡e wPwýZ Ki‡Z nq|
: Dfq †Uwej GKB †WUv‡eR dvB‡j _vK‡Z nq|

wi‡jkb ˆZwii myweav t
GKvwaK WvUv †Uwe‡ji g‡a¨ m¤úK© ¯’vcb K‡i A‡bK myweav cvIqv hvq| Zv‡`i g‡a¨ D‡jøL‡hvM¨ K‡qKwU n‡jv-
: `yB ev Z‡ZvwaK †Uwe‡ji g‡a¨ wi‡jkb Kiv _vK‡j †Uwej¸‡jvi g‡a¨ †_‡K B”Qvbyhvqx wKQy wdì wb‡q bZzb GKwU †Uwej Kiv hv‡e|
: wi‡jkb _vK‡j †Uwej¸‡jv GK mv‡_ Form Design wb‡q WvUv Gw›Uª Kiv hv‡e hv cÖwZwU †Uwe‡j †WUv P‡j hv‡e|
: wi‡jkb _vK‡j †Uwej¸‡jv n‡Z B”Qvbyhvqx wd츇jv wb‡q wcÖ›U †ei Kiv hv‡e|

wi‡jk‡bi cÖKvi‡f` t
WvUv †Uwe‡ji g‡a¨ wi‡jkb 4 cÖKvi n‡Z cv‡i| h_v-
: Iqvb Uz Iqvb wi‡jkb|
: Iqvb Uz g¨vwb wi‡jkb|
: g¨vwb Uz Iqvb wi‡jkb|
: g¨vwb Uz g¨vwb wi‡jkb|

Iqvb Uz Iqvb wi‡jkb t GKwU †Uwe‡ji †Kvb †iK‡W©i mv‡_ Aci GKwU †Uwe‡ji GKwU gvÎ †iK‡W©i m¤úK© m„wó Kiv‡K Iqvb Uz Iqvb wi‡jkb e‡j|

Iqvb Uz g¨vwb wi‡jkb t GKwU †Uwe‡ji †Kvb †iK‡W©i mv‡_ Aci GKwU †Uwe‡ji GKvwaK †iK‡W©i m¤úK© m„wó Kiv‡K Iqvb Uz g¨vwb wi‡jkb e‡j|

g¨vwb Uz Iqvb wi‡jkb t GKwU †Uwe‡ji GKvwaK †iK‡W©i mv‡_ Aci GKwU †Uwe‡ji GKwU †iK‡W©i m¤úK© m„wó Kiv‡K g¨vwb Uz Iqvb wi‡jkb e‡j|

g¨vwb Uz g¨vwb wi‡jkb t `ywU †Uwe‡ji g‡a¨ hLb Dfq c‡¶ GKvwaK g¨vwPs †iKW© _v‡K ZLb Zv‡K g¨vwb Uz g¨vwb wi‡jkb e‡j|
cÖvBgvwi Kx t `ywU †WUv‡e‡Ri g‡a¨ m¤úK© ¯’vcb Ki‡Z PvB‡j WvUv‡eR `ywUi g‡a¨ Aek¨B AšÍZ GKwU Kgb WvU wdì _vK‡Z nq| Kgb WvUv؇qi bvg Ges WvU UvBc GKB iKg n‡Z nq| GB wd‡ìi Ici wfwË K‡iB `ywU WvUv‡e‡Ri g‡a¨ m¤úK© ¯’vwcZ nq| GB WvUv‡e‡Ri BDwbK WvUv‡K cÖvBgvwi Kx e‡j|

d‡ib Kx t GKwU †Uwej Gi cÖvBgvwi Kx hLb Ab¨ †Uwej Gi †Kvb Kx Gi mv‡_ wi‡jkb ˆZwi K‡i ZLb Ab¨ †Uwej Gi †mB Kx †K d‡ib Kx e‡j|
wb‡gœ Course Teacher ‡Uwej `ywUi g‡a¨ wi‡jkb ˆZwi Kivi c×wZ †`Lv‡bv n‡jv-
Table : Course
Course
T-ID
Course
Duration
112
DBMS
5
113
OFFICE
2
114
GRAPHISC
3

Table : Teacher
Teacher
T-ID
Name
Qualification
Age
112
Jamal
M.Sc
29
113
Mostofa
B.Sc
35
114
Raja
M.Com
40

cÖvBgvwi Kx ˆZwi t
: Table wU wm‡j± K‡i Home wieb Gi Awab Views G wK¬K K‡i Design View evUb wK¬K Ki‡Z n‡e|
: ‡h wdì Gi Dci cÖvBgvwi Kx ˆZwi Ki‡ev †mB wd‡ì Kvm©i wb‡q Design wieb Gi Tools IqvK©MÖæ‡ci Primary Key evU‡b wK¬K Ki‡Z n‡e| †hgb : Course Ges Teacher ‡Uwe‡ji T-ID wdì|
: DB‡Ûv wU †K¬vR Ki‡Z n‡e| Zvici Yes wK¬K Ki‡Z n‡e| Zvn‡j H wd‡ìi Dci cÖvBgvix Kx ˆZwi n‡q hv‡e Ges wdìwU Pvex hy³ †`Lv hv‡e|
`yBwU †Uwe‡ji g‡a¨ wi‡jkb ˆZwi Kiv t
: Dfq †Uwe‡ji Kgb wd‡ìi †h †Kvb GKwU ev Dfq wd‡ì cÖvBgvix Kx ˆZwi Ki‡Z n‡e|
: Database Tools wieb Gi Show/Hide IqvK©MÖæ‡ci Aaxb Relationships evU‡b wK¬K Ki‡Z n‡e|
: Show Table WvqvjM eK&ª †_‡K wi‡jkbwkc Gi †Uwej mg~n‡K Add evU‡b wK¬K K‡i Relationships DB‡Ûv‡Z wb‡Z n‡e|
: Close evU‡b wK¬K Ki‡Z n‡e|
: ‡Uwej mg~n‡K †h Kgbwd‡ìi gva¨‡g Relationships Kiv n‡e †mB Kgb wdìwU WªvM K‡i Ab¨ †Uwe‡ji Kgb wd‡ì †Q‡o w`‡Z n‡e| †hgb Coruse ‡Uwe‡ji T-ID wdìwU Teacher ‡Uwe‡ji T-ID wdìwUi Dci †Q‡o w`‡Z n‡e|
: Create evU‡b wK¬K Ki‡Z n‡e|
: DB‡ÛvwU †K¬vR Ki‡Z n‡e Ges †mf Kivi Rb¨ Yes wK¬K Ki‡j †Uwej `yBwUi g‡a¨ wi‡jkb n‡q hv‡e|



XML—eXtensible Markup Language
Y2K—Year Two Thousand
HTTP — Hyper Text Transfer Protocol. 
HTTPS — Hyper Text Transfer Protocol Secure. 
IP — Internet Protocol. 
URL — Uniform Resource Locator.
USB — Universal Serial Bus.
VIRUS — Vital Information Resources Under Seized. 
3G — 3rd Generation.
GSM — Global System for Mobile








No comments:

Post a Comment