Tsanangudzo yeChitidhi Key

Dhiyabhorosi Mavambo Mavambo Dzimwe nguva Iva Pamba Chekutanga

Chinhu chakakosha chinosanganiswa chezvinhu zvinogona kushandiswa zvakasiyana-siyana kuti uone rekodhi rekodhiyo pasina kutaura kune imwe dhesi. Tafura imwe neimwe inogona kuva nemunhu mumwe kana kupfuura. Chimwe chezvikwereti zvinosarudzwa zvinosarudzwa sehofura yekutanga . Tafura ine chinyorwa chimwechete chekutanga, asi inogona kuva nezvikwereti zvakawanda zvevadzidzi. Kana ikakosha yekodhi yakagadzirwa nemamwe mapoka maviri kana kupfuura, zvino inonzi "composite key".

Zvitoro zveMutevedzeri Key

Zvose zvinokwidziridzwa zvinokwana zvimwe zvinhu. Chimwe chezvinhu izvi ndeyekuti hupenyu hwose hwehwu hunokosha, izvo zvinoshandiswa pakuzivikanwa zvinofanira kuramba zvakafanana. Chimwe ndechokuti kukosha hakugone kusina. Pakupedzisira, chinhu chakakosha chinofanira kuva chakasiyana.

Semuenzaniso, kuti zvioneke mumwe nomumwe mushandi kambani inogona kushandisa nhamba yebazi re Social Security. Sezvaunogona kuona, kune vanhu vane mazita okutanga, mazita ekupedzisira, uye nzvimbo, asi hapana vanhu vaviri vakambova neyoyo Social Security nhamba.

Social Security Number Zita rokutanga Zita rokupedzisira Position
123-45-6780 Craig Jones Manager
234-56-7890 Craig Beal Shamwari
345-67-8900 Sandra Beal Manager
456-78-9010 Trina Jones Shamwari
567-89-0120 Sandra Smith Shamwari

Mienzaniso yeVadzidzi Vechidiki

Dzimwe mhando dze data dzinogona kuzvikweretesa sevadzidzi:

Zvisinei, mamwe marudzi ehumwe ruzivo rwungaita sevakakosha zvakanaka zvechokwadi anoratidza dambudziko: