Home

CPEN 102 - (Introduction to Database Systems)

Main block

Credits: 
3

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.