LibreOffice-Suite-Base/C4/Database-Design-Purpose-OrganizeTables/Khasi
From Script | Spoken-Tutorial
| Time | Narration |
| 00:00 | Ngi pdiangsngewbha iaphi sha ka “Spoken tutorial” halor ka “LibreOffice Base”. |
| 00:04 | Ha kane ka jinghikai, ngin ia pule ia kine ki topics harum halor ka database design: |
| 00:09 | * Ban batai ia ka jingthmu jong ka database jong ngi |
| 00:12 | * Ban wad ban pynbit pynbiang ia ka jingtip ba ngi donkam |
| 00:15 | * Phiah ia ka jingtip ha ka tables. |
| 00:19 | Kaei ka “Database Design”? |
| 00:21 | ‘Database design’ kadei ka jingtreikam ban pynmih ia ka data ba bniah jong ka database. |
| 00:28 | Bad ka design kaba biang, ka database ka lah ban |
| 00:32 | Ai ia ka up-to-date, kaba biang thik bad baroh nadong shadong ki jingtip. |
| 00:37 | Kaba mut- ngi lah ban pynthikna ia ka jinglong badei jong ki jingtip jong ngi ha ki levels ba bun. |
| 00:43 | Ban pynbiang ia ka jingdonkam jong ngi ia ka data kaba pyntreikam bad kab report ia ka jingtreikam |
| 00:48 | Bad kaba pynbiang da kaba suk ia ka jaka jong baroh ki jingkylla. |
| 00:51 | Ka jingtreikam jong ka database design ka kynthup ia kine ki steps harum: |
| 00:57 | * Ban batai ia ka jingthmu jong ka database jong ngi |
| 01:00 | * Wad bad pynbit pynbiang ia ka jingtip kaba ngi donkam |
| 01:04 | * Phiah ia ki jingtip ha ka “tables” |
| 01:07 | * Pynkylla ia ka jingtip sha ka “columns” |
| 01:11 | * Pynithuh ia ki “primary keys” |
| 01:14 | * Set up ia ka “table relationship”s |
| 01:17 | * Ban pynbha ia ka design jong ngi |
| 01:20 | * Ban apply ia ka “normalization” rules |
| 01:23 | * Bad khatsuh, test, “run” ia ka database bad pynbit pynbiang. |
| 01:28 | Te, to ngin ia leit sha ka step ba nyngkong kaba dei- |
| 01:32 | Ban batai ia ka jingthmu jong ka database jong ngi. |
| 01:35 | To ngin ia shim ia ka “Library Application” kaba suk. |
| 01:38 | Ka library kumba ju long kadon ia ki books. |
| 01:41 | Bad kine ki kot lah ai sha kito ki member ba lah registered. |
| 01:45 | Te, ngi donkam ia ka “Library application” ban pynbit pynbiang ia ka lis jong ki books bad ki members. |
| 01:51 | Ban track ia ka jingai jong kine ki kot sha ki members jong ka. |
| 01:56 | Ka step kaba nyngkong kadei ban wad bad pynbit pynbiang ia ka jingtip ba ngi donkam. |
| 02:01 | Hangne kadei ba ngi buh lang ia baroh ki jait jong ki jingtip ba ngi kwah ban record ha ka database. |
| 02:09 | Mynta ba ngi tip ia ka jingthmu jong ka ‘Library application’, to ngin ia pynithuh ia ki items hangne. |
| 02:17 | Hangne ki books. |
| 02:19 | Ka “Book” kadon ia ka “title”, u “author”, u “publisher” bad ka “price”. |
| 02:24 | Bad ngi lah ruh ban buh ia ki jingtip jong ki nongthoh kum ka, sngi kha bad ka ri kaba ma u lane ma ka ki dei. |
| 02:33 | Ngi lah ruh ban buh ia ka kyrteng jong ki nongpynmih, ka jaka sah bad phone. |
| 02:38 | Bad ruh, ki don ki ‘Library’ member kiba don ia ka kyrteng, phone number bad ka jaka sah. |
| 02:45 | Mynta mynba ka kot bal ah ai sha ki member, kadon ia ka- |
| 02:49 | Tarik ba lah ai ka kot, ka tarik ba pynphai, ka tarik ba shisha ba pynphai bad ka checked-in status. |
| 02:56 | Kine ki items ba marwei la khot ruh ki “attribute”s. |
| 03:01 | Man kine ki jnit ki jnat la mih bujli da ka “column” ba biang ha ka “table”. |
| 03:08 | Ha kane kapor, ngi lah ban shna ia ki jingkylli kiba kum ka: |
| 03:12 | Kumno ngi pyndap ia ki jingtip shaphang ka set jong ki books ba dang shu poi ba la phah sha ka Library da u publisher? |
| 03:20 | Kumno ngi pynbit pynbiang ia ka lis jong ki member jong ka? |
| 03:25 | Kan jia kumno lada u member u ieh noh lane u member u kwah ban pynkylla ia ka jaka sah jong u/ka? |
| 03:32 | Kumno ngi update ia kane ka jingtip lada ka book la pynphai da u member? |
| 03:38 | Ki jait “report”s kiba kumno ba ngi kwah ba ngin pynmih? |
| 03:42 | Kino ki books kiba kham pule bha hapdeng ki nongpule? |
| 03:46 | Bad kumno ngi pynmih ia ki lis jong ki books kiba lah dei ban pynphai da ki members kiba lah shim ia ki? |
| 03:55 | Mynta ba ngi don katto katne ki jingtip ba bniah, ngin ia peit kumno ngi lah ban phiah ia kine ki jingtip ha ki tables. |
| 04:02 | Ngin ia phiah ia kine ki item jong ki jingtip jong ngi lane ki jnit ki jnat ha ka rukom kaba bha tam lane ki subjects. |
| 04:11 | Man ki subject ki kylla long ki table. |
| 04:14 | Te, ka jingsdang jong ka lis jong ki tables ki long kum ka dur ba la pyni ha kane ka screen. |
| 04:21 | Ka major subjects lane “entities” kiba pyni hangne kidei ki books bad ki members. |
| 04:26 | Te kumta, ka long kaba sngewthuh ban sdang ia ki da ar tylli ki tables, kawei na ka bynta ki books bad kawei na ka bynta ki members. |
| 04:33 | To mynta ngin ia peit ha ka “Books” table ha ka rukom ba bniah. |
| 04:37 | Kadon 10 tylli ki jnit ki jnat lane ki column kiba ngi lah batai shakhmat: |
| 04:43 | Title, Author, Publisher, PublisherAddress, PublisherCity, PublisherPhone, PublishYear, Price, AuthorBirthDate bad AuthorCountry. |
| 04:58 | Mynta, ngin ia peit kumno kine ki data ki pyni ha ka table. |
| 05:03 | Phin iohi ba man ki row lane ki “record” kidon ia ki jingtip shaphang ka book, u nongthoh jong ka bad ia u nongpynmih jong ka. |
| 05:13 | Mynta, don ar tylli ki jingduna ha kane ka design. |
| 05:17 | Lah ban don shibun ki books da ujuh u nongthoh lane u nongpynmih. |
| 05:23 | Te, ngi iohi ba ki jingtip ba bniah jong u nongthoh bad u nongpynmih lah ban thoh bunsien |
| 05:31 | Kaba pynlut kai ia ka jaka jong ka computer disk. |
| 05:34 | Bad ka jingduna ba ar ha kane ka design kadei: |
| 05:38 | Ka run ia ka risk ba ka pynithuh ia ka data ba phyla hapoh ka database. |
| 05:44 | Mynta, kaaei ka “anomaly”? |
| 05:47 | Kadei tang ka jingbakle lane ka jingbym iaid beit hapoh ka database. |
| 05:53 | Kidon lai tylli ki jait jong ki anomalies: |
| 05:57 | Kaba nyngkong la khot ka “insertion anomaly” |
| 06:01 | Kaba lah ban mih ne paw lada la record ba thymmai la thep. |
| 06:06 | Lane, lada katto katne ki jnit ki jnat kim lah ban thep hapoh jong ka database khlem da don ia ki jnit ki jnat jong kiwei pat. |
| 06:14 | Kum ka nuksa, ngin shim ba kadon kawei ka “Publisher” ba thymmai kaba khot ka ‘Penguin’. |
| 06:21 | Mynta, ka design jong ngi kam shah ia ngi ban thep ia kine ki jingtip ba bniah jong ka Penguins publisher haduh ba ka library jong ngi kan da ioh la kumno kumno kawei ka kot bal ah published da ma ki. |
| 06:34 | Kaba ar kadei ka “deletion anomaly” |
| 06:39 | Kaba mih bad paw haba ngi pyndam ia ka record. |
| 06:43 | Hangne, ka jingpyndam ia ka “row” lane “record” ha ka database ka pyndam bun ki jingtip ban ia kaba ngi kwah ba kan pyndam. |
| 06:51 | Kum ka nuksa, ngi iohi ba ka ‘Orient Publishers’ kidon tang ia kawei ka kot ba kyrteng ka ‘Paradise Lost’, ha ka library. |
| 07:01 | Mynta, lada ngi pyndam ia kane baroh kawei ka record te ngi duh ia baroh ki jingtip jong ka Orient Publishers. |
| 07:10 | Bad ngi duh ia ki jingtip shaphang u author John Milton ruh kumjuh. |
| 07:16 | Bad khatduh, to ngin ia peit kaei ka “Update Anomaly”. |
| 07:21 | Ka mih bad paw haba ngi update ia ka record. |
| 07:26 | Kum ka nuksa, to ngin shim ba ka Cambridge Publisher kadon ia ka address ba thymmai. |
| 07:32 | Mynta, ban update ia kane ka “Address” column na ka bynta “Publisher” ka donkam ia ngi ban pynkylla ha bun tylli ki jaka. |
| 07:40 | Ha kane ka case jong ngi, ar tylli ki jaka. |
| 07:43 | Bad lada, ka Cambridge ka phah shi hajar tylli ki books te kamut, ngi donkam ban pynkylla ia ka address ha shi hajar ki records. |
| 07:54 | Bad jia ryngkhat ngi lah ban bakla ha kaba pynkylla ia ka address ha kawei ka jaka hynrei ngi klet ban pynkylla ha kiwei pat ki jaka. |
| 08:02 | Te, kane ka lah ban ialam ia ngi sha ka jingtip bym biang bad da kumta ngi duh ia ka “data integrity”. |
| 08:11 | Kumno ngin ia pynbiang ia kane ka jingeh? |
| 08:14 | Ngi hap ban design sha shisien khnang ba ngin record man ka jingtip ha ka shisien leh. |
| 08:20 | Lada kajuh ka jingtip ka wan biang palat ban ia ka shi jaka te ngi donkam ban buh ia kane ka jingtip ha kawei pat ka “table”. |
| 08:29 | To ngin ia peit kumno. |
| 08:31 | Mynta ngi hap ban phiah ia ka “Books” table ha ka “Bookd Authors” bad “Publisher” |
| 08:38 | Phin iohi ba ki columns ha man ki table ki buh ia ki jingtip ba shisha shaphang ki “entity” lane tang ki subject. |
| 08:47 | Ha kane ka rukom, ngi lah ban record ia ka jingtip jong ki publisher tang shisien hapoh ka “Publisher” table. |
| 08:55 | Ha kajuh ka rukom, ban don la kajong ka “Authors” table ka ailad ban record ia ka jingtip jong ki author tang shisien. |
| 09:04 | Bad ngin ia peit kumno ngi lah ban pyniasnoh ia kine ki tables ha ka “Books” table ha ka jinghikai kaba bud. |
| 09:12 | Da kane ngi la poi sha kaba kut jong kane ka jinghikai ha ka bynta ba nyngkong jong ka “Database Design” ha ka “LibreOffice”. |
| 09:19 | Ban kyllung lang, ngi lah pule ia kine ki topics harum ha ka database design: |
| 09:25 | * Ban batai ia ka jingthmu jong ka database jong ngi |
| 09:28 | *Ban wad bad pynbit pynbiang ia ka jingtip ba ngi donkam |
| 09:32 | *Ban phiah ia ka jingtip ha ki tables. |
| 09:36 | “Spoken Tutorial” project kadei shi bynta jong ka “Talk to a Teacher” project, la kyrshan ia ka da ka National Mission on Education lyngba ka ICT, MHRD, Sorkar India. |
| 09:48 | Ia kane ka project la pynbit pynbiang da ka http://spoken-tutorial.org. |
| 09:54 | Kham bun ki jingtip halor kane kidon ha ka link harum. |
| 09:58 | nga dei U Pdiangburom na Shillong nga pynkut ia kane.
Khublei shibun ia ka jingiasnoh kti lang jong phi. |
