COMP 2605 Enterprise Database Systems
Transition Plan for Computer Science Programmes
This transition plan applies to students who registered in one of our Computer Science degree programmes prior to the 2016/2017 academic year. Students who registered in the 2016/2017 academic year or afterwards should follow the course requirements of their respective degree programmes.
COMP 2700 Database Management Systems I - COMP 2605 Enterprise Database Systems
Course Description
This course covers the design and implementation of relational database systems. Emphasis is placed on the database design of real world business application using Entity Relationship modelling. SQL programming is covered in detail. Data Management concepts such as Transaction Management, Concurrency Control, Recovery, and backups are presented. XML-enabled databases are also studied. An overview of several specialized databases is introduced and the technical and managerial responsibilities of a database administrator are discussed.
By utilizing an abundance of real world business applications, students are introduced to database systems and designs used by organizations. Additionally, students examine the characteristics of database transactions and how they affect database integrity and consistency. At the end of this course, students will be able to effectively design and implement enterprise database systems.
