Kuratidza kutendeseka ishoko rinonyanya kushandiswa mumasangano ehupfumi ehurumende. Icho chinoita kuti hukama huri pakati pematafura mu database hurambe hwakarurama kuburikidza nekushandisa zvinetso kudzivirira vashandi kana zvikumbiro kupinda mune dhizi dzisina kururama kana kuratidza kudarika kusina.
Databases shandisa mafuraji kurongedza ruzivo rwavo. Izvo zvakafanana nespredishiti, yakadai seExcel, asi yakawanda kwazvo inokwanisa kukwanisa kushandisa vashandi. Databases basa pamwe nekushandiswa kweizvi nheyo dzekunze uye dzekunze, izvo zvinochengetedza ukama pakati pematafura.
Primary Key
Chinokosha chikuru chefurafura yezvinyorwa ndeye chiziviso chakasiyana-siyana chakagoverwa rekodhi imwe neimwe. Tafura imwe neimwe ichine imwe kana imwe yemazamu yakasarudzwa seyiyo yekutanga. A Social Security nhamba inogona kuva chinhu chinonyanya kukosha chekutsvaga mabhuku evhareji yevashandi nokuti imwe nhamba ye Social Social yakasiyana.
Zvisinei, nekuda kwezvakavanzika zvepachivande, nhamba yakagadziriswa yekambani yenyika ndiyo chisarudzo chakanaka chekushanda sechinhu chikuru chevashandi. Dzimwe shanduro yehutori-yakadai seMicrosoft Access - inopa chinhu chikuru chekutanga, asi chinangwa chisingakoshi hachina chaicho chinoreva. Zviri nani kushandisa kiyi nechinangwa kune rekodhi. Nzira yakareruka yekusimbisa kutendeseka kwekutenderera haisi kubvumira kushandiswa kune chinhu chikuru.
Key Foreign
Chiyi chekune imwe nyika chiratidzo mutafura inofanana nekiyi yekutanga yefurafura yakasiyana. Chiyi chekune dzimwe nyika inobatanidza ukama nedare rakasiyana, uye kutendeseka kunoreva hukama pakati pematafura aya.
Apo imwe tafura ine chinyorwa chekunze kune imwe tafura, pfungwa yekutsanangurira kutendeseka inotaura kuti iwe haungati uwedzere rekodi kune tafura ine chinyorwa chekune imwe nyika kunze kwekunge pane imwe yakafanana mune imwe tafura yakabatana. Icho chinosanganisirawo maitiro anozivikanwa sekuti cascading update uye cascading delete, izvo zvinoita kuti kuchinja kunoitwa kutafura yakabatana inoratidzwa mufurafura yekutanga.
Muenzaniso wekutsanangurira mitemo yakakwana
Funga nezvemamiriro ezvinhu apo une mahwendefa maviri: Vashandi uye Vatungamiri. Itafura yeVashandi ine mhedzisiro yekunze kune imwe nyika inonzi HandedBy, iyo inotaridzira rekodhi yemutariri webasa rega wega muTereji yevatariri. Kuratidza kuvimbika kunobatsira mitemo mitatu inotevera:
- Iwe haugoni kuwedzera rekodhi kune tafura yeVashandi kunze kwekuti maGeneredBy maitiro anongedzera rekodhi yakakodzera muTafura yevatariri. Kuratidza kuvimbika kunodzivirira kuiswa kwemashoko asina kukodzera mutafura. Chero basa ripi risingagutsiri kutonga kwekutendeka kwekutonga kunokundikana.
- Kana ikakosha yekodhi muTeji yevatungamiri ichishandura, zvose zvinyorwa zvakanyoreswa mubheji reVashandi zvinoshandiswa kuburikidza nekudzokorora kushandiswa.
- Kana rekodhi iri muGedhi reMagadziri rabviswa, zvose zvinyorwa zvinoenderana nefuraji yeVashandi zviri kubviswa kushandiswa kwechikwata.
Makomborero ekutsanangurwa Kuvhiringidzwa Kwezvakakwana
Kushandisa nhepfenyuro yekodzero yekuchengetedzwa kwemashoko nekutaridzika kwekutendeseka kunopa huwandu hunobatsira
- Inodzivirira kupinda kwepadata deta.
- Inodzivirira tafura imwe kubva pakuratidza kune imwe nzvimbo isipo mune imwe tafura.
- Kutsigirwa kwakasimba pakati pematafura "akabatanidzwa".
- Inodzivisa kubviswa kwechirangaridzo chine kukosha kunotaurwa kune imwe keni yekunze mune imwe tafura.
- Inodzivisa kuwedzerwa kwekodhi kutafura ine chitubu chekunze kunze kwekuti pane chinhu chikuru chekutanga mutafura yakabatanidzwa.