+251 111 559769      info@hilcoe.net
     +251 111 559769      info@hilcoe.net

Database Management Systems

Course Descriptions:

This course is an introduction to the principles, use, and applications of database systems, students who complete the course will be able to design and create databases, be able to extract information from databases, understand in broad terms how database systems work, and understand the purposes for which databases are used. This course covers the following topics:

Database fundamentals: Database approach, advantages and disadvantages of DBMS, manual and computerized filing system, the DBA, DBMS components. DBMS Architecture: Levels of abstraction (conceptual view, internal view, and external view), attributes, and association stages in database design. Entity relationship diagram: Data modeling, the process of normalization, SQL.

Objective:

On completion of this course students should be able to:

  1. understand the need for database systems;
  2. understand the principles underlying database systems and the kinds of purposes for which they are used
  3. be familiar with the basic DBMS architecture, components, and interfaces;
  4. understand and use database models in database and application design;
  5. understand relational data model, and be able to formulate queries in relational algebra
  6. understand the needs of normalization and the kinds of normal forms
  7. be able to use Structured Query Language(SQL);
  8. understand the need for conceptual modeling and use entity-relationship diagrams to construct such models
  9. be able to develop database applications;
  10. understand views and their purposes, and be able to formulate and interpret queries on views
  11. understand in outline how data is managed by a database management system and how queries are evaluated

Course Content:

  • Introduction to Database systems
  • Database Management Systems (DBMS)
  • Relational Database Management Systems (RDBMS)
  • Database Application Development