Imwe yezvinonyanya kukosha munyaya dzekudzidzira iri kuumba hukama pakati pematafura epa database. Ihu hukama hunopa nzira yekubatanidza dhesi rakachengetwa mumatafura akawanda uye kuitora nenzira yakakodzera. Kuti ugadzire kuwirirana pakati pematafura maviri, unofanira kufanidza kiyi yekunze mune imwe tafura iyo inofananidzira kenduru mune imwe tafura.
Dhewadhi Dhesi uye Uhukama
Iwe unogona kunge uchiziva kare kuti ma database anongova marwendefa ematafura , akafanana nezvamungatoshandisa kare mupurogiramu yepadheseti , yakadai seMicrosoft Excel. Chaizvoizvo, iwe unogona kutotanga kushandura Excel spreadsheet kune database. Apo databases dzinosiyana kubva pamapaparishiti, zvisinei, kana iri pakasvika kuvaka hukama hwakasimba pakati pematafura.
Funga, somuenzaniso, database yakashandiswa nekambani yekuona vanhu ruzivo rwemashoko. Dhiyabhorosi iyo inogona kuva nefurafura inonzi VaHurumende ine mashoko anotevera kune mumwe nomumwe wevashandi vekambani:
- Dhiyabhorosi ID
- Zita rokutanga
- Zita rokupedzisira
- OfficePhone
- HomePhone
- PositionID
Mumuenzaniso uyu, Dhiyabhorosi yevashandi ndeyeiyo yakagadzirirwa yakawanda iyo inopiwa kune umwe neumwe mushandi kana yakawedzerwa kune database. Nzvimbo yeChiratidzo isimboti yebasa inoshandiswa kureva nzvimbo yevashandi mukambani. Muchirongwa ichi, mushandi anogona kungova nechinzvimbo chimwechete, asi vatengi (kana kwete) vashandi vanogona kuzadza nzvimbo imwe neimwe. Somuenzaniso, unogona kuva nemazana evashandi vane nzvimbo ye "Cashier".
Dhiyabhorosi inogonawo kuva nefurafura inonzi Positions neinotevera ruzivo rwekuwedzera pamusoro pechigaro chega chega:
- PositionID
- Title
- JobLevel
- SkillCategory
- Nzvimbo
Iyo Position ID mundima iyi iri tafura yakafanana neAvayee ID mundima muHurumende yeVashandi - iyo inowanikwa yakaenzana yakawanda iyo yakasikwa apo chinzvimbo chiri kuwedzerwa kune database.
Apo patinenge tichienda kunokora rutengo rwevashandi kubva kune dhesi, zvingave zvakasikwa kukumbira zita romumwe nomumwe uye zita rake. Zvisinei, ruzivo urwu runochengetwa mumatafura akawanda e-database, saka rinogona kuwanikwa chete uchishandisa JOIN mubvunzo unoda hukama huripo pakati pematafura.
Paunotarisa chimiro chematafura, munda unotsanangura ukama huri pachena - Position ID field. Mumwe nomumwe mushandi anogona kuva nechinzvimbo chimwe chete uye iyo nzvimbo inowanikwa nekusanganisira Position ID kubva pane imwe nzvimbo yePasitions yakafanana. Mukuwedzera pakuva chinhu chinokosha chetafura yePosita, mumuenzaniso uyu, Position ID munda zvakarewo kiyi yekune imwe nyika kubva kuTashandi vekushandisa kusvika kuIndaneti. Dhiyabhorosi inogona kushandisa svondo iyi kuti iyananise mashoko kubva pamatafura akawanda uye ivai nechokwadi chokuti chero kuchinja kana kuwedzerwa kune database kunoramba kusimbisa kutendeseka kwehutano .
Kana ukangosarudza kiyi yekunze, iwe unogona kuenda mberi uye kukoshesa zvido zvaunoda kubva pane dhesi uchishandisa mubvunzo unotevera:
Kuumba Maoko Okune dzimwe nyika muSQL Server
Zvechokwadi, iwe haufaniri kutsanangura ukama hwacho zvakananga kuti hukwanise kuita mibvunzo yakafanana neyo pamusoro apa. Zvisinei, kana iwe uchitaura zvakajeka ukama uchishandisa chinyorwa chekune imwe nyika, database yacho ichakwanisa kuita rimwe basa rekuchengetedza imba kwauri:
- Paunowedzera zvinyorwa zvitsva patafura yeVashandi, dhesiyo ichaita kuti iyo Position ID yaunopinda inokosha yakakosha kiyi muPaiti yePosita.
- Kana ukashandura Position ID muPaiti yePosita, d database inogona kuita zvinyorwa zvinodiwa kuTabha reVashandi kuchengetedza kusagadzikana.
- Dhesizheni inogona kuchengetedza kunopikisa kubviswa kwechigaro kubva patafura yepamusoro nekuramba kubvisa nzvimbo neinoenderana nheyo dzevashandi kana kuita chekudzikisa kushandiswa kwevashandi vose vane chokuita.
Hezvino ndiyo nzira yaunogona kugadzira kiyi yekunze muSQL Server:
ALTER TABLE Vashandi VADZIDZA MAZUVA OKUITA (PositionID) REFERENCES Positions (PositionID)Iwe unogonawo kusika kiyi yekunze kana iwe uchigadzira tafura nekuwedzera chidimbu:
DZIMWE DZOKUDZIDZA ZVINOKUDZIDZISWA Nzvimbo (PositionID)kusvika kumagumo ehurukuro yechinyorwa chekodhi yekodhi.