CPEN 102 — Introduction to Database Systems
Computer Engineering · University of Ghana
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. Core (Level 200)
- Credits
- 3
- Level
- Level 100
Other courses on this programme
- CPEN 201 — C++ Programming
- CPEN 202 — Digital Systems Design
- CPEN 203 — Digital Circuits
- CPEN 204 — Data Structures and Algorithms
- CPEN 205 — Discrete Mathematical Structures
- CPEN 206 — Linear Circuits
- CPEN 207 — Introduction to Software Engineering
- CPEN 301 — Signals and Systems
- CPEN 302 — Computer Systems Engineering
- CPEN 303 — Computer Architecture
- CPEN 304 — Digital Signal Processing
- CPEN 305 — Computer Networks
Practising CPEN 102 with Questora
Upload your own slides, notes and past papers for CPEN 102 and Questora builds mock exams, practice questions and a revision plan from them.
Start freeCourse details from University of Ghana Volume 3 Handbook for the Bachelor's Degree: Course Descriptions for Programmes in the Sciences (2017).