University of Malta
 

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


CODE CIS2090

 
TITLE Practical Design and Implementation with DBMS

 
LEVEL 02 - Years 2, 3 in Modular Undergraduate Course

 
ECTS CREDITS 4

 
DEPARTMENT Computer Information Systems

 
DESCRIPTION The objective of this study-unit is to allow students to demonstrate their acquired knowledge on logical design and database models to construct a sound physical implementation.

The course material covers some important pragmatic aspects of DBMS. These aspects include data storage, disk access, file structures; file access, index files, database engines; and query processing.

Functional dependencies and normalization techniques are studied with the aim of defining the relationships contained within the data and reducing duplication.

Database assertions and triggers are also introduced to maintain the data integrity and operational characteristics of an application.

Advanced SQL query operations to handle more complex reporting requirements.

Performance issues are discussed in terms of optimizing queries, database design and tuning.

Issues dealing with system failure, problems arising from concurrent use – introducing transaction processing, concurrency control and recovery mechanisms.

Data security and DBMS mechanisms to support it discussed at some length.

The operational roles of a database administrator (for example data back up, data replication decisions, database design reviews, monitoring of access and resources) are enumerated.

Students are assigned a description of an application on which the practicals are done.

Textbooks:
• Elmasri R, Navathes, Fundamentals of Database Systems, Addison-Wesley.
• Reference: Systems Manuals available on request.

 
RULES/CONDITIONS Before TAKING THIS STUDY-UNIT YOU MUST TAKE CIS1041 OR TAKE CIS1043

 
STUDY-UNIT TYPE Lecture and Practical

 
METHOD OF ASSESSMENT
Assessment Component/s Resit Availability Weighting
Practical Yes 15%
Examination (2 Hours) Yes 85%

 
LECTURER/S

 
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.

 

Faculty of ICT Timetables

Timetables

ICT Timetables are available from Here.

Health and Safety Regulations for Laboratories Form

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

 HealthAndSafety

13th Edition of EY’s Annual Attractiveness Event

 Logo

 

 

The 13th Edition of EY’s Annual Attractiveness event will be held on 25th October 2017 at the InterContinental Hotel,

St. Julians. It is titled "Thinking without the box: disruption, technology and FDI".

 

The  students' invitation and more information can be found here

The conference programme can be found here

 

 
 

Log In back to UoM Homepage