DATABASE (4 Credits)

Learning Outcomes:

On successful completion of this course, student will be able to: Describe concepts, terminology, environment, and relational model in database system; Construct query of SQL that suitable with the problem; Design database using structure data model; Apply user role and right access to increase security in database system.

Topics:

1. Introduction to Databases;
2. The Relational Model;
3. Database Environment;
4. SQL: Data Definition Language (1);
5. SQL – Data Manipulation Language (1);
6. SQL – Data Manipulation Language (2);
7. SQL – Data Definiton Language (2);
8. Database Systems Development Lifecycle;
9. Normalization;
10. Entity Relationship (ER) Modelling,
11. Enhanced Entity-Relationship Modelling;
12. Security and Administration.