674 Basics of Databases

674 Basics of Databases

  • Study programme and level: University Study Programme in Administrative Information Science - 1st Cycle
  • 2nd year
  • 6 ECTS
  • Course type: Core
  • Tutorial: 30
  • Other forms of study: 15
  • Individual work: 90
  • Lecturer: Marko Bajec, PhD

    1. Objectives and competences

    • The aim of this course is to explain the students basics of databases, i.e. advantages of using database systems over using file systems, how databases and database management systems work, how we manage them; how we design databases etc.

    2. Content

    Lectures:

    • Introduction to DB
    • History of data bases;
    • DB management systems (DBMS);
    • Types of DBMS;
    • Roles in DB Management;

    Describing, Storing and Querying data in DB

    • 3-tire data representation;
    • Data storing and indexing;
    • Formal query languages;
    • SQL basics;
    • QBE;

    DB Management

    • Basic SUPB components & services;
    • DB maintenance;
    • Data ownership;

    DB design - basics

    • 3-level data modeling approach;
    • Conceptual data modeling;    
    • Logical data modeling;
    • Normalisation - basics;
    • Physical data modeling.

    3. Readings

    • Thomas M. Connolly, Carolyn E. Begg (2005). Database Systems, A Practical Approach to Design, Implementation and Management, Fourth Edition, Addison-Wesley.
    • Raghu Ramakrishnan, Johannes Gehrke (2003). Database Management Systems, Third Edition, McGraw-Hill.
    • Ramez Elmasri, Shamkant B. Navathe (2003). Fundamentals of Database Systems, Fourth Edition, Addison-Wesley.
    • Tomaž Mohorič (2002). Podatkovne baze, Založba Bi-TIM.
    • Peter Rob, Carlos Coronel (2005). Database Systems: Design, Implementation and Management, Sixth Edition, Addison Wesley.

    4. Intended learning outcomes

    Knowledge and understanding:

    • Understanding basic principles of systems for database management. Understanding of database design techniques and approaches. Understanding of formal database query languages. Understanding advantages the use of database management systems brings.

    Application:

    • The use within information system development and development of other computer programs that demand or work with high volumes of data.

    Reflection:

    • Capability for improving modeling techniques, data representation and storing while solving practical problems.
    • Transferable skills: ability to use domestic and foreign literature, the use of ICT, the use of systematical approaches in solving problems, ability to identification of problems and their resolution, team work.

    5. Learning and teaching methods

    • Lectures,
    • Practical exercises,
    • homeworks and
    • seminars in team.

    6. Assessment

    Type (examination, oral, coursework, project):

    • Continuing (homework, midterm exams, project work) (50%)
    • Final: (written and oral exam) (50%)