NAMNA YA KUCHORA ERD YA DATABASE KWA KUTUMIA SOFTWARE AMBAYO NI FREE KWA VITENDO (PART 1)

download setup
https://github.com/jgraph/drawio-desktop/releases/tag/v20.8.10
------------
*VIDEO CONTENTS*
------------

1.how to draw ERD using software,
2.how to convert ERD to physical schema,
3.how to perform database normalization,
4.what are data anomalies,
5.what is multivalued attribute,
6.how to draw multivalued attribute,
7.types of Information Systems,
8.what are Data warehouses,
9.what is Transaction processing System,
10.what are examples of Transaction Processing Systems TPS,
11.what is Management Information Systems MIS,
12.what is Decision Support System DSS,
13.what is Online Analytical System OLAP,
14.what is data transformation,
15.why Data warehouses are De-normalized?,
16.what are second Normal form rules,
17.what are database constraints,
18.how to force referential integrity using SQL,
19.is it possible inserting data to child table ?,
20.is it possible to drop mother table ?,
21.is it possible to drop child table ?,
22.if yes or no give reasons,
23.what are descriptive models,
24.what are predictive models,
25.how does clustering model generate knowledge ?
26.what are examples of Knowledge Management Systems
27.how does Knowledge Management System discover the knowledge ?
28.mention 4 examples of Enterprise Resource Planning Systems
29.what are examples of Customer Relation MIS
30.what is Conceptual Schema example
31.how to Login mysql server under command Line

Видео NAMNA YA KUCHORA ERD YA DATABASE KWA KUTUMIA SOFTWARE AMBAYO NI FREE KWA VITENDO (PART 1) канала swahili ICT tutorials