Ɗaya guda zuwa daya

Hanyoyin zumunci ɗaya da ɗaya sune wani ɓangare na gina ginin bayanai

Hoto ɗaya zuwa daya yana faruwa a lokacin da akwai rikodin daya a cikin teburin farko da ya dace da rikodin daya a cikin teburin da aka keɓa. Alal misali, jama'ar {asar Amirka suna da lambar Tsaron Tsaro. Akwai lambar ɗaya da aka sanya ta mutum, sabili da haka, mutum ba zai iya samun lambobi masu yawa ba.

Ga wata misali ta amfani da teburin biyu a kasa. Teburin suna da dangantaka daya-daya ɗaya saboda kowane jere a farkon tebur yana da alaka da wani jere a cikin tebur na biyu.

Lambar ma'aikacin Sunan rana Sunan mahaifa
123 Rick Rossin
456 Rob Halford
789 Eddie Henson
567 Amy Bond


Saboda haka adadin layuka a cikin launi na ma'aikata ya kasance daidai da yawan layuka a cikin matakan ma'aikata.

Lambar ma'aikacin Matsayi Waya Ext.
123 Aboki 6542
456 Mai sarrafawa 3251
789 Aboki 3269
567 Mai sarrafawa 9852


Wani nau'i na samfurin database shine dangantaka daya-da-da-yawa. Ta amfani da tebur na kasa zaka iya ganin cewa Rob Halford, mai sarrafa ne, sabili da haka dangantakarsa da matsayi ta kasance ɗaya ce da ɗaya saboda a wannan kamfanin mutum yana da matsayi ɗaya. Amma matsayin jagoran ya hada da mutane biyu, Amy Bond da Rob Halford, wanda ke da dangantaka da juna. Wata matsayi, mutane da yawa.

Ƙara koyo game da Maɗallan Bayanan Intanit, Harkokin Ƙasashen waje, Ɗauki da Shirye-shiryen ER .