LibreOffice-Suite-Base/C2/Tables-and-Relationships/Khasi

Time	Narration
00:00	Ngi pdiangsngewbha iaphi sha ka “Spoken tutorial” halor ka “LibreOffice Base”
00:04	Ha kane ka jinghikai, ngin ia peit shaphang ki “Tables” bad “Relationships” ha ka “LibreOffice Base”.
00:10	Hangne, ngin pule shaphang: *ban pyndap ia ki data ha ka “Table”
00:16	* Ban batai bad shna ia ki jingiadei lane “relationship”.
00:19	Ha ka jinghikai kaba ha shwa jong ka “LibreOffice Base”, ngi lah batai shaphang ka Base, ki jingdonkam ba kongsan jong ka database bad pule shaphang kumno ban shna ia ka database bad ka table.
00:31	Hapdeng jong ka jinghikai, ngi lah shna ruh ia ki nuksa jong ka database kaba ngi khot ka “Library” bad shna ruh ia ka “Books’ table”.
00:42	Ha kane ka jinghikai, ngin ia peit biang ia ka “Library” database bad pule kumno ban pyndap ia ki data ha ka table.
00:51	Na ka bynta kane, to ngin leh da ka “LibreOffice Base” program.
00:57	Na ka bynta kane, ngin nion ha u “Start” button ha trai kadiang jong ka screen,
01:03	Nion ha “All programs”, nangta nion ha “LibreOffice Suite” bad “LibreOffice Base”.
01:12	Namar ba ngi lah shna lypa ia ka ‘Library’ database ha ka jinghikai kaba hashwa, mynta ngi donkam tang ban plie beit noh ia ka.
01:21	Ban leh ia kane, to ngin nion ha ka “open an existing database file” opshon.
01:28	Ha ka “Recently Used” drop-down box, ka ‘Library’ database jong ngi kadei ban iohi.
01:35	Te mynta, nion ha u “Finish” button.
01:38	Lada phim iohi ia ka, ngi lah ban nion ha u “Open” button hapdeng ban it hapoh ha “Windows” directory ha kaba ka ‘Library database’ kadon.
01:50	Shisien ba la lap, nion ha ka filename bad nion ha u “Open” button.
01:57	Mynta, lada ka ‘LibreOffice Base’ program ka la plie lypa, ngi lah ban plie ia ka ‘Library database’ nangne.
02:07	Da kaba nion ha u “File” menu hajrong bad nion “Open”.
02:14	Ngi lah ban it ia ka Windows directory ha kaba ka ‘Library database file kadon.
02:21	To ngin nion ha ka file ‘Library.odb’ bad nion ha u “Open” button ha trai.
02:31	Mynta ngi don ha ka “Library Database”.
02:35	To ngin nion ha u “Tables” icon ha ka “Database” lis ha ka panel ba sha kadiang.
02:42	Phin iohi ba ka “Books” table kapaw ha ka “Tables” lis ha ka panel ba sha kamon.
02:48	Mynta to ngin nion sha kamon jong u mouse ha ka “Books” table.
02:53	Phin iohi ia bun ki opshon kiba phi lah ban jied nangne.
02:58	To mynta ngin nion “Open” ban pyndap ia ki data ha kane ka table.
03:04	Da kawei pat ka rukom, ngi lah ruh ban nion arsien ha ka kyrteng jong ka table ban plie ia ka.
03:10	Ka “window” ba thymmai ka plie ryngkat bad ka kyrteng “Books –Library-LibreOffice Base: Table Data View”.
03:20	Mynta ngi lah ban sdang ban pyndap ia ki data ha ka “Books” table da kaba type beit beit ia ki value haman ki “cell”
03:31	Phin iohi ba ka “Bookid” column kadon ‘AutoField’.
03:37	Kane kamut ba ka “Base” kan sa pyndap hi ia ki numbar shajrong haman ki row jong ka data kaba ngi thep.
03:48	Mynta, to ngin buh ia ki data hapoh ki “cell” kawei kawei ka row, kumba la pyni ha ka screen.
04:22	Te, hangne ngi don 5 tylli ki row jong ki data ba la pyni kum ka nuksa hapoh ka “table” ‘Books’ jong ngi.
04:29	To ngin khang ia ka window da kaba nion ha u “File” menu hajrong bad nangnta jied “Close”.
04:39	Hangne ki kam na ka bynta jong phi.
04:42	Shna ia ka “Members” table ka ban buh ia ki jingtip jong baroh ki member, kum ka nuksa- kyrteng jong ki member’ bad phone numbar.
04:53	Kynthup lang ia kine ki lai tylli ki bynta harum.
04:57	“Member Id” bad ka “Field type-Integer” bad pynlong ia kane ka “primary key”
05:06	“Name” bad ka “Fieldtype-Text”,
05:10	“Phone” bad ka “Fieldtype-Text”.
05:15	Te, da phi la dep, ka “Members” table kan sa long ha kane ka rukom.
05:22	To ngin khang ia ka window.
05:25	Mynta kum ka nuksa to ngin pyndap 4 ngut ki member hapoh ka “Members” table kumba lah pyni ha ka screen.
05:35	Kumba ngi leh na ka bynta ka Books table. <pause 10 seconds)
05:46	Da lah dep, to ngin khang noh ia ka window.
05:50	Mynta, to ngin phai biang sha ka window kaba nyngkong bad sa nion biang ha u “Tables” icon.
05:57	Bad to ngin shna ia ka table kaba lai: “Books Issued”.
06:04	Da lah dep, ka “Books Issued” table kan don ia kine ki bynta harum:
06:09	“Issued Id, Field type Integer” ka ban dei ka “primary key”,
06:16	Book Id, Field type-Integer,
06:20	Member Id, Field type-Integer,
06:24	Issue Date, Field type- Date,
06:28	Return Date, Field type-Date,
06:31	Actual Return Date, Field type- Date,
06:35	Bad Checked In, Field type- Yes/No Boolean.
06:42	Te, ngi la dep shna ia ka “Books Issued” table.
06:47	Bad mynta, to ngin pyndap ia kine ki nuksa jong ki data hapoh jong ka kumba phi iohi ha ka screen.
06:56	Ia mynta kane kam i long kaba i don jingmut, hynrei shen ngin sa sngewthuh ia kaei kaba jia.
07:17	Mynta, ngi don 3 tylli ki table ha ka Library database jong ngi ryngat bad ki nuksa jong ka data ruh.
07:25	To mynta ngin pule shaphang ka jingbatai ia ka “relationships” ha ka database.
07:31	Te, ngi lah dep shna ia lai tylli ki table ban buh ia lai jait ki jingtip.
07:38	“Books, Members” bad ka jingai ia ki Books sha ki Member.
07:44	Mynta ngi lah buh ruh ia ki column ban pynithuh kyrpang ia man ki kot, man ki member bad man ki kot ba la ai ha kine ki lai tylli ki table.
07:57	Kine kidei ki “Primary Key”.
08:00	Kawei na ki jingmyntoi jong ka “primary key” kadei ba ka iarap ban buh ia ka jingiadei bad iajan hapdeng ki table.
08:10	Hynrei balei ngi donkam ia kata ka jingiadei?
08:13	To ngin peit ia ka “Books Issued” table. Hangne, ngi iohi ia ka bynta “Bood-Id” bad “Member-Id”.
08:23	Ki lah ban don ia kino kino ki value ha ka “Books Issued” table.
08:28	Hynrei ki donkam ban don ia kijuh ki value kumba ngi don lang ha ki “Books” bad “Member” table.
08:38	Te lada ka kot, Macbeth, kadon ia ka ‘Book Id’ kum 3 ha ka ‘Books’ table
08:45	Te da kaba pyndonkam 3 ha ka ‘Book Id’ jong ka ‘Books Issued’ table, ngi dang lah ban pyniadei ia kajuh ka kot.
08:56	Te, ban pynjan shuh shuh ia kine ar tylli ki table, ngi dang donkam ban pyniadei ia ki ha kawei ruh ka rukom.
09:05	Kum ka nuksa- kumno phin ong ba ka ‘Macbeth’ la ai sha u Ravi Kumar ha ka 2nd tarik u June 2011?
09:16	Lane kumno phin pynthina ba ka kot la ai tang sha ki member jong ka library ym dei sha kiwei pat?
09:25	Kine baroh lah ban pynurlong da kaba buh ia ka jingiadei ba kan iarap ban pyniadei bad iajan ia ki data.
09:34	Ngi donkam ban banjur ia ka “Base” ban pyndonkam tang ia ki value na ka ‘Books’ table bad ‘Member’ table, da kaba pyniadei ia ki jaka kiba iahap.
09:46	To ngin iapeit kumno.
09:48	Ha ka window ba nyngkong jong ka ‘LibreOffice Base’, ngin nion “Tools” bad nangta nion “Relationships”
09:58	Kane kan plie ia iwei i pop-up window ba rit.
10:03	Hangne, ngin jied ia ka “table” ba hajrong duh bad nion ha u “Add” button bad ngin leh lang kumjuh ia ar tylli ki table ruh.
10:15	Khang ia ka pop-up window.
10:18	Mynta ngi iohi ba lai tylli ki table “Books, Books Issued” bad “Members” kidon ha u lain.
10:26	Da kaba nion, tan bad pynhap, to ngin pynithuh shuh shuh sa ia kiwei ki jaka hapoh ki table.
10:35	Mynta, to ngin nion ha ka “Book-Id” bad ha ka “Books” table bad tan bad pynhap ia ka ha ka “Book Id” ha ka “Books Issued” table.
10:48	Phin iohi ia u lain u pyniasnoh ia kine ar tylli ki kyrteng jong ki bynta. Te nangne, ngi lah shna ia kawei ka relationship!
10:57	To ngin leh kumjuh ia kane na ka bynta ka “Member-Id”
11:02	Nion ha u “Member-Id” ha ka “Members” table bad sa tan bad pynhap ia ka ha ka “Books Issued”
11:11	Phi lah ban iohi ba ngi lah shna ia ar tylli ki relatiohship.
11:16	Bad, da kane ngi iohi kumno ban shna ia ki relationship.
11:20	Bad kumne ngi pyniadei bad pyniajan ia ki data kiba donkam kiba ngi buh ha ki table kiba bun jait ha ka “relational database”.
11:30	Da kane ngi lah poi sha kaba kut jong kane ka jinghikai halor ka “Tables and Relationships in LibreOffice”.
11:36	Ban kyllum lang, ngi la pule kumno ban: pyndap ia ki data hapoh ka table, ban batai bad shna ia ka relationships.
11:45	“Spoken Tutorail” project kadei shi bynta jong ka “Talk to a Teacher” project, la kyrshan da ka National Missoin on Education lyngba ka ICT, MHRD, Sorkar India.
11:57	Ia kane ka project la pynbit pynbiang da ka http://spoken-tutorial.org.
12:03	Kham bun ki jingtip halor kine ki don ha ka link harum.
12:08	Ma nga u Pdiangburom na Shillong nga pynkut ia kane. Khublei shibun ia ka jingsnoh kti jong phi.

Contributors and Content Editors

Pdiangburom