DATABASE SYSTEMS (4/2 credits)

Learning Outcomes:

On completion this course, students will be able to: Describe database system, database terminology, environment, new concept of database; Apply database language and SQL Programming language; Design database using structure data model; Evaluate database processing and security mechanism.

Topics:

1. Introduction to Databases;
2. Database Environment, Database Architecture and the Web, The Relational Model, Relational Algebra and Relational Calculus;
3. SQL- Data Manipulation;
4. SQL – Data Definition;
5. Advanced SQL;
6. Query Processing;
7. Security and Administration;
8. Transaction Management;
9. Database System Development Live Cycle;
10. Database Analysis;
11. Normalization;
12. Advanced Normalization;
13. Entity Relationship (ER) Modeling;
14. Enhanced Entity-Relationship Modeling;
15. Distributed DBMSs—Concept and Design;
16. Web Technology and DBMS;
17. Data Warehousing Concept;
18. Data Mining.