University of Malta

Study-Unit Description
UOM Main Page
Apply - Admissions 2016
Campus Map button


TITLE Introduction to Databases and Information Management

LEVEL 01 - Year 1 in Modular Undergraduate Course


DEPARTMENT Computer Information Systems

DESCRIPTION The aim of this unit is to introduce students to the background of databases and DBMSs, their use and architecture, concepts of database design and implementation and to teach basic skills and techniques in creating, updating and querying databases.

An introduction to the database approach, characteristics, advantages and disadvantages of using a DBMS. Historical development and overview of current application areas. Use of databases for Datawarehousing, GIS, Data Mining and Multimedia applications. Issues related to different data formats

The role of Databases in an organization. The types of users. The role of the Database administrator. The database application system life cycle.

The principal components and architecture of a DBMS. The processes of database design and implementation. Database conceptualisation, modeling the database, logical and physical data independence, the three-schema conceptual architecture,

The use and composition of ER diagrams. The development Entity Relationship diagrams from user requirements. The relational model, principal components, relational schema design. Conversion of ER model to Relational Schema model.

Introduction to a formal database language -Relational Algebra, knowledge and use of basic relational operations.

Structured Query Language basic DDL and DML commands covering the specification of tables and constraints, basic updating of data and various query operations

Use of a relational database management systems is made though a number of practical / presentation. The lecturer provides unit material.

• R Elmasri & S Navathe, Fundamentals of Database Systems, Addison-Wesley.
• R Earp & S Bagui, Learning SQL: A step-by-step guide using Oracle, Addison-Wesley.

ADDITIONAL NOTES Pre-requisite: ‘A’ Level Grade C (Computing or I.T.) or following a Computing course.

Leads to: CIS2090


Assessment Component/s Resit Availability Weighting
Practical Yes 15%
Examination (3 Hours) Yes 85%

LECTURER/S Joseph Vella

The University makes every effort to ensure that the published Courses Plans, Programmes of Study and Study-Unit information are complete and up-to-date at the time of publication. The University reserves the right to make changes in case errors are detected after publication.
The availability of optional units may be subject to timetabling constraints.
Units not attracting a sufficient number of registrations may be withdrawn without notice.
It should be noted that all the information in the study-unit description above applies to the academic year 2017/8, if study-unit is available during this academic year, and may be subject to change in subsequent years.
Study-unit Registration Forms 2017/8


For Undergraduate (Day) and Postgraduate students.


Academic Advisors 2017/8


Academic Advisors for ICT 1st year students (Intake 2017/8), NOW available

Faculty of ICT Timetables


ICT Timetables are available from Here.

Health and Safety Regulations for Labs Form

The Faculty of ICT Health and Safety Regulations for Laboratories form can be found here



Log In back to UoM Homepage