Course Details
Course Information Package
Course Unit Title | ADVANCED DATABASE SYSTEMS | ||||||||
Course Unit Code | ACSC384 | ||||||||
Course Unit Details | BSc Computer Engineering (Technical Electives) - BSc Computer Science (Required Courses) - | ||||||||
Number of ECTS credits allocated | 6 | ||||||||
Learning Outcomes of the course unit | By the end of the course, the students should be able to:
| ||||||||
Mode of Delivery | Face-to-face | ||||||||
Prerequisites | ACSC223 | Co-requisites | NONE | ||||||
Recommended optional program components | |||||||||
Course Contents | Preview: Preview of data models. Relational Database Systems – Architecture and implementation models. Design of database systems.
Programmatic Use of Database Systems: Connecting databases to applications. Mechanisms of using MySQL database system from Java, C/C and C# applications.
DBMS Functionalities: Transactions, Concurrency, Recovery and Security.
Database Systems Administration: Data Administration and Database Administration.
Introduction to Object-Oriented Database Systems: The Object Data Model. Object-Oriented DBMS and Object-Relational DBMS.
Introduction to Distributed Database Systems: Concepts, Architecture and Functions. Database Pooling and Replication. Mobile Databases.
Introduction to XML Database Systems: Semistructured Data and XML. Development of XML - based Applications using Native XML Databases and Relational Databases. | ||||||||
Recommended and/or required reading: | |||||||||
Textbooks |
| ||||||||
References |
| ||||||||
Planned learning activities and teaching methods | For the delivery of the class material, power point presentations are primarily used, along with the whiteboard. The lecture notes, consisting of slides presented in class, and additional material, are made available to the students through the course website. The students have intensive work in the lab on programmatic use of relational databases and related assignments. | ||||||||
Assessment methods and criteria |
| ||||||||
Language of instruction | English | ||||||||
Work placement(s) | NO |