Zowonjezera makina ndi njira yophweka yopangira malo osungirako zinthu
Monga momwe mukudziwira kale, mazenera amagwiritsira ntchito matebulo kukonza zambiri. (Ngati mulibe chidziwitso chodziwika bwino ndi zida zamasamba, werengani Chidziwitso ndi chiyani? ) Gome lililonse liri ndi mizere yambiri, iliyonse yomwe ikufanana ndi zolemba limodzi. Kotero, zolembazi zimasunga bwanji zolemba zonsezi? Ndi kupyolera mu kugwiritsa ntchito mafungulo.
Zida Zoyamba
Mtundu woyamba wa fungulo limene tikambirane ndichinsinsi chachikulu . Dome lililonse lazamasamba liyenera kukhala ndi timodzi imodzi kapena zingapo zomwe zimasankhidwa ngati chinsinsi chachikulu . Kufunika kwa fungulo ili liyenera kukhala lapadera pa zolembedwa zonse muzenera.
Mwachitsanzo, taganizirani kuti tili ndi tebulo lotchedwa Employees yomwe ili ndi mauthenga ogwira ntchito kwa aliyense wogwira ntchito. Tifunika kusankha chinsinsi chofunikira chomwe chingadziwitse mwapadera wogwira ntchito aliyense. Lingaliro lanu loyamba lingakhale kugwiritsa ntchito dzina la wogwira ntchitoyo. Izi sizikuyenda bwino chifukwa zikutheka kuti mungagule antchito awiri omwe ali ndi dzina lomwelo. Kusankha bwinoko kungakhale kugwiritsa ntchito nambala ya ID yodabwitsa ya antchito yomwe mumapatsa wogwira ntchito aliyense pamene akulembera. Mabungwe ena amasankha kugwiritsa ntchito Social Security Numeri (kapena zizindikiro zofanana za boma) chifukwa cha ntchitoyi chifukwa wogwira ntchito aliyense ali nawo kale ndipo akutsimikiziridwa kuti ndi apadera. Komabe, kugwiritsidwa ntchito kwa Social Security Numeri pachifukwa ichi ndizovuta kwambiri chifukwa cha zofuna zachinsinsi. (Ngati mumagwira ntchito pa bungwe la boma, kugwiritsa ntchito Nambala ya Social Security kungakhale koletsedwa pansi pa lamulo lachinsinsi cha 1974.) Chifukwa cha ichi, mabungwe ambiri asintha kugwiritsa ntchito zizindikiro zapadera (chidziwitso cha ogwira ntchito, chidziwitso cha ophunzira, etc .) zomwe sizigawanitsa zofuna zachinsinsi.
Mutasankha chinsinsi chachikulu ndikukhazikitsa deta yanu, dongosolo la kasamalidwe kazamasamba lidzagwiritsira ntchito mwapadera.
Ngati muyesa kujambula nyimbo mu tebulo ndifungulo loyamba lomwe limagwiritsa ntchito rekodi yomwe ilipo, zolembazo zidzalephera.
Mazinthu ambiri amatha kukhazikitsa mafungulo awo enieni. Microsoft Access, mwachitsanzo, angakonzedwe kuti agwiritse ntchito mtundu wa data wa AutoNumber kuti apange ID yapaderadera pa mbiri iliyonse pa tebulo. Ngakhale zogwira mtima, izi ndizolakwika chifukwa zimakupangitsani kukhala ndi phindu lopanda pake m'kabuku kalikonse kamene kali patebulo. Bwanji osagwiritsa ntchito danga kuti musunge chinthu chofunika?
Zowona Zachilendo
Mtundu winanso ndi fungulo lachilendo , lomwe limagwiritsidwa ntchito popanga mgwirizano pakati pa matebulo. Ubale weniweni ulipo pakati pa matebulo m'magulu ambiri a mabanki. Kubwereranso ku deta yathu ya ogwira ntchito, taganizirani kuti tikufuna kuwonjezera tebulo lokhala ndi deta ku database. Gome latsopanoli likhoza kutchedwa Dipatimenti ndipo likhoza kukhala ndi zambiri zambiri zokhudza dipatimenti yonseyi. Tikufunanso kufotokoza zambiri za ogwira ntchito mu dipatimentiyi, koma zingakhale zovuta kuti tidziwe zomwezo m'mabuku awiri (Ogwira Ntchito ndi Maofesi). M'malo mwake, tikhoza kulumikizana pakati pa matebulo awiriwo.
Tiyeni tiganizire kuti Dipatimentiyi imagwiritsira ntchito gawo la Dipatimenti ya Name monga chinsinsi chachikulu. Kuti tipeze mgwirizano pakati pa matebulo awiriwa, tikuwonjezera ndime yatsopano ku Gome la Achito lotchedwa Dipatimenti. Kenako timadzaza dzina la dipatimenti imene antchito aliyense ali nawo. Timadziwitsiranso dongosolo la kasamalidwe ka deta kuti Dipatimenti ya Dipatimentiyi ikugwiritsidwe ntchito patebulo la ogwira ntchito ndichinsinsi chachilendo chomwe chimagwiritsa ntchito ma tebulo.
Mndandanda wa detawu idzagwirizanitsa umphumphu wowonjezereka mwa kuonetsetsa kuti zonse zomwe zili mu ndondomeko ya Zipatala za Table of Employees zili ndi zolembedwera mu tebulo la Maofesi.
Onani kuti palibe chosemphana chapadera kwa makiyi akunja. Titha (ndipo mwachiwonekere) timakhala ndi antchito angapo omwe ali a dera limodzi. Mofananamo, palibe chofunikira kuti kulowa mu tebulo lazinthu kuli ndi zolembera zofanana ndizomwe amagwira ntchito. N'zotheka kuti tikhale ndi dipatimenti popanda antchito.
Kuti mudziwe zambiri pa mutu umenewu, werengani Kupanga Zowona Zachilendo .