Ukubeka i-Database kwiFomu yesiBini yesiQhelo
Kule nyanga edlulileyo, sijonge imiba emininzi yokuqhelanisa itafile yedatha. Okokuqala, sixoxe ngemigaqo eyisiseko yolwazi oluqhelekileyo. Ngexesha lokugqibela, sihlolisise iimfuno ezisisiseko ezibekwe kwifom yokuqala eqhelekileyo (1NF). Ngoku, masiqhubeke nohambo lwethu kwaye sihlanganise imigaqo yesibini ifom yesiqhelo (2NF).
Khumbula iimfuneko eziqhelekileyo ze-2NF:
- Susa iifomfayile zedatha ezisebenzayo kwimigca emininzi yetafile uze uzibeke kwietafile ezihlukeneyo.
- Yakha ubudlelwane phakathi kwezi tafile ezitsha kunye nabaphambili babo ngokusebenzisa ukusetyenziswa kwamanye amazwe.
Le mithetho ingashwankathelwa kwisitatimende esilula: 2NF izama ukunciphisa inani leemali ezidlulileyo kwitafile ngokukukhupha, ukubeka kwitafile ezitsha kunye nokudala ubudlelwane phakathi kwezi tafile.
Makhe sibone umzekelo. Khawucinge ngevenkile ye-intanethi egcina ulwazi lomthengi kwiziko ledatha. Basenokuba netafile enye ebizwa ngokuba ngabathengi ngala macandelo alandelayo:
- CustNum
- Igama lokuqala
- Ifani
- Idilesi
- Sixeko
- Lumente
- ZIP
Ukujonga okufutshane kule tafile kubonisa inani elincinane leedatha. Sigcina "i-Sea Cliff, NY 11579" kunye ne "Miami, FL 33157" ngokufakwa kabini ngalunye. Ngoku, oko kungabonakali njengendawo yokugcina esongeziweyo kumzekelo wethu olula, kodwa cinga indawo echithekileyo ukuba sinemigca yemiqolo etafileni lethu. Ukongezelela, ukuba ikhowudi ye-ZIP ye-Sea Cliff yayiza kutshintsha, kufuneka senze utshintsho kwiindawo ezininzi kulo lonke ulwazi.
Kwi-2NF-ehambisanayo nesiseko sedatha, le nkcazelo ebomvu ikhutshwe kwaye igcinwe kwitheyibhile eyahlukileyo. Itheyibhile yethu entsha (masiyibize i-ZIPs) inokuba neenkalo ezilandelayo:
- ZIP
- Sixeko
- Lumente
Ukuba sifuna ukuba ngempumelelo kakhulu, sinokuzalisa le tafile kwangaphambili - iofisi yepostile inikeza ulawulo lwemikhosi esebenzayo ye-ZIP kunye nobudlelwane babo besixeko / urhulumente. Ngokuqinisekileyo, uhlangabezane neemeko apho lolu hlobo lwedatha lusetyenziswa khona. Omnye uthatha umyalelo unokukucela kuwe ikhowudi yakho ye-ZIP kuqala kwaye wayazi isixeko kwaye uchaza ukuba ubiza ntoni. Olu hlobo lolungiselelo luyanciphisa iphutha lomqhubi kwaye lwandise ukusebenza kakuhle.
Ngoku ukuba sisusile idatha yokuphindaphinda kwitheyibhile yabaThengi, sinelisekile umgaqo wokuqala wesimo sesiqhelo sesibini. Sisafuneka sisebenzise ikhiye yangaphandle ukuze tibophe iileta ezimbini. Siza kusebenzisa ikhowudi ye - ZIP (isisiseko esiyintloko kwitafile ye-ZIPs) ukudala olo dlelwane. Nasi ithenda lethu elitsha labaThengi:
- CustNum
- Igama lokuqala
- Ifani
- Idilesi
- ZIP
Ngoku siye sanciphisa inani leenkcukacha ezigcinwe kwiziko ledatha kwaye isakhiwo sethu sisesibini sesiqhelo sesiqhelo!
Ukuba ungathanda ukuqinisekisa ukuba i-database yakho iyaqhelekanga, hlolisisa amanye amanqaku kulolu chungechunge:
- I-Basic Standards Basics
- Ukubeka i-Databases yakho kwifom yeSiqhelo sokuQala
- Ukubeka i-Database yakho kwifomu yesiBini yesiQhelo
- Ukubeka i-Database yakho kwifomu yesithathu eqhelekileyo