Ulwalamano olulodwa ukuya kwi-database lwenzeka xa irekhodi ngalinye kwiTable ye-A linakho amaxwebhu amaninzi adibeneyo kwiTable B, kodwa irekhodi ngalinye kwiTable B linakho irekhodi elilodwa elihambelana neTable A. Ubuhlobo obuninzi ukuya kubaninzi i-database yinto eqhelekileyo yoqulunqo lweenkcukacha zesiseko kunye neyona ntliziyo.
Cinga ubuhlobo phakathi kootitshala kunye nezifundo abazifundisayo. Utitshala angafundisa izifundo ezininzi, kodwa ikhosi ayiyi kuba nolwalamano olufanayo kunye notitshala.
Ngoko ke, kwirekhodi nganye kwitafile yaTitshala, kukho iirekodi ezininzi kwitafile zekhosi. Ulwalamano olulodwa ukuya kwamaninzi: utitshala omnye ukuya kwizifundo ezininzi.
Kutheni ukuseka ubudlelwane obuninzi kubaluleke kakhulu
Ukumela ubuhlobo obuninzi ukuya kubaninzi, kufuneka ubuncinane ubuncinci beetafile. Makhe sibone ukuba kutheni.
Mhlawumbi sakha itafile yaTitshala apho sifuna ukurekhoda igama kunye nezifundo ezifundiswayo. Singayilwa ngolu hlobo:
Teacher_ID | Teacher_Name | Ikhosi |
---|---|---|
Teacher_001 | UCarmen | Biology |
Teacher_002 | IVeronica | IMathematika |
Teacher_003 | Jorge | IsiNgesi |
Kuthekani ukuba uCarmen ufundise izifundo ezimbini okanye ngaphezulu? Sineenketho ezimbini ngelo lwakhiwo. Singayifaka kwiRekhodi yaseCarmen ekhoyo, njengale:
Teacher_ID | Umfundisi _Name | Ikhosi |
---|---|---|
Teacher_001 | UCarmen | Biology, Math |
Teacher_002 | IVeronica | IMathematika |
Teacher_003 | Jorge | IsiNgesi |
Uyilo olungentla, nangona kunjalo, luyi-inflexible kwaye lunokubangela iingxaki kamva xa uzama ukufaka, ukuhlela okanye ukususa idatha.
Yenza kube nzima ukukhangela idatha. Olu qulunqo lugqithisa umgaqo wokuqala wokuqulatha i-database, Ifom yokuqala yesiQinisekiso (1NF) , echaza ukuba iseli nganye yetafile kufuneka libe neqhosha elilodwa elichanekileyo lwedatha.
Enye enye indlela yokuyila isenokuba yongeza nje irekhodi yesibini yeKarmen:
Mfundisi _ID | Umfundisi _Name | Ikhosi |
---|---|---|
Teacher_001 | UCarmen | Biology |
Teacher_001 | UCarmen | IMathematika |
Teacher_002 | IVeronica | IMathematika |
Teacher_003 | Jorge | IsiNgesi |
Oku kubambelela kwi-1NF kodwa kusekho ukulungiswa kwedatha engalunganga kuba ibonisa ukulungelelanisa kwaye iyakwazi ukucima i-database enkulu kakhulu. Okubaluleke ngakumbi, idatha ingahambelani. Ngokomzekelo, kuthekani ukuba igama likaCarmen litshintshile? Omnye osebenza kunye nedatha angayihlaziya igama lakhe kwirekhodi enye kwaye ahluleke ukuyihlaziya kwirekhodi yesibini. Olu qulunqo luphula ifomu lesiBini eliqhelekileyo (2NF), elihambelanayo ne-1NF kwaye kufuneka liphephe ukuhlengahlengwa kwamarekhodi amaninzi ngokuhlula iissetyenzisi zeedatha kwiibhile ezininzi kunye nokudala ubudlelwane phakathi kwabo.
Indlela yokuyila iDatabase kunye noBudlelwane obunye noBuninzi
Ukuphumeza ubudlelwane obuninzi ukuya kubaninzi kwiTekisi yaBatitshala kunye neeNkundla, siwaphula iitafile zibe zibini kwaye sidibanisa nabo usebenzisa ikona yangaphandle .
Apha, sisusile ikholomu ye-Course kwi tafile yaTitshala:
Mfundisi _ID | Umfundisi _Name |
---|---|
Teacher_001 | UCarmen |
Teacher_002 | IVeronica |
Teacher_003 | Jorge |
Kwaye nantsi itafile zekhosi. Qaphela ukuba ukhiye welizwe langaphandle, u-Teacher_ID, udibanisa ikhosi ukuya kutitshala kwitheyibhile yootitshala:
Course_ID | Course_Name | Teacher_ID |
---|---|---|
Course_001 | Biology | Teacher_001 |
Course_002 | IMathematika | Teacher_001 |
Course_003 | IsiNgesi | Teacher_003 |
Siphuhlise ubudlelwane phakathi kootitshala kunye netafile zekhosi ngokusebenzisa ikhiye yangaphandle.
Oku kusitshelisa ukuba zombini i-Biology kunye neMathe ifundiswa nguCarmen kwaye uYorge ufundisa isiNgesi.
Siyakwazi ukubona ukuba lo mdwebo ugweba naluphi na ukulungelelanisa, uvumela ootitshala abathile ukuba bafundise izifundo ezininzi, kwaye basebenzise ubuhlobo obuninzi ukuya kubaninzi.
Ienkcukacha zingaphinde zisebenzise ubuhlobo bomntu omnye kunye nolwalamano oluninzi.