E noʻonoʻo i kahiʻano pilikino e like me keʻano
ʻO kahi meaʻikepiliʻoi aku ka mana ma mua o ka pālahalaha e like me ka mea he nui kaʻike hulina. Nāʻikepili pūnaewele kūkākūkā i nā kikowaena o nā papa likeʻole a hana i nā helu kūpili i ka nui o nāʻikepili pūnaewele. Hoʻonohonohoʻia kaʻike ma kahi alalahi hiki ke mālamaʻia, hiki mai, a hoʻololiʻia.
He aha keʻano?
ʻO kahi pūnaewele he papa. He papa ko kēlā me kēia papa.
ʻO kēlā me kēia lalani (i kapaʻia he tuple) kahi hoʻonohonohoʻikepili i pili i kahi mea hoʻokahi. ʻO kēlā me kēia kolamu (inoa) e hōʻike ana i nāʻano o nā lālani. ʻO ka inoa o kaʻikepili kahi inoa inoa kolamu a me ka mea o nā māhele ma lalo o ka papa i loko o ka waihonaʻikepili.
Inā kūʻaiʻoe i nā huahana a komo i loko o kahi papaʻaina me nā koluma no ProductName, Price, a ProductID,ʻo kēlā me kēia poʻo kumu he mea ia. Ma kēlā me kēia māhele ma lalo o kēlā mau poʻo, e hoʻokomoʻoe i nā inoa huahana, nā kumukūʻai, a me nā huahana huahana. ʻO kēlā me kēia o nā mākau kahua he mea pono.
He kūpono kēia i kou noʻonoʻoʻana i ia mea, no ka mea,ʻo ka ho'ākākaʻenehanaʻole o kahi inoaʻo ia ke kuhikuhi nei i kahiʻano a iʻole keʻano o kekahi mea.
Hōʻike i nā 'ano o ka pono
E noʻonoʻo mākou i kahiʻikepili i hoʻomohalaʻia e kekahiʻoihana. Hiki paha i nā papahana-nā poʻe i kapaʻia e nā mea hoʻolaha pūnaewele-no nā Kūʻai, Nā Mea Hana, a me nā Huahana, a me nā mea'ē aʻe. ʻO ka huahana Papa e hōʻike i nāʻano o kēlā me kēia huahana.
Hiki i kēia mau mea ke hoʻokomo i kahi ID hua, inoa huahana, ID kikowaena (hoʻohanaʻia me he kī'ē aʻe ), kahi nui, a me ke kumukūʻai. ʻO kēlā me kēia mauʻano he inoa o ka papa (a iʻole ka entity) i kapaʻia Nā inoa.
E noʻonoʻo i kēia'ōkuhi mai kaʻikepili pūnaewele o Northwinds:
ProductID | Inoa mea kūʻai | SupplierID | Kāpeka CategoryID | NuiPerU | UnitPrice |
---|---|---|---|---|---|
1 | Chai | 1 | 1 | 10 pahu x 20 mau peke | 18.00 |
2 | Huli | 1 | 1 | 24 - 12 oz mau'ōmole | 19.00 |
3 | ʻO ka sygne Aniseed | 1 | 2 | 12 - 550 ml mau omole | 10.00 |
4 | ʻO Chef Anton's Cajun Seasoning | 2 | 2 | 48 - 6 'ai kek | 22.00 |
5 | ʻO Chef Anton's Gumbo Mix | 2 | 2 | 36 pahu | 21.35 |
6 | Kākoʻo nuiʻo Grandma's Boysenberry | 3 | 2 | 12 - 8 oz | 25.00 |
7 | ʻOʻAnakala Bobʻo Organic Dried Pears | 3 | 7 | 12 - 1 lb pkgs. | 30.00 |
ʻO nā inoa kolamu nāʻano o ka huahana. ʻO nā komo i loko o nā māla o nā kolamu kekahiʻano o nā huahana.
He Haʻina Hoʻolaha?
I kekahi manawa, hoʻohanaʻia ka māla a me keʻano o ka manawa, a no ka nui o nā kumuhana, hoʻokahi like lākou. Eia naʻe, hoʻohanaʻia ka papa no ka weheweheʻana i kekahi pūnaewele maʻamau i ka papa i loaʻa ma kekahi laina,ʻoiai ka hoʻohanaʻiaʻana o ka momona e wehewehe i kahi mea iʻikeʻia i keʻano hoʻohālikelike.
No ka laʻana, i ka papa ma luna,ʻo ka ProductName ma ka lainaʻeluaʻo Chang . He māla kēia . Ināʻoe e kūkākūkā ana i nā huahana maʻamau, ProductName ka paehana huahana. ʻO kēia keʻano .
Mai piʻiʻoe ma luna o kēia. ʻO ka manawa pinepine, hoʻohanaʻia kēia mau hua'ōleloʻelua.
Ke weheweheʻana i nāʻano
Ho'ākākaʻia nāʻano pilikino ma keʻano o kā lākou pūnaewele . Hoʻolakaʻia kahi mahele e hiki ai ke hoʻokomo i kēia mea. Hiki i kēia ke hoʻokomo i konaʻanoʻikepili, ka lōʻihi, nā koina, a me nā kiko'ī'ē aʻe.
Eia kekahi laʻana, hiki ke hoʻohālikelike ke kikowaena no kahi huahana ProductID i kahiʻanoʻike helu. Hiki ke ho'ākāka houʻia ka pilikino e koi ai i kahi lōʻihi lōʻihi a iʻole e hōʻike i ka hāʻawiʻia o kahi waiwai kūpono aʻikeʻole paha.