Ganizirani za chikhalidwe monga chikhalidwe
Mndandanda wachinsinsi uli wamphamvu kwambiri kuposa spreadsheet yomwe ikufanana chifukwa ili ndi mphamvu yochuluka yofufuzira. Mafotokozedwe oyanjana ndi zolembera zolembera m'mabuku osiyanasiyana ndikupanga zowerengeka zovuta pazinthu zochuluka zokhudzana ndi deta. Chidziwitsochi chimayendetsedwa m'njira yomwe imatha kusamalidwa, kuyipeza, ndi kusinthidwa.
Kodi Chikhalidwe N'chiyani?
Mndandanda wamatabuku uli ndi matebulo. Gome lililonse liri ndi mizere ndi mizere.
Mzere uliwonse (wotchedwa tuple) ndi deta yomwe ikugwiritsidwa ntchito pa chinthu chimodzi. Chigawo chilichonse (chikhalidwe) chili ndi kufotokoza makhalidwe a mizere. Chidziwitso chachinsinsi ndi dzina la mndandanda ndi zomwe zili m'minda yomwe ili pansi pake mu tebulo.
Ngati mugulitsa zinthu ndikuziika mu tebulo ndi zikhomo za ProductName, Price, ndi ProductID, iliyonse ya mutuwo ndi chikhumbo. M'munda uliwonse pansi pa mutuwo, mumalowa maina, mankhwala, ndi zizindikiro za mankhwala, motero. Chimodzi mwazolowera kumunda ndichinthu chokha.
Izi zimakhala zomveka mukamaganizira za izi, popeza kuti kutanthauzira kosagwiritsidwa ntchito mosagwiritsidwa ntchito mosagwirizana ndi chikhalidwe ndikutanthauzira khalidwe kapena khalidwe linalake.
Zizindikiro Zimalongosola Zochitika
Tiyeni tikambirane deta yomwe imayambitsa bizinesi. Zowonjezera zikuphatikizapo magome-omwe amatchedwanso mabungwe opangira malonda-kwa Amalonda, Ogwira Ntchito, ndi Zamagulu, pakati pa ena. Zamagulu tebulo zimatanthauzira maonekedwe a chinthu chilichonse.
Izi zingaphatikizepo chidziwitso cha mankhwala, dzina la mankhwala, chiphaso cha ogulitsa (ogwiritsidwa ntchito monga chinsinsi chachilendo ), kuchuluka, ndi mtengo. Chimodzi mwa zizindikirozi ndi chikhumbo cha tebulo (kapena chigwirizano) chotchedwa Products.
Taganizirani mawu awa kuchokera ku deta ya Northwinds yomwe imatchulidwa kawirikawiri.
| ProductID | Zamalonda | SupplierID | CategoryID | QuantityPerU | Mtengo wagawo |
|---|---|---|---|---|---|
| 1 | Chai | 1 | 1 | Mabokosi 10 x matumba 20 | 18.00 |
| 2 | Kusintha | 1 | 1 | 24 - 12 oz mabotolo | 19.00 |
| 3 | Sirave Yowoneka | 1 | 2 | 12 - 550 ml mabotolo | 10.00 |
| 4 | Mtsinje wa Anton wa Cajun Seasoning | 2 | 2 | 48 - 6 oz mitsuko | 22.00 |
| 5 | Gumbo Mix ya Chef Anton | 2 | 2 | 36 mabokosi | 21.35 |
| 6 | Agogo a Boysenberry Akufalikira | 3 | 2 | 12 - 8 oz mitsuko | 25.00 |
| 7 | Amalonda a Amal Bob's Peanic Zouma | 3 | 7 | 12 - 1 lb pkgs. | 30.00 |
Maina a mndandanda ndizo zikhumbo za mankhwala. Zolembedwera m'minda yazitsulo zimakhalanso ndi zotsatira za mankhwala.
Kodi Zimapereka Munda?
Nthaŵi zina, mawu akuti munda ndi zizindikiro zimagwiritsidwa ntchito mosiyana, ndipo pazinthu zambiri, ndizofanana. Komabe, munda umagwiritsidwa ntchito pofotokozera selo inayake mu tebulo yomwe imapezeka pamzere uliwonse, pamene chiganizo chimagwiritsidwa ntchito pofotokozera chinthu chomwe chimagwirizana ndi kapangidwe kake.
Mwachitsanzo, mu tebulo pamwambapa, ProductName mu mzere wachiwiri ndi Chang . Iyi ndi munda . Ngati mukukambirana za malonda ambiri, ProductName ndilo gawo la mankhwala. Ichi ndicho chikhumbo .
Musamangidwe pa izi. Kawirikawiri, mawu awiriwa amagwiritsidwa ntchito mosiyana.
Kufotokozera Makhalidwe
Zizindikiro zimatanthauzidwa mwazinthu zawo. Malo amodzi akufotokozera zomwe chilolezo chikhoza kukhala nacho. Izi zingaphatikizepo mtundu wake wa deta, kutalika, mfundo, ndi zina.
Mwachitsanzo, madera a chikhalidwe cha ProductID akhoza kufotokozera mtundu wa deta. Chikhumbocho chingathe kufotokozedwa mochuluka kuti chikhale ndi kutalika kwina kapena kuwonetsa ngati chopanda kanthu kapena chosadziwika chiloledwa.