DATABASE SYSTEMS

Course Description

This course introduces the student to the basic theoretical and practical concepts of a database, its setup, implementation, use and maintenance in a typical business organization. The course consists of two parts:

Part I, which is purely theoretical and Part II, which is practical.

Course Objectives

The aims of this course are, to:

1. Familiarize students with the basic concepts of database systems and data modeling;

2. Introduce the concepts of relational databases and their security;

3. Explore the use of at least one Database Management Systems (DBMS) and the formulation of queries in databases;

4. Study how data can be imported and exported to and fro different applications.

Learning Outcomes

On completion of the course, the student should be able to:

1. Appreciate the basic concepts of database systems and data modeling;

2. Develop relational databases that are secure;

3. Formulate queries in databases and to use at least one DBMS;

4. Import and export data to and fro different applications.