University of Malta
 

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


CODE CIS1042

 
TITLE Introduction to Databases and Information Management

 
LEVEL 01 - Year 1 in Modular Undergraduate Course

 
ECTS CREDITS 6

 
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.

Textbooks:
• 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

 
STUDY-UNIT TYPE Lecture

 
METHOD OF ASSESSMENT
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.
Calendar
Notices
Study-unit Registration Forms 2017/8

Register

For Undergraduate (Day) and Postgraduate students.

 

Academic Advisors 2017/8

AA1

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

Faculty of ICT Timetables

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

 HealthAndSafety

 
 

Log In back to UoM Homepage