Nā Kōkua Kūkulu Kūpono Kūpono e Kakele i ka HanapiliheluʻIkepili
Hiki i ka hilinaʻi hana ma kahi waihona waihona mālama i kahi hoʻonohonoho i waena o nāʻano. Hanaʻia kēia i ka wā e hoʻoholo ai kekahi i loko o kahi pilikino i kahiʻano'ē aʻe. Hiki iā ia ke kākau iā A -> B ,ʻo ia hoʻi "e pili pono anaʻo B ma luna o A." Hōʻuluʻuluʻia ka inoa o kaʻikepili .
I loko o kēia pilina,ʻo A ka mea e hoʻoholo ai i ka waiwai o B, aʻo B e pili ana iā A.
No ke aha he mea nui ka hilinaʻi i ka hana ma ka palapala Database
Hoʻoikaika ka hilinaʻi kūpono e hōʻoiaʻiʻo i ka pololei o nāʻikepili. E nānā i ka papaʻaina Nā limahana e hoʻonohonoho ana i nā hiʻohiʻona e like me ka helu mālama ola (SSN), ka inoa, ka lā hānau, ka wahi a pēlā aku.
Na ka mea SS SS e hoʻoholo i ka waiwai o ka inoa, ka lā hānau, ka helu a me nā mea'ē aʻe paha, no ka mea he hoʻokahi kahi helu mālama ola, akāʻaʻole kahi inoa, lā hānau, a wahi paha. Hiki iā mākou ke kākau e like me kēia:
SSN -> inoa, lā hānau, address
No laila, inoa o ka inoa, ka lā hānau a me kahi helu e pili ana iā SSN. Eia naʻe,ʻaʻoleʻoiaʻiʻo ka'ōlelo hope (inoa -> SSN) no ka meaʻoi aku ka inoa likeʻole ma mua o hoʻokahi limahana akāʻaʻole loa e loaʻa iā SSN hoʻokahi. E hōʻalo i kahi'ē aʻe,ʻoi aku keʻano o ka maʻalahi, ināʻike mākou i ka waiwai o ka pūʻoko SSN, hiki iā mākou keʻike i ka waiwai o ka inoa, ka lā hānau, a me ka helu wahi. Akā, ināʻike mākou i ka waiwai o ka inoa o ka inoa wale nō, hikiʻole iā mākou ke kuhikuhi i ka SSN.
ʻO kaʻaoʻao hema o kahi hilinaʻi hana e hiki ke komo i kahi hua hoʻokahi aʻoi aku. E'ōlelo mākou heʻoihana kā mākou me nā wahi he nui. Hiki iā mākou ke pākaukauʻO ka mea hana me nā huahana, ka inoa, ka 'Oihana, ka wahi a me ka luna.
ʻImi ka mea hana i ka wahi e hana neiʻo ia, no laila, aia kahi hilinaʻi:
kanakahana -> kahi
Akā,ʻoi aku ka nui o kahi ma kahi o ka luna hoʻokahi, no laila, hui pū ka luna a me ka 'Oihana i ka luna:
kanaka, luna -> mana
Ka Hoʻoikaika Pono a me ka Normalization
Hoʻokumuʻia ka hilinaʻi kūpono i ka mea i kapaʻia o ka hoʻokumuʻana i kaʻikepili, e hōʻoiaʻiʻo ana i ka pono o kaʻikepili a hoʻohaʻahaʻa i nāʻikepili pūnaewele. No ka hoʻolālāʻole,ʻaʻohe'ōlelo hōʻoia he pololei a hilinaʻiʻia kaʻikepili i loko o kaʻikepili.