Enye yeembono ezibalulekileyo kwiinkcukacha zolwazi kudala ubudlelwane phakathi kwetafile zeenkcukacha. Olu lwalamano lunikeza indlela yokudibanisa idatha egciniwe kwiibhile ezininzi kunye nokuyifumana ngendlela efanelekileyo. Ukuze wenze ikhonkco phakathi kwetafile ezimbini, kufuneka ucacise ukhiye wangaphandle kwelinye itafile ebonisa ikholam kwenye ietafile.
Iidatha zeDatabase kunye noBudlelwane
Usenokuba sele uyayazi ukuba iinkcukacha zolwazi nje ziluhlu lwamatafula , afana noko ungasisebenzisa kakade kwiprogram ye- spreadsheet , njenge-Microsoft Excel. Enyanisweni, unako ukuguqula i-Excel spreadsheet kwisiseko sedatha. Apho i-database yolwazi idibanisa kwi-spreadsheets, nangona kunjalo, xa kufikelele ekwakheni ubudlelwane obunamandla phakathi kweetafile.
Cinga, umzekelo, isiseko sedatha esetyenziswa yinkampani ukulandelela ulwazi lwabasebenzi. Le nkcukacha ingaba netafile ebizwa ngokuba ngabasebenzi abaqulethe ulwazi olulandelayo kwilungu ngalinye labasebenzi bekampani:
- I-ID yomqeshwa
- Igama lokuqala
- Ifani
- OfficePhone
- Ikhaya lasekhaya
- PositionID
Kulo mzekelo, i-ID yomqeshwa yinani eliyingqayizivele elinikezelwa kumqeshwa ngamnye xa zongezwa kwiziko ledatha. I-ID yesithuba yikhowudi yomsebenzi esetyenziselwa ukubhekisa isikhundla somqeshwa kwinkampani. Kule cwangciso, umqeshwa unokufumana isikhundla esinye kuphela, kodwa abasebenzi abaninzi (okanye akukho) bangazalisa isikhundla ngasinye. Ngokomzekelo, unokuba nekhulu labasebenzi abanesikhundla "seCashier".
Idatha ingaba nayo itafile ebizwa ngokuba yiSithuba kunye nolwazi olongezelelweyo olulandelayo malunga nesimo ngasinye:
- PositionID
- Isihloko
- JobLevel
- SkillCategory
- Indawo
Inkalo ye-ID ye-ID kule tafile ifana nesambulo se-ID yomqeshwa kwitafile zabasebenzi-yinto eninzi eyakhiweyo xa kuphakanyiswa isikhundla kwisiseko sedatha.
Xa siya kutsala uluhlu lwabaqeshwa kwiziko ledatha, kuya kuba yindalo ukucela igama lomntu ngamnye kunye nesihloko sakhe. Nangona kunjalo, olu lwazi lugcinwe kwiitheyibhile ezininzi zeenkcukacha, ngoko luyakuthi lufunyenwe kuphela ngokusebenzisa umbuzo ojongene nokufuna ubuhlobo obukhoyo phakathi kweetafile.
Xa ukhangela isakhiwo setafile, intsimi echaza ulwalamano mhlawumbi iyacaca - indawo ye-ID ye-ID. Umqeshwa ngamnye unokufumana isikhundla esisodwa kwaye eso sikhundla sichazwa ngokufaka i-ID ye-ID kwi-Table of Poss entry entry. Ukongezelela ekubeni yinto ephambili yetafile yeZithuba, kulo mzekelo, insimba ye-ID ye-ID kwakhona yikhiye wangaphandle ukusuka kwitafile zabasebenzi kwitafile zemiSebenzi. I-database ingasebenzisa le ntsimi ukulungelelanisa ulwazi oluvela kwiitheyibhile ezininzi kwaye uqinisekise ukuba nayiphi iinguqulelo okanye izongezo kwiziko leenkcukacha ziqhubeka nokunyanzelisa intembeko .
Emva kokuba ufumene ikhiye yangaphandle, unokuqhubeka kwaye udonse ulwazi olufunayo kwiziko ledatha usebenzisa umbuzo olandelayo:
Ukudala ii-Keys zangaphandle kwi-SQL Server
Ngokwenene, akudingeki ukuba uchaze ulwalamano olucacileyo ukuba lukwazi ukwenza imibuzo njengolu ngasentla. Nangona kunjalo, ukuba uyichaza ngokucacileyo ubudlelwane usebenzisa isithintelo sokhuseleko lwangaphandle, i-database izakukwazi ukwenza umsebenzi othile wokugcina indlu:
- Xa ukongeza irekhodi elitsha kwitafile zabasebenzi, isiseko sedata siya kuqinisekisa ukuba i-ID ye-ID oyifakeyo iyona nto ibalulekileyo yecandelo leZithuba.
- Ukuba utshintshela i-ID ye-ID kwitafile zeZithuba, i-database ingenza izibuyekezo ezifunekayo kwitafile zabasebenzi ukugcina ukuvumelana.
- Isiseko sikwazi ukukhusela malunga nefuthe lokususwa kwesimo esivela kwitheyibhile yesikhundla ngokungavumi ukususa isikhundla kunye nokungena kwabasebenzi abahambelanayo okanye ukwenza i-cascading ukususa kwabo bonke abasebenzi abadibeneyo.
Nantsi indlela oza kudala ngayo ikhiye yangaphandle kwi SQL Server:
I-ALTER ITHEBULI BABASEBENZI BENZA ISIQOQO ESIKHULULEKILEYO (PositionID) UKUBHALWA KWEZINTO (I-PositionID)Ungenza kwakhona ukhiye wangaphandle xa udala itafile ngokufaka icandelwana:
IZIFUNDO EZIFUNDILEYO EZIKHONKILEYO Izithuba (PositionID)ekupheleni kwenkcazo yekholomu yekholomu yangaphandle yekholomu.