DATABASE SYSTEMS (4/2 credits)

Learning Outcomes:

On completion this course, students will be able to: LO1 – describe database systems, terminologies, environment, and new concepts of database; LO2 – apply database languages and SQL Programming languages; LO3 – design database using structured data model; LO4 – perform database processing and security mechanism.

Topics:

1. Introduction To Database;
2. Database Environment;
3. Database Architectures and the Web;
4. The Relational Model;
5. Relational Algebra and Relational Calculus;
6. SQL – Data Definition Language (Table, Index);
7. SQL – Data Manipulation Language (Basic Queries);
8. SQL – Data Manipulation Language (Advanced Queries);
9. SQL – Data Definition Language (View);
10. Advanced SQL;
11. Database System Development Lifecycle;
12. Database Analysis;
13. Transaction Management;
14. Normalization;
15. Advanced Normalization;
16. Security and Administration;
17. Distributed DBMS-Concept and Design;
18. Entity Relationship (ER) Modelling; Enhanced Entity Relationship (ER) Modelling;
19. Data Warehousing Concepts;
20. Data Mining;
21. Normalization & Entity Relationship (ER) Modelling;
22. SQL – Data Definition (1);
23. SQL – Data Manipulation (1);
24. SQL – Data Manipulation (2);
25. Quiz & SQL – Data Manipulation (2);
26. SQL – Data Manipulation (2);
27. SQL –Data Definition (2);
28. Advanced SQL;
29. Database Environment;
30. Project.