Ke weheʻia kahi puka'ē aʻe i kahi honua o kaʻikepili
Hiki i nā mea hoʻolālā hoʻonohonohoʻike ke hoʻohana i nā kī i ke kūkuluʻana i nāʻikepili pūnaewele. Ma waena o nā kī nui o kēia mau kī, he mau kī nui a me nā kī'ē aʻe. ʻO ka helu keleponaʻikepili kahi māla i kahi papa pili e pili ana i ka papahana mua o kahi papa'ē aʻe. No ka hoʻomaopopoʻana i kahi hanaʻana o kahi kī'ē, e nānā pono kākou i ka manaʻo o kahi pūnaewele pili.
Nā kumuhana o kaʻikepili
Ma ka pilina pili pili, e mālamaʻia kaʻikepili i nā papa i loaʻa nā lālani a me nā koluma, e maʻalahi ka huli a me ka manipula. He wahi helu maʻamau kēia ma hope o ka manaʻo o kahi pūnaewele pili (pilina pilikino, i manaʻoʻia e EF
Ua hoʻopiliʻia ma IBM i ka makahiki 1970), akā,ʻaʻole ia ke kumu o kēiaʻatikala.
No nā hana kūikawā (a me nā nonemathmath), kahiʻikepili pili waiwai "pili" i nā lālani a me nā koluma. Eia hou-a maanei kahi i maʻa ai ka maikaʻi - nui nā pūnaeweleʻike i hoʻohālikelikeʻia i hiki ai i nāʻikepili ma kahi papa ke hiki i nāʻikepili i kekahi papa'ē aʻe. ʻO kēia hiki ke hana i ka pilina ma waena o nā papaʻaina ka mana maoli o kahi pūnaewele pili.
Ke hoʻohanaʻana i nā Kele'ē
ʻO ka hapa nui o nā papa,ʻo ka mea nui ma nāʻikepili koʻikoʻi, he mau kī nui. ʻO nā papahana i hoʻolālāʻia e komo i nā papa'ē aʻe, he pono ke loaʻa i kahi kī'ē aʻe.
No ka hoʻohanaʻana i kaʻikepili pūnaeweleʻo Northwinds, eia kahi hapa o ka papahana Hua:
| ProductID | Inoa mea kūʻai | Kāpeka CategoryID | NuiPerU | UnitPrice |
|---|---|---|---|---|
| 1 | Chai | 1 | 10 pahu x 20 mau peke | 18.00 |
| 2 | Huli | 1 | 24 - 12 oz mau'ōmole | 19.00 |
| 3 | ʻO ka sygne Aniseed | 2 | 12 - 550 ml mau omole | 10.00 |
| 4 | ʻO Chef Anton's Cajun Seasoning | 2 | 48 - 6 'ai kek | 22.00 |
| 5 | ʻO Chef Anton's Gumbo Mix | 2 | 36 pahu | 21.35 |
| 6 | Kākoʻo nuiʻo Grandma's Boysenberry | 2 | 12 - 8 oz | 25.00 |
| 7 | ʻOʻAnakala Bobʻo Organic Dried Pears | 7 | 12 - 1 lb pkgs. | 30.00 |
ʻO ka huahana ProductID kēia kī nui o kēia papa. Hāʻawi ia i kahi ID hiʻona i kēlā me kēia huahana.
Aia kēia papaʻaina i kahi kālani kīlahi'ē aʻe,ʻo CategoryID . ʻO kēlā me kēia huahana i ka pāʻani Hua e pili ana i kahi komo i ka papaʻaina e ho'ākāka ana i kēlāʻano huahana.
E hoʻomaopopo i kēia helu mai ka papahana Papahanaʻikepili:
| Kāpeka CategoryID | CategoryName | Hōʻike |
|---|---|---|
| 1 | Nā mea inu | Nā mea inu, nā kalo, nā teas, a me nā ales |
| 2 | ʻO Condiments | ʻO nā meaʻono,ʻoluʻolu, pāhola, a me nā meaʻono |
| 3 | Aloha | Nā Dessert, nā candies, a me nā meaʻala |
| 5 | Nā Mea Laʻa Lapaʻa | ʻO Cheeses |
ʻO ka Cedar column ko kēia kī nui. (ʻAʻole he kī'ē aʻe no ka meaʻaʻole pono e komo i kahi papa'ē aʻe.)ʻO kēlā me kēia kī kī'ē aʻe i ka papahana Hua e pili ana i kahi kī nui i ka papaʻaina. No ka laʻana, hāʻawiʻia ka Chai huahana i kaʻano "Nā inu", oiaiʻo Aniseed Syrup i loko o ka māhele Condiments.
ʻO kēiaʻano pilina e hana i nāʻano he nui e hoʻohana a hoʻohana hou i nāʻikepili i loko o kaʻikepili pili.