LibreOffice-Suite-Base/C2/Introduction/Khasi

Time	Narration
00:00	Ngi pdiangsngewbha iaphi sha ka “Spoken tutorial” halor ka “LibreOffice Base”.
00:04	Ha kane ka jinghikai, ngin pule shaphang *Kaei ka LibreOffice Base?
00:09	* Ki jingdonkam ban tip hashwa ban pyndonkam ia ka Base
00:12	* Kaei kaba phi lah ban leh bad ka Base?
00:14	* Ki Relational Database ba donkam, ban shna ia ka database ba thymmai, ban shna ia ka table.
00:20	Ka “LibreOffice Base” kadei ka “Front-end” database jong ka “LibreOffice suite”.
00:26	“Base” ka ia syriem kum ka “Microsoft Access”.
00:30	“Base” kadei ka software ba lah ban ioh ei bad suk ban ioh, khlem da siew bad ioh ei ban pyndonkam bad sam sha kiwei.
00:37	To ngin ia peit ia ki jingtip ba donkam hashwa ban pyndonkam ia ka “Base”
00:41	Kine harum kilong ki jingdonkam jong ka System na ka bynta ka Microsoft Windows:
00:45	“Microsoft Window 2000” (Service Pack 4 lane kaba kham shajrong), “XP, Vista” lane “Windows 7”, ki PC ba iahap bad ka Pentium ryngkat bad 1.5 GB hard disk.
01:02	Na ka bynta ka “Ubuntu Linux”, kine kilong ki jingdonkam jong ka System:
01:06	“Linux kernel” bershon “2.6.18” lane kham shajrong, ki PC ba iahap bad ka Pentium.
01:13	Na ka bynta ban install ia ka Windows bad Linux, ngi donkam 256 Mb u RAM (512 Mb kadei kaba lah ai jingmut).
01:24	Na ka bynta baroh ki jingtip shaphang ki jingdonkam jong ka System, leit sha ka “LibreOffice” website.
01:30	Phin sa donkam ruh ban install ia ka “Java Runtime Environment” ia kaba phi lah ban download na kane ka link harum.
01:38	Nion ha u button ba saw hapdeng kaba ong ‘Free Java Download’.
01:44	Shisien ba ka file ka lah dep download, nion arsien ha ka bad sa bud ia ki jingbatai kumno ban install.
01:52	To mynta ngin ia peit ia ka rukom install jong ka “LibreOffice Base”:
01:56	Lada phi lah dep install lypa ia ka ‘LibreOffice Suite’ da ka opshon “Complete installation”
02:03	Te phin sa lah ban pyndonkam ia ka LibreOffice Base da kaba phi nion ha u “Start” menu ha trai kadiang jong ka screen.
02:12	Nion ha “All Programs” nangta sa nion ha “LibreOffice Suite”.
02:21	Lada phim pat install ia ka LibreOffice Suite.
02:24	Phi lah ban install ia ka “Base” da kaba phi leit sha ka website badei bad nion ha ka jaka ba jyrngam kaba ong ‘Download LibreOffice’.
02:37	Ki jinghikai kiba bniah kidon ha ka jinghikai ba nyngkong jong ka “LibreOffice Suite”.
02:43	Kynmaw, lada phi install, pyndonkam da ka “Complete” opshon ban install ia ka ‘Base’.
02:50	To, ngin ia leit noh sha kawei pat ka phang mynta.
02:54	Kaei kaba phi lah ban leh bad ka “LibreOffice Base”?
02:57	Bad ka Base - *phi lah ban buh ia ki data kiba lah buh ryntih
03:02	* Ban pyndap ia ki data bad peit ia ki da kaba pyndonkam ia ki forms
03:08	* Ban sei ia ki jingtip da kaba pyndonkam ia ki jingkylli bad
03:12	* Pynwandur bad pynmih ia ki “report” kiba itynnad, bad kiba lah ban biang ban print.
03:17	Ka “Base” ia iarap iaphi ban pynbit pynbiang ia ki database.
03:21	Kumba phi tip, ba ka database kadei ka kynhun jong ki “data, forms, queries” bad ki “report”.
03:29	Kum ka nuksa, ‘Base’ lah ban pyndonkam ban pynbit pynbiang ia ki “Customer Information database”,
03:36	Ban khmih ia ki “sales order” bad “invoice”, ban buh ia ki grade database jong ki khynnah lane shna ia ka “library” database.
03:47	To mynta ngin ia pule katto katne ki jingtip ba donkam eh jong ka database.
03:51	Ka database kadon ia ki data ba lah buh ryntih ha ki “table”.
03:56	Ki “table” kidon iwei iwei i bynta jong ka data, kaba lah buh ha ki row bad ki column.
04:03	Kum kine ki database la khot ruh ki “relational database” ha kaba ki table kidon ia ki “relationship” hapdeng jong ki da kaba pyndonkam ia ki column.
04:15	To ngin peit ia ka database kaba suk na ka bynta ka “Library”.
04:20	Ka “library” ka lah ban long ka jingbuh kynshew ia ki “Books”.
04:23	Bad ki kot ki lah ban long ki “members” jong ka library.
04:28	Ka kot ka lah ban don ia ka “Title” , u “Author”, u “Publisher”, u snem ba lah pynmih bad ka “Price”.
04:37	Ia kine la khot kita ki jnit ki jnat lane ki “attribute”.
04:42	Ha kajuh ka rukom, ki library member kidon ia ka “Name, Phone number” bad ka “Address”.
04:48	Bad ka “library” ka ai ia ki kot tang sha ki “member” jong ka.
04:54	Mynta, to ngin peit kumno ngin buh ia kine ki data iwei iwei kum ki “Table” jong ki “row” bad “column”.
05:02	Ki jingtip jong man ki kot lah ban buh ha ka “Books” table,
05:08	Ryngkat bad ki jnit ki jnat la pynlong ia ki column: ka “Title, Author, Publisher, Year of Publication” bad “Price” jong ka kot.
05:19	Ban pyniapher ia man kawei pa kawei ka kot, to ngin pyndap ia u jingpynithuh ba kyrpang ba la khot “BookId”.
05:27	Ha kane ka rukom, ngi lah ban don ia ar tylli ki kot kiba iapher da ka juh ka kyrteng.
05:33	Kumjuh, ka “Members” table ka lah ban don ia ki column kum “Name” bad “Phone”
05:40	Bad ia u “Member Id” ban pynithuh kyrpang lane pyniapher ia man uwei pa uwei u member. <pause>
05:47	Bad ngi lah ban khmih ia ki kot ba la ai ia ki member ha ka table kaba lai ba la khot “BookIssued”.
05:56	Kane ka table kan khmih ia ka kot ba la ai, ki member, ka tarik ba ai, ka tarik ba pynphai, ka tarik ba shisha ba pynphai, lada lah thep ne em.
06:09	Ngi lah ban shna ia ki “relationship” hapdeng kine ki table, ban pyniajan bad pyniadei ia ki data hapdeng jong ki.
06:16	Mynta, kane ka iarap ia ngi ha kaban pynbit pynbiang ia ki “relational database”.
06:22	Na ka bynta ka mat kaba kham janai halor kane ka relational database, peit ia ki jinghikai jong ngi da kaba phi leit sha ka website “Spoken tutorial.org”.
06:35	Te, mynta to ngin sdang ia ka “Base” ba nyngkong jong ngi kaba kyrteng “Library”!
06:43	Ban shna ia ka databse ba thymmai, to ngin plie shwa ia ka “Base” program.
06:50	Nangta, nion ha ka “Windows” “Start” menu ha trai kadiang jong ka screen. Nangta nion ha “All Programs”, nangta “LibreOffice Suite” bad “LibreOffice Base”.
07:08	Ka “pop-up window” kaba kyrteng “Database Wizard” ka plie.
07:13	Nion ha u “Next” button ban shna ia ka database ba thymmai.
07:19	Nion ha u “Finish” button ha ka “window” kaba bud.
07:23	Kane ka plie ia ka “Save As” window.
07:27	Namar ba ngi shna ia ka “Library database”, ngin type “Library” ha ka “File Name” text-box.
07:35	Bad nangta sa nion ha u “Save” button.
07:39	Mynta, ngi don hangne.
07:42	Nangta pat, to ngin shna ia ki table ban buh ia ki data.
07:46	Ban shna ia ka table ba thymmai, nion ha u “Tables” icon ha ka “Database” list ha ka liang ka diang.
07:54	Nion ha ka “Create Table in Design View” ha ka “Tasks” list ha ka liang kamon. Kane kan plie ia kawei ka window.
08:05	Hangne, type “BookId” ha ka column ba nyngkong hapoh ka “Field Name”.
08:13	Pyndonkam ia u “Tab” key ban leit sha ka “Field Type” column.
08:18	Namar ba ka “BookId” kan iapher bad kiwei ki number jong man ki kot, jied “Integer” kum ka “Field Type” napoh ka drop-down lis.
08:32	Pynkylla ia ka “Field Properties” ha ka section ba hapoh.
08:36	Pynkylla ia ka “AutoValue” na ka “No” sha “Yes”.
08:41	Kane ka jaka mynta kan pynithuh kyrpang ia man ki kot.
08:46	Ngi lah ban ong ruh, kane ka jaka la khot ka “Primary Key”.
08:52	Phin iohi ia u key ba stem u symbol ba sha ka diang jong ka jaka “BookId”.
08:58	To ngin peit kumno ngi lah ban jied ia ka “Field Types” na ka bynta ka “Field names”.
09:05	Field types ki lah ban long ki “text, integer, numeric, decimal” lane “date”.
09:13	Pyndonkam ia ka “Text” na ka bynta ka jaka badon ki jingtip kyllum, kum ka nuksa- “name, title, address”.
09:22	Pyndonkam ia “integer, numeric, decimal” na ka bynta ka jaka kiba lah ban don tang ki numbar.
09:30	Kum ka nuksa- pyndonkam “numeric” na ka bynta ka jaka ba dei bad ka dor, “Integer” na ka bynta ki snem.
09:39	To ngin shna mynta ia ki “field” kiba sah.
09:43	Title- Field type: Text, Author-
09:52	Field type: Text, Published Year-
09:59	Field type: Integer,
10:05	Publisher-
10:09	Field type: Text,
10:11	Price-
10:14	Field type: Numeric.
10:18	Pynkylla ia ka “Length” sha “5” bad “Decimal places” sha “2”.
10:25	Nion ha u “Format example” button.
10:29	Kane kan plie ia ka “Field Format” window.
10:33	Jied “Currency” na ka “Category” lis bad “INR” na ka “Format” lis.
10:42	To ngin jied Rs. 1234.00 kaba don ar tylli ki jaka decimal.
10:54	Phin iohi ba ka jingjrong baroh kalong san, kynthup ia ar tylli ki jaka decimal.
11:02	Nion ha u “OK” button. Mynta ngi lah shna ia baroh ki colums na ka bynta ka “Books” table.
11:11	To mynta ngin “save” ia ka table.
11:14	Nion ha u “Save” icon uba don hapoh jong u “File” menu.
11:20	Type “Books” ha ka “Table Name” text-box.
11:25	Kynmaw ba ka lah save ha kajuh ka jaka bad ka “Library” database, namar ba ki table kidei ki bynta jong ka database.
11:36	Bad nion ha u “OK” button.
11:39	Ha ka jinghikai kaba bud, ngin pyndap ia ki data ha ka “Books” table bad shna ia ka “Members” bad “BookIssued” tables.
11:50	Da kane ngi lah poi sha kaba kut jong kane ka jinghikai.
11:54	Ban kyllum lang, ngi lah pule ia kine harum:
11:58	* Kaei ka LibreOffice Base?
12:01	* Ki jingdonkam ban tip hashwa ban pyndonkam ia ka Base.
12:03	* Kaei kaba phi lah ban leh bad ka Base? ‘Relational Database ba donkam.
12:08	* Ban shna database ba thymmai, ban shna ia ka table.
12:13	Ka jinghikai kaba bud ha kane ka series kadei ka “Tables and Relationships”.
12:18	Ka “Spoken Tutorial” project kadei shi bynta jong ka “Talk to a Teacher” project,
12:24	La kyrshan ia ka da ka National Mission on Education lyngba ka ICT, MHRD, Sorkar India.
12:32	Ia kane ka project lah pynbit pynbiang da ka Spoken Tutorial.org http://spoken-tutorial.org.
12:38	Kham bun ki jingtip halor kane kidon ha ka link ba la ai harum.
12:44	Ma nga u Pdiangburom na Shillong nga pynkut ia kane. Khublei shibun.

Contributors and Content Editors

Pdiangburom, Pratik kamble