BSc in Computer Science / Бакалавр в Області Комп'ютерних Наук

Course Details

Course Information Package

Course Unit Title

DATABASE MANAGEMENT

Course Unit Code

ACSC223

Course Unit Details

Number of ECTS credits allocated

Learning Outcomes of the course unit

By the end of the course, the students should be able to:

To introduce databases as a special type of software systems for storing and retrieving huge amount of data, related models and implementation techniques.
To describe the mathematical foundation and internal mechanisms based on relational algebra as well as to ensure practical skills for analysing data and design of relational database using entity-relationship diagrams.
To explain and show how to apply in practice the normalization techniques for logical design of non-redundant databases with high performance.
To describe and use fourth generation language (SQL) for creating and manipulating databases using different types of interface.
To ensure that the students can work with the most popular database systems MySQL and MS Access and their programming environments.

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 Normal Forms. Translating diagrams into databases – Logical and Physical Design.

Recommended and/or required reading:

Textbooks

Thomas M. Connolly, Carolyn E. Begg, Database Systems: A Practical Approach to Design, Implementation, and Management, 5th Edition, Addison-Wesley Publishing, 2010.

References

Getz Ken, Access 2002 – Developer’s Handbook Vol.1, Sybex, 1999
Ramez A. Elmasri, Shamkant B. Navathe, Fundamentals of Database Systems, 6th Edition, Addison-Wesley Publishing, 2011.
MySQL Database Documentation

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

Tests	15%
Lab and assignments	25%
Final Exam	60%

Language of instruction

English

Work placement(s)

Друк E-mail