Ma tebulo amatumikira monga chinthu chofunikira cha bungwe kwa deta iliyonse, kuphatikizapo omwe akuyendetsedwa ndi SQL Server 2012 . Kupanga matebulo oyenerera kusungira deta yanu ndi udindo waukulu wa osungirako malonda ndi onse opanga ndi otsogolera ayenera kudziwa bwino njira yopanga matebulo atsopano a SQL Server. M'nkhaniyi, tipenda mwatsatanetsatane.
Tawonani kuti nkhaniyi ikufotokoza njira yopanga matebulo mu Microsoft SQL Server 2012. Ngati mukugwiritsa ntchito SQL Server yosiyana, chonde werengani Kupanga Ma tebulo mu Microsoft SQL Server 2008 kapena Kupanga Masamba mu Microsoft SQL Server 2014.
Gawo 1: Pangani Tebulo Lanu
Musanayambe kuganiza za kukhala pamsakani, tulutsani chofunikira kwambiri chokonzekera chomwe chilipo kwa aliyense wogwiritsa ntchito deta - pensulo ndi pepala. (Chabwino, mumaloledwa kugwiritsa ntchito kompyuta kuti muchite izi ngati mukufuna - Microsoft Visio amapereka zizindikiro zamakono zokongola.)
Tengani nthawi yojambula mapangidwe anu a deta yanu kuti ziphatikizidwe zonse za deta ndi maubwenzi omwe mukufunikira kukwaniritsa malonda anu. Mudzakhala bwino pakutha ngati mutayambitsa ndondomeko yolimba musanayambe kupanga matebulo. Mukamapanga deta yanu, onetsetsani kuti mumaphatikizapo chikhazikitso cha deta kuti mutsogolere ntchito yanu.
Gawo 2: Yambani SQL Server Management Studio
Mukadapanga ndondomeko yanu, ndi nthawi yoyamba kukhazikitsidwa kwenikweni. Njira yosavuta yochitira izi ndi kugwiritsa ntchito SQL Server Management Studio. Pitirizani kutsegula SSMS ndikugwirizanitsa ndi seva yomwe ili ndi deta yomwe mungakonde kupanga tebulo latsopano.
Khwerero 3: Pita ku Folder Yolondola
Pakati pa SSMS, muyenera kupita ku Masalimo a foda yoyenera. Onani kuti fayiloyi kumbali ya kumanzere kwawindo ili ndi foda yotchedwa "Databases". Yambani powonjezera foda iyi. Mukatero mudzawona mafoda omwe ali ndi mauthenga omwe akupezeka pa seva yanu. Lonjezani foda yomwe ikufanana ndi deta yomwe mukufuna kupanga tebulo latsopano.
Pomalizira, yonjezerani mafayibulo omwe ali pansipa. Tengani kamphindi kuti mufufuze mndandanda wa matebulo omwe alipo kale mu deta ndipo onetsetsani kuti zikuwonekera kumvetsa kwanu kwa chikhalidwe chopezekapo. Mukufuna kutsimikiza kuti musapange tebulo lapadera, chifukwa izi zidzakupangitsani mavuto aakulu pamsewu omwe angakhale ovuta kuwongolera.
Gawo 4: Yambani Kulemba Masamba
Dinani pakanema pa Masalimo a fayilo ndikusankha Tsamba Latsopano kuchokera kumasewera apamwamba. Izi zidzatsegula malo atsopano mkati mwa SSMS komwe mungapange tebulo lanu loyamba.
Khwerero 5: Pangani Mizati Zamatabwa
Zojambulajambulazo zimakupatsa iwe ndi galasi lamtundu umodzi kuti uwonetsetse katundu wa tebulo. Pa chikhumbo chirichonse chomwe mukufuna kuchibisa mu tebulo, muyenera kuzindikira:
- Dzina la Phukusi : Izi ndizosavuta, dzina la chikhalidwe. Chidziwitso chilichonse chachinsinsi chikufanana ndi chosinthika; ndi chinthu chimodzi chodziwika kuti deta yanu ikusungira zolemba zonse. Mwachitsanzo, ngati muli ndi tebulo lokhala ndi mauthenga, mukhoza kukhala ndi maina a dzina la FirstName, LastName, HomePhone, ndi EmailAddress omwe ali ndi mbiri yokhudza munthu aliyense mu deta yolumikizana.
- Mtundu wa Deta : Mtundu wa deta umatanthauzira mtundu wa chidziwitso chimene udzasunga m'ndandanda iliyonse. Mwachitsanzo, dzina loyamba la munthu limakhala ndi zingwe zamakalata, kotero mungagwiritse ntchito mtundu wa data wa varchar (50) kuti muwonetsetse kuti chigawocho chidzakhala ndi zingwe zojambulidwa zosasintha zomwe sizinanso kuposa zilembo 50. Mofananamo, tsiku la kubadwa lingagwiritse ntchito tsiku lachidziwitso. Kuti mudziwe zambiri, onani nkhani yathu pa mitundu ya data ya SQL Server.
- Lolani Nulls : Ichi ndi bokosi lokha. Ngati mungawone, deta yanu idzakulolani kuti musungire malingaliro osalongosoka (kapena osalongosoka) muzomwelo. Kuti mudziwe zambiri, onani Kumvetsetsa NULL Malamulo .
Pitirizani kukwaniritsa masanjidwe a grid, ndikupatsani zigawo zitatu zazomwe mukulemba m'ndandanda yanu yatsopano.
Khwerero 6: Dziwani Chofunikira Chachikulu
Kenaka, tchulani ndime (s) zomwe mwasankha pachinsinsi chachikulu cha tebulo lanu. Kenaka dinani chizindikiro chachinsinsi mu taskbar kuti muike chinsinsi chachikulu. Ngati muli ndi fungulo lofunika kwambiri, gwiritsani ntchito CTRL key kuti muike mizere yambiri musanatsegule chithunzi.
Mukachita izi, mndandanda wachinsinsi (s) udzawonetsera chizindikiro chamtengo wapatali kumanzere kwa dzina la mndandanda, monga momwe taonera pa chithunzi pamwambapa. Ngati mukufuna thandizo, mungafune kuwerenga nkhaniyo Kusankha Mutu Waukulu .
Khwerero 7: Tchulani ndi kusunga Gome Lanu
Pambuyo popanga makiyi apamwamba, gwiritsani ntchito chithunzi cha disk mu kachipangizo kuti musunge tebulo lanu ku seva. Mudzafunsidwa kuti mupereke dzina la tebulo lanu mukasunga nthawi yoyamba. Onetsetsani kuti musankhe chinachake chofotokozera chomwe chingathandize ena kumvetsa cholinga cha tebulo.
Ndizo zonse zomwe zilipo. Tikuyamikira pokonza tebulo lanu loyamba la SQL Server!