Chii chinonzi Transitive Dependency mu Database

Dzivisa Kuchinja Kwokutenderera Kubatsira Kuchengetedza Normalization

Kushandura kwechinyorwa mu database kune hukama husina kukanganisa huri pakati petafura imwechete iyo inokonzera kushanda kunoshanda . Kuti uite zvinowanzoenderana nehutatu hweFomu yeHanormal Form (3NF), unofanira kubvisa chero kushanduka kwekutendeuka.

Nenzira yaro, kutarisa kwekutendeuka kunodikanwa zvitatu kana kupfuura zvinowanikwa (kana zvinyorwa zvemasvomhu) zvine basa rinoenderana pakati pavo, zvinoreva kuti Rudzi rwekutanga A riri patafura rinotenderera paChitamu B kuburikidza neChitamu C.

Ngationei kuti izvi zvingashanda sei.

Transitive Dependency Example

VANHU

Author_ID Munyori Bhuku Author_Nationality
Auth_001 Orson Scott Card Ender's Game nyika dzakabatana
Auth_001 Orson Scott Card Ender's Game nyika dzakabatana
Auth_002 Margaret Atwood The Handmaid's Tale Kanadha

Mumuenzaniso weAUTHORS pamusoro apa:

Asi tafura iyi inotanga kutenderera kwekutendeuka:

Kudzivisa Kuchinja Kutendeseka

Kuti tive nechokwadi cheTatu yeHome Form, ngatibvisei kutenderera kwekutendeuka.

Tinogona kutanga nokubvisa korona yeBhuku kubva patafura yeVanyori nekugadzira tafura yemabhuku yakasiyana:

BHUKU

Book_ID Bhuku Author_ID
Book_001 Ender's Game Auth_001
Book_001 Vana veMafungiro Auth_001
Book_002 The Handmaid's Tale Auth_002

VANHU

Author_ID Munyori Author_Nationality
Auth_001 Orson Scott Card nyika dzakabatana
Auth_002 Margaret Atwood Kanadha

Izvi zvakagadzirisa here? Ngationgororei kuvimba kwedu zvino:

BHUKU DHA :

Tafura yevanyori :

Tinofanira kuwedzera tafura yechitatu kuti tifunge iyi data:

NYIKA

Country_ID Nyika
Coun_001 nyika dzakabatana
Coun_002 Kanadha

VANHU

Author_ID Munyori Country_ID
Auth_001 Orson Scott Card Coun_001
Auth_002 Margaret Atwood Coun_002

Iye zvino tava nematafura matatu, tichishandisa zvigere zvekunze zvekubatanidza pakati pematafura:

Nei Kutenderera Kwezvokutendeseka Kwakashata Mashoko Akasikwa

Ndeipi kukosha kwekudzivirira kutenderera kwekutendeuka kubatsira kubatsira 3NF? Ngatimbokurukura tafura yedu yekutanga zvakare uye tione nyaya inogadzira:

VANHU

Author_ID Munyori Bhuku Author_Nationality
Auth_001 Orson Scott Card Ender's Game nyika dzakabatana
Auth_001 Orson Scott Card Vana veMafungiro nyika dzakabatana
Auth_002 Margaret Atwood The Handmaid's Tale Kanadha

Rudzi urwu rwekugadzira runogona kuita kuti deta dzisiyane uye dzisingabvumirane, semuenzaniso:

Izvi zvinongova zvimwe zvikonzero nei kuisa tsika , nekudzivirira kuzvidzora kwekutendeuka, kuchengetedza deta uye kuvimbisa kusagadzikana.