Dhiyabhorosi maiyo ndiyo nzira inonyanya kuumba yekugadzira dhiyabhorosi yakabatana ye database
Sezvaunogona kunge watoziva, databases dzinoshandisa tafura kuti uronge ruzivo. (Kana iwe usina ruzivo rwemashoko epa database, verenga Chii chine Dhamasiko? ) Tafura imwe neimwe ine mitsara yakawanda, imwe neimwe inofanirana nerekodhi imwe yekodhi. Saka, mabhuku akachengetedzeka anochengetedza sei marekodhi aya zvakananga? Icho kuburikidza nekushandiswa kweiyi.
Primary Keys
Rudzi rwekutanga rwekona yatinokurukura ndiro chinhu chikuru . Mahwendefa ega ega ega ega etafura anofanira kunge ane imwe kana mamwe mapuranga akagadzwa sechinhu chikuru . Iko kukosha kweiyi kiyi inofanira kunge yakasiyana kune rimwe rekodhi mu database.
Semuenzaniso, tifunga tine tafura inonzi VaHurumende inoshandisa ruzivo rwevashandi kune vashandi vose pakusimba kwedu. Tichazofanira kusarudza yakakosha iyoyi yekutanga iyo inonyanya kusarudza umwe neumwe mushandi. Pfungwa yako yekutanga ingave yekushandisa zita romushandi. Izvi hazvizobudiriri zvakanaka nokuti zvinofungidzirwa kuti iwe uchatora vashandi vaviri vane zita rimwe chete. Chisarudzo chakanaka chingave chiri kushandisa shanduko yakasiyana-siyana yechirango yevashandi yaunopa kune umwe neumwe mushandi kana vakashandira. Mamwe masangano akasarudza kushandisa Social Security Numeri (kana zvimwe zvinoratidza hurumende) nokuda kwebasa iri nokuti mumwe mushandi ave atova neavo uye vanovimbiswa kuti vakasiyana. Zvisinei, kushandiswa kweSocial Security Numeri nokuda kwechinangwa ichi kunokakavara zvikuru nekuda kwezvinetso zvevamwe. (Kana iwe uchishandira sangano rehurumende, kushandiswa kweNhamba yeHurumende yeHurumende inogona kunge isina kutenderwa pasi peMutemo weChinyorwa cha194.) Nokuda kwechikonzero ichi, masangano akawanda akachinja kushandiswa kwezvitsvene zvinoratidza (mushandi weDhiyabhorosi, ID mudzidzi, etc .) izvo zvisingabatanidzi zvinetso zvemunhu oga.
Kana ukasarudza pamusoro pekiyi yekutanga uye ugadzika dhesiyo, shanduro yekuchengetedza dhesi yepamusoro ichasimbisa hutano hwechiyi.
Kana iwe uchiedza kuisa rekodhi mutafura ine kiyi yepamusoro inodzokorora rekodhi iripo, iyo inowanikwa ichapera.
Nyaya dzakawanda dzinodhindwa dzinogonawo kugadzira zvigaro zvavo zvekutanga. Microsoft Access, somuenzaniso, inogona kugadzirirwa kushandisa gwaro reDotNumber kuti ipe ID yakasiyana nedare rega rega patafura. Paunenge uchibudirira, ichi chinhu chakaipa chimiro chekuita nokuti inokusiya uine kukosha kusina maturo mumabhuku ose ari patafura. Sei usingashandisi nzvimbo iyo kuchengetedza chimwe chinhu chinobatsira?
Maoko Okune dzimwe nyika
Chimwe chimiro ndicho chiyi chekunze , icho chinoshandiswa kugadzira ukama pakati pematafura. Ukama hwepanyama huripo pakati pematafura mune zvivako zvakawanda zvepa database. Kudzokera kune vashandisi vebasa redu, fungidzira kuti taida kuwedzera tafura ine mashoko ehurumende kune database. Iyi tafura itsva inogona kunzi Dhipatimendi uye inogona kuva nehuwandu hwehuwandu hwemutunhu wese. Tinodawo kuisa ruzivo pamusoro pevashandi vari muDhipatimendi, asi zvingave zvisingakwanisi kuwana ruzivo rwakadaro mumatafura maviri (Vashandirwi neDhipatimendi). Pane kudaro, tinogona kugadzira ukama pakati pematafura maviri.
Ngatitangei kuti Dhipatimendi rinoshandisa shandisi yeDhipatimendi Zita sechinhu chikuru. Kuti tive neukama pakati pematafura maviri, tinowedzera mutsara mutsva kune tafura yevashandi inonzi Dhipatimendi. Isu tinozadza zita rebazi iro rimwe rega rega riri rega. Isu tinoshandisawo mahofisi ekuchengetedzwa kwemashoko ekuti Dhipatimendi reDhipatimendi mufuraji yevashandi ikiyi yekunze kune iyo inotaura nezveDhipatimendi.
Dhorobhadha inozosimudzira kutendeseka kwakakwana kuburikidza nekuvimbisa kuti yose yehutsika muDhipatimendi yeChirongwa cheDhiyabhorosi yefurairi ine zvinyorwa zvinoenderana nematafura eMitambo.
Cherechedza kuti hapana chakakosha chechikwereti chekune imwe nyika. Tinogona (uye kazhinji tinodaro) tine vashandi vanopfuura vese vedunhu rimwe chete. Saizvozvowo, hapana chidimbu chokuti kupinda mukati meDhipatimendi reDhipatimendi kune chero chinyorwa chinopindirana muDhiyabhorosi. Zvinokwanisika kuti tive nedhipatimendi pasina vashandi.
Kuti uwane zvakawanda pamusoro pechinyorwa chino, verenga Kuumba Mahedheni Ekunze .