CPEN 102 - (Introduction to Database Systems)

Main block


History and overview of database and management systems including reasons for studying database, database access method, application, role of database in computer engineering. Database Environments: data model hierarchy, network, entity relation, enhanced entity relation, relational database, object oriented database. Relational Data Model: entity relationship modelling. Normalization of Database Tables: data redundancy and associated problems, Normalisation Process, 1NF, 2NF, 3NF, BCNF, 4NF. Query Language: Language paradigms and database languages, user interfaces and graphical query languages, query optimization, data dictionary. Distributed Database System: distributed DBMS concepts and design, distributed relational database, distributed transaction management. Replication and Mobile Databases: basic components of database replication, replication environments, replication servers, mobile databases. Selected database issues: security, concurrency. Introduction to business intelligence, data warehousing, data mining.