Module Catalogues

Introduction to Databases

Module Title Introduction to Databases
Module Level Level 1
Module Credits 5.00
Academic Year 2024/25
Semester SEM2

Aims and Fit of Module

The module aims to establish an understanding of Information Systems, to encourage the appropriate and efficient design and usage of Information Systems, to provide insight into the design process and social implications of Information Systems, and to enable the use of Information Systems in a programming environment.

Learning outcomes

A. Describe the methods and issues involved in the design and deployment of database systems to meet business goals. B. Show a fundamental grounding in the operation and usage of database management systems including "hands-on" experience of a basic database management system; C. Demonstrate in-depth knowledge of the database language, SQL; D. Demonstrate an understanding of the processes and legal, social, ethical and professional implications of creating and maintaining information systems. E. Recall risks or safety aspects that may be involved in the operation of database systems.

Method of teaching and learning

The teaching philosophy of the module follows very much the philosophy of Syntegrative Education. This has meant that the teaching delivery pattern, which follows more intensive block teaching, allows more meaningful contribution from industry partners.
This philosophy is carried through also in terms of assessment, with reduction on the use of exams and increase in coursework, especially problem-based assessments that are project focused. The delivery pattern provides space in the semester for students to concentrate on completing the assessments.
Students will be expected to attend formal lectures, seminars as well as to participate in practicals in a computer lab. Lectures will introduce students to the academic content and practical skills which are the subject of the module, while computer practicals will allow students to practice those skills. Case studies are presented illustrating the effective use and design of databases.
In addition, students will be expected to devote seven hours of unsupervised time to solving continuous assessment tasks and private study. Private study will provide time for reflection and consideration of lecture material and background reading. Continuous assessment will be used to test to what extent practical skills have been learnt, in particular, assessment tasks will be solved individually and each solution comprises the resolution, using sound software engineering techniques, of the given problems expressed in terms of a requirements statement. A written examination at the end of the module will assess the academic achievement of students