Course Details
Course Information Package
Course Unit Title | DATABASE MANAGEMENT | ||||||||
Course Unit Code | ACSC223 | ||||||||
Course Unit Details | |||||||||
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 | NONE | Co-requisites | NONE | ||||||
Recommended optional program components | NONE | ||||||||
Course Contents | Introduction to databases. Data, information and knowledge. Approaches to working with data. Definition of database and database system.
Types of Databases systems: Three-level architecture. Data models (relational, network, hierarchical). Functions and components of DBMS.
The relational Model: Tables, rows, attributes and data types. Primary and Foreign Keys. Table Relations. Integrity constraints. Physical and logical views.
Relational Algebra and Calculus: Selection, Projection, Union, Set difference, Cartesian Product, Join, Theta-join, outer and left joins.
Manipulating Databases: The SQL language. Table construction (CREATE, DROP, ALTER). Data manipulation (INSERT, UPDATE, DELETE, SELECT). Joins and join types.
Database analysis and specification: Database System Development, Planning fact-finding and specification.
Database design: Entity-Relationship diagrams. Enhanced ER. Normalization and | ||||||||
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 lab work on using MySQL as an example of relational database and implement respective assignments. | ||||||||
Assessment methods and criteria |
| ||||||||
Language of instruction | English | ||||||||
Work placement(s) | NO |