Ubuhlobo obuningi kuya phezulu ku-database buba khona uma irekhodi ngalinye kuThebula A lingase libe namarekhodi amaningi axhunyiwe kuThebula B, kodwa irekhodi ngalinye kuThebula B lingase libe nerekhodi elilodwa elihambelana neThebula A. Ubuhlobo obuningi kuya phezulu i-database iyinhlangano ejwayelekile kakhulu yokudatshulwa kwedatha futhi ikhona enhliziyweni yokuklama okuhle.
Cabanga ngobuhlobo phakathi kothisha kanye nezifundo abazifundisayo. Uthisha angafundisa izifundo eziningi, kodwa inkambo ngeke ibe nobuhlobo obufanayo nothisha.
Ngakho-ke, uma irekhodi ngalinye etafuleni labafundisi, kungaba khona amarekhodi amaningi etafuleni lezinkundla. Lokhu ubuhlobo obuningi kuya phezulu: uthisha oyedwa kuya izifundo eziningi.
Kungani Ukwakha Ubudlelwane Obuningi Kakhulu Kubalulekile
Ukumelela ubuhlobo obuningi kuya kokuningi, udinga okungenani amatafula amabili. Ake sibone ukuthi kungani.
Mhlawumbe sakha itafula labafundisi lapho sifuna ukubhala igama kanye nezifundo ezifundiswayo. Singayilahlela kanje:
Teacher_ID | Teacher_Name | Inkambo |
---|---|---|
Teacher_001 | UCarmen | Biology |
Teacher_002 | I-Veronica | Izibalo |
Teacher_003 | Jorge | IsiNgisi |
Kuthiwani uma uCarmen efundisa izifundo ezimbili noma ngaphezulu? Sinezinketho ezimbili nale design. Singawufaka nje kurekhodi elikhona likaCarmen, kanje:
Teacher_ID | Teacher__Name | Inkambo |
---|---|---|
Teacher_001 | UCarmen | Biology, Math |
Teacher_002 | I-Veronica | Izibalo |
Teacher_003 | Jorge | IsiNgisi |
Idizayini engenhla, noma kunjalo, i-inflexible futhi ingabangela izinkinga kamuva uma uzama ukufaka, ukuhlela noma ukususa idatha.
Kwenza kube nzima ukucinga idatha. Lo mklamo wephula isimiso sokuqala se-database ejwayelekile, ifomu lokuqala elijwayelekile (1NF) , elichaza ukuthi iseli ngalinye letafula kufanele libe neyodwa yedatha ehlukanisiwe yedatha.
Enye indlela yokwakha kungase kube ukwengeza irekhodi lesibili likaCarmen:
Teacher _ID | Teacher__Name | Inkambo |
---|---|---|
Teacher_001 | UCarmen | Biology |
Teacher_001 | UCarmen | Izibalo |
Teacher_002 | I-Veronica | Izibalo |
Teacher_003 | Jorge | IsiNgisi |
Lokhu kunamathele ku-1NF kodwa kusalokhu kungalungile ukuklama i-database ngoba kufaka ukubuyiswa kwe-redundancy futhi kungavimba i-database enkulu kakhulu ngokungadingekile. Okubaluleke nakakhulu, idatha ingahle ingahambisani. Ngokwesibonelo, kuthiwani uma igama likaCarmen lishintsha? Omunye osebenza nedatha angase avuselele igama lakhe kurekhodi elilodwa futhi ahluleke ukulibuyekeza kumrekhodi wesibili. Lo mklamo wephula ifomu lesibili elijwayelekile (2NF), elihambisana ne-1NF futhi kumele ligweme nokuhlukunyezwa kwamarekhodi amaningi ngokuhlukanisa ama-subsets yedatha ematafuleni amaningi nokudala ubuhlobo phakathi kwabo.
Indlela Yokwakha I-Database Yezobudlelwane Obunye Nobuningi
Ukuze sisebenzise ubuhlobo obuningi kuya kokuningi etafuleni labafundisi nabaqeqeshi, siphula amatafula amabili bese siwaxhumanisa usebenzisa ikhi langaphandle .
Lapha, sisuse ikholomu ye-Course kuThebula labafundisi:
Teacher _ID | Teacher__Name |
---|---|
Teacher_001 | UCarmen |
Teacher_002 | I-Veronica |
Teacher_003 | Jorge |
Futhi nansi itafula lezinkundla. Qaphela ukuthi ukhiye wayo wangaphandle, Teacher_ID, uxhumanisa inkambo kumfundisi otafuleni labafundisi:
I-Course_ID | I-Course_Name | Teacher_ID |
---|---|---|
I-Course_001 | Biology | Teacher_001 |
I-Course_002 | Izibalo | Teacher_001 |
I-Course_003 | IsiNgisi | Teacher_003 |
Sithuthukise ubudlelwane phakathi kwalabafundisi kanye netafula lezinkundla usebenzisa ukhiye wangaphandle.
Lokhu kusitshela ukuthi kokubili i-Biology ne-Math ifundiswa nguCarmen nokuthi uJorge ufundisa isiNgisi.
Singabona ukuthi lo mklamo ugwema noma yikuphi ukubuyiswa okukhona, kuvumela othisha ngabanye ukuba bafundise izifundo eziningi, futhi basebenzise ubuhlobo obuningi kuya phezulu.
I-database ingabuye isebenzise ubudlelwane obunye nomunye kanye nobuhlobo obuningi nobuningi.