COURSE
SPECIFICATION
Code:
School: Department of Computer Science
Course
Title: Database Concepts
Course
Coordinator: Dr. Marenglen Biba
Level: M
Credit: 12
Department:
CS
Pre-requisites:
Aims:
This course aims to introduce students to advance
database concepts of relational databases including Transaction Processing,
Concurrency Control, Recovery Systems, File Organization, Indexing &
Hashing, Query Processing and object-oriented databases.
Learning
Outcomes:
At the
end of the course the student should be able to:
Understand
transaction management and concurrency control
Understand
query processing and query optimization
Comprehend
distributed databases and client/server architecture
Understand
object-oriented and deductive databases
Understand
emerging database technologies
Content:
File
Organization*
Internal
Design of a Mini Database Engine*
Transaction
Management and Concurrency Control*
Query
Processing and Query Optimization*
Distributed
Databases and Client/Server Architecture
Object-Oriented
Databases
Database
Recovery Techniques
Data
Warehousing and Data Mining
Emerging
Database Technologies
*. To be
covered by Rao Narasimha.
Learning
and Teaching Activities:
Concepts
will be introduced in lectures and practical exercises.
Assessment
Details:
|
Methods
of Assessment |
Please
identify the LAST item of assessment that a student sits with a tick |
Grading
Mode |
Weighting
% |
|
Word
Length |
Outline
Details |
|
Coursework |
|
|
40 |
50% |
|
Case
study and practical exercises Covering
Learning Outcomes:
A,B &C |
|
Examination |
Ö |
|
60 |
50% |
|
Covering
Learning Outcomes:
A,B,C,D & E |
|
Is the
student required to pass |
YES |
Indicative
Texts:
|
ISBN
Number |
Author |
Date |
Title |
Publisher |
|
007044756X |
Abraham, Korth, H.F.,
Sudarshan,S. & Silberschatz |
2005 |
Database
System Concepts |
McGraw-Hill
Companies |
Software Requirements:
Oracle 10g, SQL Server 2008 Express Edition
Course
material
Advanced Data Types and New
Applications