DATABASE SYSTEMS (4/2 Credits)

Learning Outcomes:

On successful completion of this course, student will be able to: Describe database systems, terminology, environment, and new concept of database; Apply database language and SQL Programming language; design database using structure data model; evaluate database processing and security Mechanism.

Topics:

Database Environment; Introduction To Database; Database Environment; SQL – Data Definition (1); Database Architectures and the Web; SQL – Data Manipulation (1); SQL – Data Manipulation (2); The Relational Model; Relational Algebra and Relational Calculus; SQL – Data Manipulation (3); Relational Algebra and Relational Calculus; SQL – Data Manipulation (4); SQL – Data Definition and Data Manipulation (1); SQL – Data Manipulation (5); SQL – Data Definition and Data Manipulation (1); SQL –Data Definition (2); Normalization & Entity Relationship (ER) Modelling; Security and Administration; Advanced SQL; Security and Administration; Review & Project Submission; SQL – Data Definition and Data Manipulation (2); SQL – Data Definition and Data Manipulation (2); Advanced SQL; Advanced SQL; Transaction Management; Transaction Management; Database System Development Lifecycle; Database Analysis; Normalization; Advanced Normalization; Distributed DBMS-Concept and Design; Distributed DBMS-Concept and Design; Entity Relationship (ER) Modelling; Enhanced Entity Relationship (ER) Modelling; Data Warehousing Concepts; Data Mining