E kāpae i nā kākoʻo o ka neʻeʻana e kōkua ai e hōʻoia i ka Normalization
ʻO ka hilinaʻi kūpono i loko o kahi waihonaʻikepili kahi pilina piliʻole ma waena o nā koina i ka papa hoʻokahi e hoʻonā i ka pono . No ka hoʻokōʻana i ke kūlana kūʻokoʻa o ka Formal Normal Form (3NF), ponoʻoe e hōʻoki i kekahi hilinaʻi holoʻokoʻa.
Ma muli o konaʻano, pono ka hilinaʻiʻana iʻekolu mauʻano (a iʻole nāʻanuʻuʻikepili) i loaʻa ka hilinaʻi hana ma waena o lākou,ʻo ia hoʻiʻo ka Māhele A ma kahi pākaukau e hilinaʻi ana i ka Column B ma waena o kahi Column C.
E nānā i ka hopena o kēia.
ʻO kahi hiʻohiʻona no ke kūlana palekana
AUTHORS
Author_ID | Mea kākau | Puka | ʻO Wikipedia_Nationality |
---|---|---|---|
Auth_001 | ʻO'Orson Scott Kākau | Ender 'o Ender | ʻAmelika Hui Pū ʻIa |
Auth_001 | ʻO'Orson Scott Kākau | Ender 'o Ender | ʻAmelika Hui Pū ʻIa |
Auth_002 | ʻO Margaret Atwood | ʻO ke kelepa wahine | Kanaka |
I ka hiʻohiʻona AUTHORS i luna aʻe nei:
- Book → Mea kākau : Maʻaneʻi,ʻo ka inoa o ka Puʻupuʻu ka manaʻo o ka mea kākau . Ināʻikeʻoe i ka inoa inoa, hiki iāʻoe ke aʻo i ka inoa o ka mea kākau. Eia naʻe,ʻaʻole ka Mea kākau i hoʻoholo i ka puke , no ka hiki i ka mea kākau ke kākau i nā puke he nui. Eia kekahi lā, no ka mea uaʻike mākou i ka inoa o ka mea kākau o'Orson Scott Card,ʻaʻole mākou iʻike i ka inoa o ka puke.
- Ka mea kākau → Author_Nationality : Pēlā nō,ʻo ka mea kākau ka manaʻo e hoʻoholo i ka Author_Nationality , akāʻaʻoleʻo kaʻaoʻao'ē aʻe; no ka mea, maopopo mākou i ka lāhuiʻaʻole hiki iā mākou ke hoʻoholo i ka mea kākau.
Akā, hōʻike kēia papa i kahi hilinaʻi kūpono:
- Book → Author_Nationality: Ināʻike mākou i ka inoa inoa, hiki iā mākou ke hoʻoholo i ka lāhui kanaka ma o ka pou poʻokela.
Ka palekana i nā koina o ka neʻe
No ka hōʻoiaʻana i ke Form Normal Uku, e hoʻoneʻeneʻe i ka hilinaʻi.
Hiki iā mākou ke hoʻomaka ma ka hoʻopauʻana i ke kolamu Book ma o ka papaʻaina a me ka hoʻokumuʻana i kahi papaʻaina.
ʻO nā puke
Book_ID | Puka | Author_ID |
---|---|---|
Book_001 | Ender 'o Ender | Auth_001 |
Book_001 | ʻO nā keiki o ka manaʻo | Auth_001 |
Book_002 | ʻO ke kelepa wahine | Auth_002 |
AUTHORS
Author_ID | Mea kākau | ʻO Wikipedia_Nationality |
---|---|---|
Auth_001 | ʻO'Orson Scott Kākau | ʻAmelika Hui Pū ʻIa |
Auth_002 | ʻO Margaret Atwood | Kanaka |
Ua hana anei kēia i kēia mea? E nānā i kā mākou mau manaʻonaʻa i kēia manawa:
ʻO ka papa kuhi :
- Book_ID → Book: ʻO ka puke ma ka Book_ID .
- ʻAʻohe mea hoʻololi'ē aʻe ma kēia papa e noho nei, no laila ua maikaʻi mākou. E hoʻomaopopo i ka mea kākauʻo Author_ID e hono i kēia pākaukau i ka papa AUTHORS ma o kona kumuinoa kumu_ahi . Ua hana mākou i kahi pilina e pale ai i ka hilinaʻi i ka hopena, kahi kiʻina o kaʻikepili pili.
ʻO ka papahana AUTHORS :
- Author_ID → Mea kākau: Mea kākau ka mea i pili i ka Author_ID .
- Mea kākau → Author_Nationality: ʻO ka lāhui ka mea e hoʻoholoʻia e ka mea kākau.
- Author_ID → Author_Nationality: E hiki ke hoʻoholoʻia ka nationality mai ka Author_ID ma o keʻano o ka mea kākau . Loaʻa mākou i ka hilinaʻi holoʻokoʻa.
Pono mākou e hoʻonui i kahi papaʻekolu e hoʻomau i kēiaʻikepili:
KĀWAI
Country_ID | Ke Aliʻi |
---|---|
Helu_001 | ʻAmelika Hui Pū ʻIa |
Heluhelu | Kanaka |
AUTHORS
Author_ID | Mea kākau | Country_ID |
---|---|---|
Auth_001 | ʻO'Orson Scott Kākau | Helu_001 |
Auth_002 | ʻO Margaret Atwood | Heluhelu |
I kēia manawa,ʻekolu mākou papa e hoʻohana nei i nā kī'ē aʻe e pili i nā papa:
- ʻO ka mea kākau haole o ka BOOK e kākau ana i kahi puke i kahi mea kākau ma ka papaʻo AUTHORS.
- Ke kākoʻo o ka'Āina Country key o ka'Āina AUTHORS i kahi mea kākau i kekahi'āina ma ka papa'āina COUNTRIES.
- ʻO ka papa'āina COUNTRIESʻaʻole he kī haole no ka mea,ʻaʻole pono e hono i kekahi papa'ē aʻe i kēia hoʻolālā.
No ke aha ke kumuhana o ka pilina o ke kikowaena
He aha ke kumu o ka paleʻana i nā dependencies transitive e kōkua i ka 3NF? E noʻonoʻo hou i ka papa papa mua aʻike i nā pilikia e hanaʻia ana:
AUTHORS
Author_ID | Mea kākau | Puka | ʻO Wikipedia_Nationality |
---|---|---|---|
Auth_001 | ʻO'Orson Scott Kākau | Ender 'o Ender | ʻAmelika Hui Pū ʻIa |
Auth_001 | ʻO'Orson Scott Kākau | ʻO nā keiki o ka manaʻo | ʻAmelika Hui Pū ʻIa |
Auth_002 | ʻO Margaret Atwood | ʻO ke kelepa wahine | Kanaka |
Hiki i kēiaʻano hana ke hāpai i nā anomalies a me nā kuʻunaʻole, e like me kēia:
- Inā hoʻopauʻoe i nā pukeʻelua "Children of the Mind" a me "Ender's Game," hiki iāʻoe ke holoi i ka mea kākau "'Orson Scott Card" a me kona kūʻokoʻaʻana mai ka waihonaʻikeʻike.
- ʻAʻole hiki iāʻoe ke hoʻohui i kahi mea kākau hou i kaʻikepili keʻoleʻoe e hōʻoia i kahi puke; ināʻaʻole i paʻiʻia ka mea kākau aʻaʻoleʻoe iʻike i ka inoa o kahi puke i kākauʻia e ia?
- Inā "hoʻololiʻo"'Orson Scott Card "i kona kūlana lāhui, ponoʻoe e hoʻololi i nā moʻolelo a pau āna iʻike ai. Ma muli o ka loaʻaʻana o nā moʻolelo he nui me ka mea kākau hoʻokahi paha, hiki i kaʻikepili pololei: pehea lā ināʻaʻoleʻike ka meaʻikepili i nā moʻolelo he nui no ia a hoʻololi i nāʻikepili i hoʻokahi wale nō moʻolelo?
- ʻAʻole hiki iāʻoe ke hoʻopuka i kahi puke e like me "The Handmaid's Tale" me ka holoiʻoleʻana i ka mea kākau.
He mau kumu kēia no ke kumu e palekana ai , a me ka paleʻana i nā hilinaʻi o ka holomua, e pale i nāʻikepili a me ka hoʻoikaika pono.