Ubuqotho bokukhomba buyisici sedatha yezinhlelo zohlelo lokuphatha database. Iqinisekisa ukuthi ubudlelwano obuphakathi kwamatafula ku-database buhlala bunembile ngokusebenzisa izithiyo zokuvimbela abasebenzisi noma izinhlelo zokusebenza ukungena kwedatha engalungile noma ukukhomba idatha engekho.
Amasu asetshenziswa amatafula ukuhlela ulwazi abaqukethe. Zifana namaspredishithi, afana ne-Excel, kodwa afaneleke kakhulu kubasebenzisi abaphambili. Imisebenzi yolwazi ngokusetshenziswa kwezihluthulelo eziyisisekelo nezikhiphe zangaphandle, ezigcina ubuhlobo phakathi kwamatafula.
Ukhiye oyinhloko
Isihluthulelo esiyinhloko setafula lemininingwane yedatha yisihlonzi esiyingqayizivele esinikezwe irekhodi ngalinye. Ithebula ngalinye lizoba nekholomu eyodwa noma ngaphezulu ekhethiwe njengesihluthulelo esiyinhloko. Inombolo yezokuphepha yomphakathi ingaba ukhiye oyinhloko wohlu lwamagama abasebenzi ngoba inombolo ngayinye yokuphepha yomphakathi ihlukile.
Kodwa-ke, ngenxa yokukhathazeka kwangasese, inombolo ye-ID yenkampani eyabelwe yikhetho elingcono lokusebenza njengekhikhi eyinhloko yabasebenzi. Isofthiwe ethile ye-database - njenge-Microsoft Access - inikeza ukhiye oyinhloko ngokuzenzakalelayo, kodwa ukhiye okungahleliwe awunayo incazelo yangempela. Kungcono ukusebenzisa ukhiye ngencazelo erekhodi. Indlela elula yokuphoqelela ubuqotho bokuthi akuvumelekile ukuvumela izinguquko ekhiye oyinhloko.
Ukhiye wangaphandle
Isihluthulelo sangaphandle yisihlonzi etafuleni efana nesikhiye esiyinhloko setafula elihlukile. Isihluthulelo sangaphandle sakha ubudlelwane netafula elihlukile, futhi ubuqotho bokubhekisela bubhekisela ebuhlotsheni phakathi kwalezi zibhebhe.
Lapho ithebula elilodwa linesihluthulelo sangaphandle kwelinye itafula, umqondo wokuthembeka okuchazayo uthi ungangeze irekhodi etafuleni equkethe ukhiye wangaphandle ngaphandle uma kukhona irekhodi elihambelanayo etafuleni elixhunyiwe. Ihlanganisa namasu awaziwa njenge-cascading update kanye ne-cascading delete, okuqinisekisa ukuthi izinguquko ezenziwe etafuleni elixhunyiwe ziboniswa etafuleni eliyinhloko.
Isibonelo soMthetho Wokuthembeka Wokubheka
Cabanga ngesimo lapho unamatafula amabili: Abasebenzi nabaphathi. Ithebula labaSebenzi linemikhakha eyinhloko yangaphandle ephethe i-ManagedBy, ekhomba irekhodi lomphathi wesisebenzi ngasinye kuthebula labaphathi. Ukuthembeka okufanako kulandela imithetho emithathu elandelako:
- Awukwazi ukwengeza irekhodi kuthebula labasebenzi ngaphandle kokuthi umlingiswa ophethweyo ukhomba irekhodi elivumelekile kuthebula labaphathi. Ubuqotho obuseduze buvimbela imininingwane yokungalungile etafuleni. Noma yikuphi ukusebenza okungagculisi ukubaluleka kokubusa kombuso okuhlulekayo kwehluleka.
- Uma ukhiye oyinhloko werekhodi kwiThebula labaphathi ushintsho, wonke amarekhodi ahambelanayo etafuleni labasebenzi aguqulwa ngokusebenzisa isibuyekezo se-cascading.
- Uma irekhodi etafuleni labaphathi lisusiwe, wonke amarekhodi ahambelanayo etafuleni labasebenzi ayasuswa besebenzisa ukususwa kwe-cascading.
Izinzuzo Zokuvimbela Ukuthembeka Okubhekiselweyo
Ukusebenzisa isistimu yokuphathwa kwedatha yokuxhumana ehambisana nobuqotho bokukhomba inikeza izinzuzo eziningana:
- Ivimbela ukungena kwedatha eyimpinda.
- Ivimbela ithebula elilodwa ekuboniseni insimu engekhona kwelinye itafula.
- Ukuvumelana okuqinisekisiwe phakathi kwamatafula "ahlukanisiwe".
- Ivimbela ukususwa kwerekhodi equkethe inani elibhekiswe khiye wangaphandle kwelinye itafula.
- Ivimbela ukwengezwa kwerekhodi etafuleni equkethe ukhiye wangaphandle ngaphandle kokuthi kukhona ukhiye oyinhloko kuthebula elixhunyiwe.