DATABASE SYSTEMS (2 credits)

Learning Outcome:

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.

Topics:

1. Introduction to Databases;
2. SQL Server Introduction;
3. Database Environment;
4. SQL – Data Definition Language;
5. SQL – Data Manipulation Language (1);
6. SQL – Data Manipulation Language (2);
7. SQL – Data Manipulation Language (3);
8. Database System Development Lifecycle;
9. Normalization;
10. Entity Relationship (ER) Modelling;
11. Enhanced Entity-Relationship Modelling.