University of Prishtina, Faculty of Electrical and Computer Engineering


Databases, Winter 2018-2019



Instructor

Prof. Dr. Lule Ahmedi
Consultation hours: Mondays and Tuesdays 13:00-14:00

Teaching Assistants

MSc. Besmir Sejdiu
MSc. Yll Sadikaj

Administrativia

Level: Bachelor/mandatory. ECTS credits: 6
Time (lectures): Monday, 8:30-10:00 Group 2, 10:30-12:00 Group 1
Location (lectures): Classroom 621

Course description

This course is an introductory course on databases, as it covers its basic concepts and techniques:
Relational model, algebra and calculus. SQL. Conceptual, formal, and physical design of relational databases. Query evaluation. Transactions and recovery.

Learning outcomes

Upon completion of this course, students shall be able to:
  1. Demonstrate basic knowledge on techniques for describtion and management of huge datasets based on the relational model.
  2. Use the gained experience to design and implement database projects in the real-life.
  3. Recognize typical problems related to databases in practice, and compare existing systems in order to make a proper solution to overcome those problems.
  4. Identify different aspects of relevance for the development of huge database projects, as well as accordingly guide the adaptation of basic principles.

Syllabus

Course syllabus in Shqip (Albanian language) .

Lecture slides

For UP students currently enrolled to this course: Enter to access the course materials.

Textbooks

[1]
Database Management Systems, Raghu Ramakrishnan, Johannes Gehrke. McGraw-Hill Higher Education, 3rd Edition, 2002.
[2]
Database Systems: The Complete Book, Hector Garcia-Molina, Jeff Ullman, Jennifer Widom. Pearson, 2nd Edition, 2008. Section on Logic for Relations.
[3]
Database System Concepts, Abraham Silberschatz, Henry F. Korth, S. Sudarshan. McGraw-Hill Education, 6th Edition, 2010.