Ukubeka i-Database kwifomu yesibili ejwayelekile
Phakathi nenyanga edlule, sibheke izici eziningana zokuvamisa ithebula lesisekelo sedatha. Okokuqala, sixoxisane ngemigomo eyisisekelo yokumiswa kwe-database. Ngesikhathi sokugcina, sihlolisise izidingo eziyisisekelo ezibekwe ifomu elivamile elivamile (1NF). Manje, masiqhubeke nohambo lwethu futhi sihlanganise imigomo yesimo sesibili evamile (2NF).
Khumbula izidingo jikelele ze-2NF:
- Susa ama-subset yedatha asebenza kumigqa eminingi etafuleni bese uwabeka ematafuleni ahlukene.
- Dala ubudlelwane phakathi kwalawa macwecwe amasha kanye nabandulela kwabo ngokusebenzisa ukusetshenziswa okhiye bangaphandle.
Le mithetho ingafingqwa ngesitatimende esilula: i-2NF izama ukunciphisa inani lemininingwane etafuleni ngokulikhiphela, liyibeke kuthebula elisha bese lidala ubuhlobo phakathi kwalawo amatafula.
Ake sibone isibonelo. Cabanga ngesitolo se-intanethi esilondoloza imininingwane yamakhasimende ku-database. Bangase babe netafula elilodwa elibizwa ngokuthi Amakhasimende ngezici ezilandelayo:
- I-CustNum
- Igama
- Isibongo
- Ikheli
- Idolobha
- Isimo
- I-ZIP
Ukubukeka okuncane kuleli tafula kubonisa inani elincane lemininingwane evulekile. Sigcina "i-Sea Cliff, NY 11579" kanye nokufakwa "oku-Miami, FL 33157" kabili ngalunye. Manje, lokhu kungase kungabonakali njengesitoreji esingeziwe kakhulu esilinganisweni sethu esilula, kodwa cabanga ukuthi isikhala esasilahlekile uma sinezinkulungwane zemigqa etafuleni lethu. Ukwengeza, uma ikhodi ye-ZIP ye-Sea Cliff izoshintsha, kuzodingeka senze ushintsho ezindaweni eziningi kulo lonke ulwazi.
Esikhathini sesakhiwo se-database se-2NF esivumelanisiwe, lolu lwazi oluvulekile lukhishwa bese lugcinwe etafuleni elihlukile. Itafula lethu elisha (asibize nge-ZIPs) lingase libe nezinkambu ezilandelayo:
- I-ZIP
- Idolobha
- Isimo
Uma sifuna ukwenza kahle, singakwazi ngisho nokugcwalisa leli tafula kusengaphambili - iposi leposi lihlinzeka ngerekhodi yazo zonke izikhombisi ze-ZIP ezisebenzayo kanye nobuhlobo babo bomuzi / wesifunda. Ngokuqinisekile, uhlangabezane nesimo lapho lolu hlobo lwe-database lusetshenziswa khona. Othile othatha i-oda kungenzeka ukuthi akucele ukuthi uthole ikhodi yakho ye-ZIP kuqala bese uyazi umuzi futhi usho ukuthi ubiza kuphi. Lolu hlobo lwelungiselelo luyanciphisa iphutha lomsebenzisi futhi lwandise ukusebenza kahle.
Manje njengoba sisususe idatha yokuphinda etafuleni lamakhasimende, sesinelisekile umthetho wokuqala wefomu lesibili evamile. Sisadingeka ukusebenzisa ukhiye wangaphandle ukubopha amathebula amabili ndawonye. Sizosebenzisa ikhodi ye - ZIP (ukhiye oyinhloko kusuka kuthebula le-ZIPs) ukudala lobo buhlobo. Nasi ithebula lethu lamakhasimende elisha:
- I-CustNum
- Igama
- Isibongo
- Ikheli
- I-ZIP
Manje sesinciphise inani lemininingwane egciniwe elondolozwe ku-database futhi isakhiwo sethu sisesimweni sesibili esivamile!
Uma ungathanda ukuqinisekisa ukuthi i-database yakho ijwayelekile, hlola ezinye izihloko zethu kulolu chungechunge:
- I-Database Normalization Basics
- Ukubeka i-Database yakho kuFomu LokuQala Oluvamile
- Ukubeka i-Database yakho kwifomu yesibili evamile
- Ukubeka i-Database yakho kufomu lesithathu elijwayelekile