LibreOffice-Suite-Base/C4/Design-Refine-Database-Design-and-Normalization-Rules/Khasi

Time	Narration
00:02	Ngi pdiangsngewbha ia phi sha ka Spoken tutorial halor ka LibreOffice Base.
00:06	Kane ka jinghikai kadei kaba bteng na ka jinghikai ba hashwa halor ka Database Design.
00:11	Bad ngin pule ia kine ki phang hangne:
00:15	7. Ban refine ia ka database design
00:18	8. Ban pyntreikam ia ki kyndon normalization
00:21	9. Test ia ka database design.
00:25	Ha ka jinghikai ba hashwa, ngi la pule kumno ban set up ia ki primary keys bad foreign keys ban shna ia ka table relationships.
00:34	Mynta to ngin ia bteng bad ka jingtreikam jong ka 'database design'.
00:38	Nyngkong ngin refine ia ka database design jong ngi.
00:42	Mynta ngi don ia ka design ba nyngkong, ngi lah ban shna bad pyndap ia ki tables da ka sample data.
00:50	Ngi lah ban shna lane create ia ki samplequeries, forms badreports bad peit lada baroh ki jingkylli jong ngi ba hashwa la dep jubab ne em.
00:59	Ngi lah ban check na ka bynta ki duplications bym donkam bad weng noh ia ki da kaba pynkylla ia ka design.
01:06	Ngi lah ban pyndap columns kiba lehse ngi la klet.
01:10	Bad ruh, ngi lah ban kynthup Business rules sha ka Library database ban pynlong Database Integrity.
01:19	Kum ka nuksa, ka Price column ha ka Books table kadei ban dei da u nombar.
01:24	Kawei pat ka kyndon ba donkam kadei: ka Return Date kadei ban dei shibnai hadien ka tarik ba la issue ia ka kot.
01:32	Lane, lada ka jingdonkam ka wan ngi hap ban leh noh khlem da ap.
01:39	Te , lada ka tarik ban pynphai ia ka kot ka la dei, te ngi dei ban buh ia ki actions lane ki kam ha ka database ban phah email kum ka jingpynkynmaw sha ki member
01:50	Te, kumba ngi pynwandur, ngi lah ban pynmih- ki tables, columns , ki rules lane constraints ba thymmai.
01:58	Bad ngi hap ban phai sha baroh ki steps ba hashwa ban pynthikna ba ka Data Integrity kam pat jah.
02:07	Nangta, ngi lah ban pyntreikam ia ki normalization rules.
02:13	Kine la ju pyndonkam ban peit la ki tables jong ngi kidei:
02:17	a) Ba la pynbeit ryntih ha ka rukom badei
02:20	b) Lait na kino kino ki modification“anomalies” kiba ngi la iohi hashwa
02:25	Ka rukom ban pyntreikam ia ki kyndon lane normal forms sha ka database design la khot normalization.
02:33	To ngin peit ia ki lai tylli ki Normal forms ha ka jinghikai jong ngi.
02:38	To ngin peit nyngkong ia ka First Normal Form. 'First Normal Form' lane 1NF ka ong ba baroh ki kolum values kidei ban dei atomic.
02:51	Kum ka nuksa, man ka cell ha ka Price column ha ka Books table kidei ban don tang uwei u value.
02:59	Kaba mut, ka kolum kadei ban don tang ia ka dor jong kata ka kot bad ym dei kiwei kiwei pat.
03:07	Kumjuh ruh, man ka First Name cell ha ka Authors table kadei ban don tang kawei ka kyrteng jong u author.
03:16	First Normal form ka ong ruh ba kam don ka kynhun ki kolum kiba repeat
03:23	Kum ka nuksa, ngin ia shim ba u Publisher u la publish 3 tylli ki kot
03:29	Bad ka Publishers table kadon ia kine ki kolum harum:
03:34	Publisher Id, Publisher, Book1, Author 1, Book 2, Author 2, Book 3, Author 3.
03:47	Phin iohi ia ki repeating groups : 'Book' bad 'Author' lai sien.
03:52	Te, lada ngi iohi ia kum kine ki repeating groups, ngi dei ban leit biang sha ka design jong ngi.
03:58	Mynta, lada u publisher u publish sa shiphew tylli ki kot, ngim banse ban pynkylla ia ka dur ka dar jong ka table da kaba pyndap sa 20 tylli ki kolums.
04:08	Te, ngi iohi ba ka design jong ka table kam pat biang bad kam long kajuh lada ki data ki kylla.
04:14	Kumjuh ruh, ban wad bad pynbeit ryntih ia ka table da ka book lane author kan jynjar shibun,
04:23	Te ,ngi iit ka rukom ban pynbha ia kane da kaba phiah ia ka table ha ki ar lane lai tylli ki tables
04:30	Ha ka nuksa jong ngi, ngin ia phiah ia ka table ba hajrong ha ki Publishers, Books bad Authors kumba la pyni ha ka dur ha ka screen
04:41	Kane ka design ka wanrah lane pynlong ia ka table sha ka First Normal Form
04:47	Bad buh ia ka dur ka dar jong ka table kumjuh wat lada ki data ha publishers bad books ki ia pher
04:56	To ngin iapeit ia ka Second Normal Form mynta.
05:00	Ia ka 'table' la ong ba ka don ha ka Second Normal Formlane 2NF, lada ka don ha ka 1NF
05:07	Bad man u non- key kolum ka donkam ia ka jingdon ha baroh uwei u primary key.
05:14	Kane ka ain ka treikam lada ngi don ia u primary key uba don palat ban ia kawei ka kolum
05:22	Kum ka nuksa, to ngin peit ia ka BooksIssued table ryngkat ki kolum ba la ai hapoh
05:29	BookId, MemberId, BookTitle bad IssueDate ryngkat 'BookId' bad 'MemberId' kiba pynlong ia u primary key jong ka table.
05:42	Mynta peit ia ka BookTitle column.
05:45	Ngi lah ban ioh ia ka 'BookTitle' da kaba peit ia ka 'BookId' ha ka 'Books' table.
05:52	Ha kiwei pat ki kyntien, 'BookTitle' ka shong nongrim tang ha ka 'Book ID' ym ha ka 'Member ID'.
06:00	Te kam shong ha baroh uwei u primary key.
06:06	Ban wanrah lane pynlong ia kane ka table sha Second Normal Form, ngi dei ban weng noh 'BookTitle' na kane ka table
06:14	Bad buh tang ia kito ki kolums kiba shong nongrim ha baroh ar kata 'primary key' bad columns.
06:23	IssueDate column kan sah hangne, namar ba ka shong nongrim ha baroh artylli ki 'primary key' fields.
06:31	Mynta, to ngin iapeit ka Third Normal Form kadei kaei.
06:35	Ia ka table la ong ba ka don ha ka Third Normal Form (3NF), lada ka don ha ka 2NF
06:42	Bad lada baroh ki non-key kolums kim shong lane snoh iwei ha iwei pat
06:48	Kum ka nuksa, to ngin shim ia ka BooksIssued table ryngkat bad ki kolums kum
06:54	BookIssueId (treikam kum u primary key), BookTitle, Member, IssueDate bad ReturnDate.
07:03	Bad shim ba ka Library’s policy jong ka return date kadei shibnai hadien jong ka Book Issue Date.
07:11	Mynta , ka Base kan khein ia ka Return Date da kaba pyndonkam ia ka 'IssueDate' column kaba dei ka non-key column.
07:19	Kaba mut , ka 'ReturnDate' ka shong nongrim shisha tang ha ka 'IssueDate' column ym ha kano kano kawei pat ka kolum
07:26	Bad lada ngi pyndap da kawei pat ka tarik ha ka 'Return Date' field, te kan sa pynkhein ia ka Library’s policy jong ngi.
07:37	Te, ban buh ia ka table ha ka 'Third Normal Form', ngin weng noh ia ka 'ReturnDate' column na ka table.
07:44	Te , mynta ngi tip kumno ban pyntreikam ia ki lai tylli ki Normal forms
07:49	Barabor, ka database design jong ngi kan sangeh ha ka 3NF.
07:55	Na ka bynta shibun ki jingtip halor ka Normal forms baddatabase design, leit sha ka website ba la pyni ha ka screen
08:05	Khatduh eh, to ngin ia test ia ka database design jong ngi,namar ba ngi lah peit ia ka rukom long jong ka database design
08:12	Ngi lah ban shna ia ka database structure.
08:16	Hangne, ngin ia shna ia ki Tables, Relationships, Rules lane Constraints, Forms, Queriesbad Reports.
08:24	Bad ngi lah ban test ia ka database da ki data ba shisha bad ruh ki nongpyndonkam ba dei
08:29	Pyndonkam ia ka forms ban leh ia ki data additions, updates lane deletes sha ka database.
08:36	Run ia ka report ban peit la ki report results kidei bad kiba biang.
08:42	Katba ka database ka dang pynkhreh ban long, ngi lah ban check ia ka jingtreikam ha kaba iadei bad ka jingstet.
08:50	Ngi lah ban pyndap Indexes sha ki tables na ka bynta ban ioh sei kloi ia ki data
08:55	Bad ngi dei ban leh ia ka jingpynbiang bad jingpeit bniah ban pynlong ia ka database application jong ngi ban treikam
09:03	Mynta ngi la dep, hangne ka kam na ka bynta jong phi:
09:08	Pyndap ia ka entity bathymmai kaba kyrteng Media sha ka Library database design.
09:14	'Media' ka kynthup ia ki DVDs bad CDs bad ki lah ruh ban dei ki audio lane video.
09:21	Kum ki kot, ki DVDs bad CDs lah ban issue sha ki Library members.
09:28	Bud ia ka rukom treikam jong ka database design
09:31	Bad pyntreikam ia ki lai tylli ki Normal forms sha ka design jong phi
09:37	Bad da kane ngi la poi sha kaba kut jong kane ka jinghikai ha ka bynta balai jong ka Database Design halor ka LibreOffice Base.
09:45	Ban kyllum lang, ngi la pule ia kine ki phang harum halor ka database design:
09:50	7. Ban Refine ia ka database design.
09:52	8. Ban pyntreikam ia ki kyndon normalization
09:55	9. Ban test ia ka database design
09:58	Spoken Tutorial project kadei shi bynta jong ka Talk to a Teacher project, bad la kyrshan da ka National Mission on Education lyngba ka ICT, MHRD, Sorkar India.
10:10	Kane ka project la peit bad khmih da ka http://spoken-tutorial.org.
10:15	Shibun ki jingtip halor kane kidon ha ka link ba la ai harum:
10:20	Kane ka script la noh synniang da ka Priya Suresh, DesiCrew Solutions. Bad nga dei u Pdiangburom na Shillong nga pynkut ia kane. Khublei shibun ia ka jingsnoh kti lang jong phi.

Contributors and Content Editors

Pdiangburom