Database Candidate Keys Wani lokaci Ya zama Firayim Ministan
Maballin dan takarar shi ne haɗin halayen da za a iya amfani dasu don gane bayanan rikodin ba tare da nuna wani labari ba. Kowane tebur yana iya samun ɗaya ko fiye dan takara. Ɗaya daga cikin waɗannan makullin dan takarar an zaɓa a matsayin maɓallin farko na maɓallin . Tebur yana ƙunshe kawai maɓalli na farko, amma yana iya ƙunsar maɓallai masu mažalli da yawa. Idan maɓallin dan takara ya ƙunshi ginshiƙai biyu ko fiye, to, an kira shi maɓallin maɓalli.
Abubuwan da ke Maɓallin Ƙira
Duk maɓallan dan takarar suna da wasu kaya masu yawa. Ɗaya daga cikin kaddarorin ita ce, domin rayuwar dan takarar, ma'anar da aka yi amfani da shi don ganewa dole ne ya kasance daidai. Wani kuma shi ne cewa darajar ba za ta zama marar amfani ba. A ƙarshe, maɓallin dan takara dole ne ya zama na musamman.
Alal misali, don gano kowacce ma'aikaci wani kamfani zai iya amfani da lambar Tsaron Tsaro na ma'aikacin. Kamar yadda ka gani, akwai mutane da sunayen farko, sunaye na karshe, da matsayi, amma babu mutane biyu suna da lambar Tsaron Tsaro ɗaya.
Lambar Tsaro | Sunan rana | Sunan mahaifa | Matsayi |
---|---|---|---|
123-45-6780 | Craig | Jones | Mai sarrafawa |
234-56-7890 | Craig | Ji | Aboki |
345-67-8900 | Sandra | Ji | Mai sarrafawa |
456-78-9010 | Trina | Jones | Aboki |
567-89-0120 | Sandra | Smith | Aboki |
Misalan Kirar Kira
Wasu nau'o'in bayanai sun ba da kansu a matsayin masu takara:
- Littafin Lissafin Ƙididdiga na Duniya-ISBNs sun bambanta da littattafai da kafofin watsa labaru. Ana ba da izinin samar da ISBNs ta hanyar masu kula da masana'antu da kuma masu amfani da ISBNs ba su sake amfani da su ba.
- Lambar asusun banki-Mafi yawa bankunan ba su sake maimaita lambobi.
- Lambobin Serial-Ko da yake lambobin salula ba a sarrafa su a fadin masana'antu, a cikin mahallin mai sayarwa ɗaya, lambar lambobi ya kasance na musamman.
- Lambobin lasisi takardu-Yawancin lokaci, waɗannan lambobi ba su duplicated ba. Duk da haka, mutumin da ya motsa daga jihar zuwa jihar yana iya samun lambar DL fiye da ɗaya.
- Masu ba da izini na ID na kasa da sauran masu samar da lafiya na lasisi suna da akalla NPI guda ɗaya da ke da muhimmanci a gare su, wanda Ma'aikatar Kiwon Lafiya ta Amurka da Ayyukan Dan-Adam suka bayar.
Duk da haka, wasu nau'o'in bayanan da zasu yi kama da 'yan takara masu kyau suna tabbatar da matsala:
- Lambobin waya-Mafi yawan masu sufuri na sake maimaita lambobin wayar, kuma masu biyan kuɗi ɗaya zasu iya samun lambobin waya ɗaya lokaci ɗaya.
- Lambobin Kasuwanci na Duniya-UPCs na musamman, amma mai mallakar mai UPC zai iya sake yin amfani da kayan aiki.
- Lambobin labarun likita-MRN ana bayar da su a asibitin, ba tare da wani irin shiri na kasa ba
- Lambobin tsaro na zamantakewa - Ko da yake sun kasance na musamman, SSNs za su sake yin amfani da su, kuma zamba na SSN yafi dacewa don tabbatar da wannan matsala a fadin manyan bayanai. (A cikin wani ma'aikaci wanda yake tabbatar da SSNs, wannan kalubale ba matsala ce ba.)