Boyce-Codd Foromo e tloaelehileng (BCNF) ke eng?

BCNF e fokotsa litšenyehelo tse ngata 'me e eketsa botšepehi ba data

Sepheo sa Foromo ea Boyce-Codd e tloaelehileng (BCNF) ke ho eketsa botšepehi ba data ka ho hlophisa mekhoa le litafole tsa ditshwantsho tse amanang le maemo e le hore ho fihleloe maemo a tloaelehileng a basebetsi. Boemo ba tloaeleho bo etsahala ha ho e-na le likamano pakeng tsa litafole le ha litafole li hlalositse melao ho etsa hore database e fetohe le maemo le ho boloka boitsebiso.

Lipakane tsa ho tloaeleha ha basebeletsi ke ho tlosa ditshwantsho tse fokolang mme ho etsa bonnete ba hore ditshwantsho tsa dintlha li etsahalang.

Dataiso e tloaelehile ha data e le nngwe e sa bolokehe ho feta tafoleng e fetang e le nngwe mme ha data e amana feela e bolokiloe tafoleng.

Tšimoloho ea Foromo ea Boyce-Codd e tloaelehileng

Ho latela letoto la litaelo ho netefatsa hore lits'ebeletso tsa marang-rang li tloaelehile. Melao-motheo ena e bitsoa mefuta e tloaelehileng 'me e baloa ho tloha ho e mong ho ea ho e mehlano. Inthaneteng ea database e hlalosoa e le e tloaelehileng haeba e kopana le mefuta e meraro ea pele: 1NF, 2NF, le 3NF.

BCNF e bōpiloe e le mokhoa oa boraro o tloaelehileng, kapa 3NF, ka 1974 ke Raymond Boyce le Edgar Codd. Banna bana ba ne ba sebetsa ho etsa meralo ea litabeng tsa marang-rang e fokotsang ho fokotsa litšenyehelo ka sepheo sa ho fokotsa nako ea ho qeta nako. Foromo ea boraro e tloaelehileng e tlosa mela e sa itšetleheng ka senotlolo sa motheo ho phaella ho finyella tataiso mefuteng ea pele le ea bobeli e tloaelehileng. BCNF, eo ka linako tse ling e bitsoang 3.5NF, e finyella litlhoko tsohle tsa 3NF mme e hloka hore lits'ebetso tsa likhetho li se ke tsa itšetleha ka litšobotsi tse ling tafoleng.

Nakong ea pōpo ea BCNF, Boyce e ne e le e mong oa basebetsi ba bohlokoa ba Language Structured English Query (SQL), e leng se ileng sa ntlafatsa ts'ebetso ea ho fumana lintlha ka ho sebelisa mohlala oa likamano tsa Codd. Ka mohlala ona, Codd e boletse hore mekhoa e rarahaneng ea li-database e ka fokotseha, e leng ho neng ho bolela hore lipotso li ka ba matla le ho fetoha.

U sebelisa tsebo ea hae ea boitsebiso ba litaba, Codd e hlalosa 1NF, 2NF, le 3NF tataiso. O ile a sebetsa le Boyce ho hlalosa BCNF.

Likhetho tsa Kgethe le BCNF

Ntho ea bohlokoa ka ho khetheha ke mohala kapa motsoako oa lihlopha tafoleng e hlahisang senotlolo sa ikhethang ho database. Sebopeho sa litšobotsi li ka sebelisoa ho khetholla rekoto ea lintlha tsa motheo ntle le ho bua ka litaba tse ling. Taba e 'ngoe le e' ngoe e ka ba le linotlolo tse ngata tsa likhetho, leha e le efe ea eona e ka tšoanelehang e le senotlolo sa mantlha. Tafole e na le senotlolo se le seng sa motheo.

Likheo tsa kgetho li lokela ho ikhetha.

Kamano e teng BCNF haeba ntho e 'ngoe le e' ngoe e khethollang e le senotlolo sa likhetho. Nahana ka tafoleng ea dintlha tsa litaba e bolokang tlhahisoleseding ea basebetsi mme o na le litšobotsi , , le . </p> <p> Ka tafole ena, tšimo <Employee_Id> e khetholla lebitso la pele le la lebitso le lekhetlo la ho qetela. Ka mokhoa o ts'oanang, tuple (<Lebitso la pele la pele>, <Last_name>) le nka <Employee_id>. </p> <table><tbody><tr><td> <strong>Id Employee</strong> </td><td> <strong>Lebitso la pele</strong> </td><td> <strong>Fane</strong> </td><td> <strong>Sehlooho</strong> </td></tr><tr><td> 13133 </td><td> Emily </td><td> Smith </td><td> Mookameli </td></tr><tr><td> 13134 </td><td> Jim </td><td> Smith </td><td> Kopanya </td></tr><tr><td> 13135 </td><td> Emily </td><td> Jones </td><td> Kopanya </td></tr></tbody></table><p><br> Ntho ea bohlokoa bakeng sa <a href="https://st.eyewated.com/lenane-la-common-common-terms/">basebetsi</a> ena ke <Employee_Id> hobane ke eona feela boleng bo ke keng ba sebelisoa ke mola o mong. </p> </div> <div class="amp-related-wrapper"> <h2>Alike posts</h2> <div class="amp-related-content"> <a href="https://st.eyewated.com/litsela-tsa-basebelisi/"> <amp-img src="https://exse.eyewated.com/pict/d45defb5c5c72f58-120x86.jpg" width="120" height="86" layout="responsive" class="amp-related-image"></amp-img> </a> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/litsela-tsa-basebelisi/">Litsela tsa Basebelisi</a></h3> <div class="amp-related-meta"> Software </div> </div> </div> <div class="amp-related-content"> <a href="https://st.eyewated.com/ho-kenya-database-ea-northwind-sample-ho-microsoft-access-2013/"> <amp-img src="https://exse.eyewated.com/pict/1664e767f77136ec-120x86.jpg" width="120" height="86" layout="responsive" class="amp-related-image"></amp-img> </a> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/ho-kenya-database-ea-northwind-sample-ho-microsoft-access-2013/">Ho kenya Database ea Northwind Sample ho Microsoft Access 2013</a></h3> <div class="amp-related-meta"> Software </div> </div> </div> <div class="amp-related-content"> <a href="https://st.eyewated.com/tataiso-e-potlakileng-ea-ho-finyella-ho-fumana-litsebelisoa-2003-lihlahisoa-ho-excel/"> <amp-img src="https://exse.eyewated.com/pict/57f6d8ffc3894b92-120x86.jpg" width="120" height="86" layout="responsive" class="amp-related-image"></amp-img> </a> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/tataiso-e-potlakileng-ea-ho-finyella-ho-fumana-litsebelisoa-2003-lihlahisoa-ho-excel/">Tataiso e Potlakileng ea ho Finyella ho Fumana Litsebelisoa 2003 Lihlahisoa ho Excel</a></h3> <div class="amp-related-meta"> Software </div> </div> </div> <div class="amp-related-content"> <a href="https://st.eyewated.com/ho-theha-sql-server-2008-account-database/"> <amp-img src="https://exse.eyewated.com/pict/f499ab584193372c-120x86.jpg" width="120" height="86" layout="responsive" class="amp-related-image"></amp-img> </a> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/ho-theha-sql-server-2008-account-database/">Ho theha SQL Server 2008 Account Database</a></h3> <div class="amp-related-meta"> Software </div> </div> </div> <div class="amp-related-content"> <a href="https://st.eyewated.com/ho-iketsa-automation-database-administration-le-sql-server-agent/"> <amp-img src="https://exse.eyewated.com/pict/2589f9c8d9ae31a7-120x86.jpg" width="120" height="86" layout="responsive" class="amp-related-image"></amp-img> </a> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/ho-iketsa-automation-database-administration-le-sql-server-agent/">Ho iketsa Automation Database Administration le SQL Server Agent</a></h3> <div class="amp-related-meta"> Software </div> </div> </div> <div class="amp-related-content"> <a href="https://st.eyewated.com/sql-server-ho-amazon-web-services/"> <amp-img src="https://exse.eyewated.com/pict/7646bbd1ca61383c-120x86.jpg" width="120" height="86" layout="responsive" class="amp-related-image"></amp-img> </a> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/sql-server-ho-amazon-web-services/">SQL Server ho Amazon Web Services</a></h3> <div class="amp-related-meta"> Software </div> </div> </div> <div class="amp-related-content"> <a href="https://st.eyewated.com/seo-u-lokelang-ho-se-tseba-ka-melao-ea-null/"> <amp-img src="https://exse.eyewated.com/pict/aedfa031ac682f70-120x86.jpg" width="120" height="86" layout="responsive" class="amp-related-image"></amp-img> </a> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/seo-u-lokelang-ho-se-tseba-ka-melao-ea-null/">Seo U Lokelang ho se Tseba ka Melao ea NULL</a></h3> <div class="amp-related-meta"> Software </div> </div> </div> <div class="amp-related-content"> <a href="https://st.eyewated.com/ithute-ka-li-schemas-le-kamano-ea-tsona-le-boitsebiso/"> <amp-img src="https://exse.eyewated.com/pict/a6691119557c457c-120x86.jpg" width="120" height="86" layout="responsive" class="amp-related-image"></amp-img> </a> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/ithute-ka-li-schemas-le-kamano-ea-tsona-le-boitsebiso/">Ithute ka li-Schemas le Kamano ea tsona le Boitsebiso</a></h3> <div class="amp-related-meta"> Software </div> </div> </div> <div class="amp-related-content"> <a href="https://st.eyewated.com/sepheo-sa-ho-fetoha-se-ka-bibeleng-ke-eng/"> <amp-img src="https://exse.eyewated.com/pict/647291e5510231bc-120x86.jpg" width="120" height="86" layout="responsive" class="amp-related-image"></amp-img> </a> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/sepheo-sa-ho-fetoha-se-ka-bibeleng-ke-eng/">Sepheo sa ho fetoha se ka Bibeleng ke eng</a></h3> <div class="amp-related-meta"> Software </div> </div> </div> </div> <div class="amp-related-wrapper"> <h2>See Newest</h2> <div class="amp-related-content"> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/li-headphones-tse-molemo-ka-ho-fetisisa-tse-ka-tlaase-ho-100-ho-reka-ka-2018/">Li-Headphones tse Molemo ka ho Fetisisa tse ka tlaase ho $ 100 ho Reka ka 2018</a></h3> <div class="amp-related-meta"> Ho reka tataiso </div> </div> </div> <div class="amp-related-content"> <a href="https://st.eyewated.com/tsela-ea-ho-fumana-windows-98-95-kapa-me-product-key-code-ea-hau/"> <amp-img src="https://exse.eyewated.com/pict/59dd1a71cc05381b-120x86.jpg" width="120" height="86" layout="responsive" class="amp-related-image"></amp-img> </a> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/tsela-ea-ho-fumana-windows-98-95-kapa-me-product-key-code-ea-hau/">Tsela ea ho fumana Windows 98, 95, kapa ME Product Key Code ea hau</a></h3> <div class="amp-related-meta"> Windows </div> </div> </div> <div class="amp-related-content"> <a href="https://st.eyewated.com/sebelisa-dropbox-ho-lumellanya-ical-le-older-versions-ea-os-x/"> <amp-img src="https://exse.eyewated.com/pict/1cd144fba1c9327d-120x86.jpg" width="120" height="86" layout="responsive" class="amp-related-image"></amp-img> </a> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/sebelisa-dropbox-ho-lumellanya-ical-le-older-versions-ea-os-x/">Sebelisa Dropbox ho lumellanya iCal le Older Versions ea OS X</a></h3> <div class="amp-related-meta"> Macs </div> </div> </div> <div class="amp-related-content"> <a href="https://st.eyewated.com/tsela-ea-ho-lokisa-liphoso-tsa-43/"> <amp-img src="https://exse.eyewated.com/pict/a8ea76efef9132c8-120x86.png" width="120" height="86" layout="responsive" class="amp-related-image"></amp-img> </a> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/tsela-ea-ho-lokisa-liphoso-tsa-43/">Tsela ea ho lokisa Liphoso tsa 43</a></h3> <div class="amp-related-meta"> Windows </div> </div> </div> <div class="amp-related-content"> <a href="https://st.eyewated.com/mokhoa-oa-ho-sebelisa-samsung-kies/"> <amp-img src="https://exse.eyewated.com/pict/24583b214c5c31b4-120x86.png" width="120" height="86" layout="responsive" class="amp-related-image"></amp-img> </a> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/mokhoa-oa-ho-sebelisa-samsung-kies/">Mokhoa oa ho Sebelisa Samsung Kies</a></h3> <div class="amp-related-meta"> Android </div> </div> </div> <div class="amp-related-content"> <a href="https://st.eyewated.com/mokhoa-oa-ho-qoba-chefo-ea-carbon-monoxide-koloing-ea-hao/"> <amp-img src="https://exse.eyewated.com/pict/17627c01c2623835-120x86.jpg" width="120" height="86" layout="responsive" class="amp-related-image"></amp-img> </a> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/mokhoa-oa-ho-qoba-chefo-ea-carbon-monoxide-koloing-ea-hao/">Mokhoa oa ho Qoba Chefo ea Carbon Monoxide Koloing ea Hao</a></h3> <div class="amp-related-meta"> Car Tech </div> </div> </div> </div> <div class="amp-related-wrapper"> <h2>Sapid posts</h2> <div class="amp-related-content"> <a href="https://st.eyewated.com/mokhoa-oa-ho-tsosolosa-li-setting-tsa-firefox-ho-litekanyetso-tsa-bona-tse-sa-tsitsitseng/"> <amp-img src="https://exse.eyewated.com/pict/0f2d25a459e840b5-120x86.png" width="120" height="86" layout="responsive" class="amp-related-image"></amp-img> </a> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/mokhoa-oa-ho-tsosolosa-li-setting-tsa-firefox-ho-litekanyetso-tsa-bona-tse-sa-tsitsitseng/">Mokhoa oa ho tsosolosa li-setting tsa Firefox ho Litekanyetso tsa bona tse sa tsitsitseng</a></h3> <div class="amp-related-meta"> Bapalami ba </div> </div> </div> <div class="amp-related-content"> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/tsela-ea-ho-fumana-litsebiso-tse-ncha-tsa-mail-ho-desktop-bakeng-sa-gmail/">Tsela ea ho fumana Litsebiso tse Ncha tsa Mail ho Desktop bakeng sa Gmail</a></h3> <div class="amp-related-meta"> Imeile & Melaetsa </div> </div> </div> <div class="amp-related-content"> <a href="https://st.eyewated.com/tamper-data-add-on-firefox/"> <amp-img src="https://exse.eyewated.com/pict/d25c642c10fe3047-120x86.jpg" width="120" height="86" layout="responsive" class="amp-related-image"></amp-img> </a> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/tamper-data-add-on-firefox/">Tamper Data: Add-on Firefox</a></h3> <div class="amp-related-meta"> Websaete le Patlisiso </div> </div> </div> <div class="amp-related-content"> <a href="https://st.eyewated.com/ithute-linux-command-gawk/"> <amp-img src="https://exse.eyewated.com/pict/5154748e42ae3427-120x86.jpg" width="120" height="86" layout="responsive" class="amp-related-image"></amp-img> </a> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/ithute-linux-command-gawk/">Ithute Linux Command - gawk</a></h3> <div class="amp-related-meta"> Linux </div> </div> </div> <div class="amp-related-content"> <a href="https://st.eyewated.com/mokhoa-oa-ho-lokisa-tlhahlobo-ea-dll-e-bakoang-ke-bothata-ba-hardware/"> <amp-img src="https://exse.eyewated.com/pict/3325d17dbf433dcd-120x86.jpg" width="120" height="86" layout="responsive" class="amp-related-image"></amp-img> </a> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/mokhoa-oa-ho-lokisa-tlhahlobo-ea-dll-e-bakoang-ke-bothata-ba-hardware/">Mokhoa oa ho lokisa Tlhahlobo ea DLL e bakoang ke Bothata ba Hardware</a></h3> <div class="amp-related-meta"> Windows </div> </div> </div> <div class="amp-related-content"> <a href="https://st.eyewated.com/google-spreadsheets-rand-mosebetsi-hlahisa-numere-e-ncha/"> <amp-img src="https://exse.eyewated.com/pict/97704213b8e03b41-120x86.jpg" width="120" height="86" layout="responsive" class="amp-related-image"></amp-img> </a> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/google-spreadsheets-rand-mosebetsi-hlahisa-numere-e-ncha/">Google Spreadsheets 'RAND Mosebetsi: Hlahisa Numere e Ncha</a></h3> <div class="amp-related-meta"> Software </div> </div> </div> <div class="amp-related-content"> <a href="https://st.eyewated.com/sesebelisoa-sa-mino-oa-music-player/"> <amp-img src="https://exse.eyewated.com/pict/5132e6be52cf3c91-120x86.jpg" width="120" height="86" layout="responsive" class="amp-related-image"></amp-img> </a> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/sesebelisoa-sa-mino-oa-music-player/">Sesebelisoa sa 'Mino oa Music Player</a></h3> <div class="amp-related-meta"> Software & Apps </div> </div> </div> <div class="amp-related-content"> <a href="https://st.eyewated.com/facebook-messenger-bakeng-sa-iphone-le-android/"> <amp-img src="https://exse.eyewated.com/pict/9cd0d1e2ceab341e-120x86.jpg" width="120" height="86" layout="responsive" class="amp-related-image"></amp-img> </a> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/facebook-messenger-bakeng-sa-iphone-le-android/">Facebook Messenger bakeng sa iPhone le Android</a></h3> <div class="amp-related-meta"> Imeile & Melaetsa </div> </div> </div> <div class="amp-related-content"> <a href="https://st.eyewated.com/lethathamo-le-feletseng-la-lipapali-tsa-xbox-360-u-ka-li-bapala-xbox-one/"> <amp-img src="https://exse.eyewated.com/pict/e4dc52c7c6b2316b-120x86.jpg" width="120" height="86" layout="responsive" class="amp-related-image"></amp-img> </a> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/lethathamo-le-feletseng-la-lipapali-tsa-xbox-360-u-ka-li-bapala-xbox-one/">Lethathamo le feletseng la lipapali tsa Xbox 360 U ka li bapala Xbox One</a></h3> <div class="amp-related-meta"> Ho bapala </div> </div> </div> <div class="amp-related-content"> <a href="https://st.eyewated.com/tlhahiso-ea-matsoho-le-mekhoa-ea-matla-karolo-ea-1/"> <amp-img src="https://exse.eyewated.com/pict/ab4743f50d5d32e8-120x86.jpg" width="120" height="86" layout="responsive" class="amp-related-image"></amp-img> </a> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/tlhahiso-ea-matsoho-le-mekhoa-ea-matla-karolo-ea-1/">Tlhahiso ea Matsoho le Mekhoa ea Matla Karolo ea 1</a></h3> <div class="amp-related-meta"> Ho bapala </div> </div> </div> <div class="amp-related-content"> <a href="https://st.eyewated.com/likhamera-tsa-hd-video-action-ka-gps/"> <amp-img src="https://exse.eyewated.com/pict/60281bf1470536af-120x86.jpg" width="120" height="86" layout="responsive" class="amp-related-image"></amp-img> </a> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/likhamera-tsa-hd-video-action-ka-gps/">Lik'hamera tsa HD Video Action Ka GPS</a></h3> <div class="amp-related-meta"> Ho reka tataiso </div> </div> </div> <div class="amp-related-content"> <a href="https://st.eyewated.com/lebelofatsa-windows-7-le-readyboost/"> <amp-img src="https://exse.eyewated.com/pict/9c6db2767af02fbe-120x86.png" width="120" height="86" layout="responsive" class="amp-related-image"></amp-img> </a> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/lebelofatsa-windows-7-le-readyboost/">Lebelofatsa Windows 7 le ReadyBoost</a></h3> <div class="amp-related-meta"> Windows </div> </div> </div> <div class="amp-related-content"> <a href="https://st.eyewated.com/kamoo-u-ka-qalang-kateng-ka-mobile-game-programming/"> <amp-img src="https://exse.eyewated.com/pict/999115b3c6b632ba-120x86.jpg" width="120" height="86" layout="responsive" class="amp-related-image"></amp-img> </a> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/kamoo-u-ka-qalang-kateng-ka-mobile-game-programming/">Kamoo U ka Qalang Kateng ka Mobile Game Programming</a></h3> <div class="amp-related-meta"> Websaete le Patlisiso </div> </div> </div> <div class="amp-related-content"> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/the-last-ims-ea-casey-anthony/">The Last IMs ea Casey Anthony</a></h3> <div class="amp-related-meta"> Imeile & Melaetsa </div> </div> </div> <div class="amp-related-content"> <a href="https://st.eyewated.com/psp-e-phahameng-ea-lipapali-tsa-bana/"> <amp-img src="https://exse.eyewated.com/pict/c08cae320a903299-120x86.jpg" width="120" height="86" layout="responsive" class="amp-related-image"></amp-img> </a> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/psp-e-phahameng-ea-lipapali-tsa-bana/">PSP e phahameng ea Lipapali tsa Bana</a></h3> <div class="amp-related-meta"> Ho reka tataiso </div> </div> </div> <div class="amp-related-content"> <div class="amp-related-text"> <h3><a href="https://st.eyewated.com/lisebelisoa-tse-9-tse-molemohali-tsa-ho-reka-ka-2018/">Lisebelisoa tse 9 tse Molemohali tsa ho Reka ka 2018</a></h3> <div class="amp-related-meta"> Ho reka tataiso </div> </div> </div> </div></article> <footer class="amp-wp-footer"> <div class="amp-wp-footer-inner"> <a href="#" class="back-to-top">Back to top</a> <p class="copyright"> © 2024 st.eyewated.com </p> <div class="amp-wp-social-footer"> <a href="#" class="jeg_facebook"><i class="fa fa-facebook"></i> </a><a href="#" class="jeg_twitter"><i class="fa fa-twitter"></i> </a><a href="#" class="jeg_google-plus"><i class="fa fa-google-plus"></i> </a><a href="#" class="jeg_pinterest"><i class="fa fa-pinterest"></i> </a><a href="" class="jeg_rss"><i class="fa fa-rss"></i> </a> </div> </div> </footer> <div id="statcounter"> <amp-pixel src="https://c.statcounter.com/12022999/0/02d06b5d/1/"> </amp-pixel> </div> </body> </html> <!-- Dynamic page generated in 1.511 seconds. --> <!-- Cached page generated by WP-Super-Cache on 2019-10-04 00:08:55 --> <!-- 0.001 -->