Database Management Systems Units:
UNIT 1:Introduction: Concept & Overview of DBMS, Data Models, Database Languages, Database Administrator, Database Users, Three Schema architecture of DBMS.
UNIT 2: Entity-Relationship Model: Basic concepts, Design Issues, Mapping Constraints, Keys, Entity-Relationship Diagram, Weak Entity Sets, Extended E-R features.
UNIT 3: Relational Model: Structure of relational Databases, Relational Algebra, Relational Calculus, Extended Relational Algebra Operations, Views, Modifications of the Database.
UNIT 4: SQL and Integrity Constraints: Concept of DDL, DML, DCL. Basic Structure, Set operations, Aggregate Functions, Null Values, Domain Constraints, Referential Integrity Constraints, assertions, views, Nested Sub queries, Database security application development using SQL, Stored procedures and triggers.
UNIT 5: Relational Database Design : Functional Dependency, Different anomalies in designing a Database., Normalization using functional dependencies, Decomposition, Boyce-Codd Normal Form, 3NF, Normalization using multi-valued dependencies, 4NF, 5NF
- Teacher: Nsengiyumva Emmanuel
INTRODUCTION TI ENTREPRENEURSHIP
entrepreneurship theories
characteristics of a successful entrepreneurs
difference between small businesses and entrepreneurial venture
business plan development
business idea generation in IT
professional skills
required skills for an entrepreneur
- Teacher: Dr. Victoire MUHAYIMANA
This module will introduce the important skills of Telephony Communication
- Teacher: Nsengiyumva Emmanuel
A management information system is an information system used for decision-making, and for the coordination, control, analysis, and visualization of information in an organization. The study of the management information systems involves people, processes and technology in an organizational context.