Databases

Universidad del Norte

Course Description

  • Course Name

    Databases

  • Host University

    Universidad del Norte

  • Location

    Barranquilla, Colombia

  • Area of Study

    Systems Engineering

  • Language Level

    Taught In English

  • Prerequisites

    Intermediate skills in computer programming
    Algorithms & Complexity

    Hours & Credits

  • Contact Hours

    64
  • Recommended U.S. Semester Credits
    4
  • Recommended U.S. Quarter Units
    6
  • Overview

    DESCRIPTION ? COURSE CATALOG
    This course introduces fundamental data bases topics focusing in the relational model. Design concepts are put into practice with the implementation of a real case application over a relational database system.

    BIBLIOGRAPHICAL REFERENCES: text book, other supplemental materials
    Silberschatz, Abraham et al. Fundamentos de Bases de datos
    Connolly, Thomas et al. Sistemas de Bases de Datos. Un enfoque práctico para diseño, implementación y gestión

    COURSE LEARNING OUTCOMES

    • Identify the characteristics and strengths of databases systems over file based systems.
    • Model information systems using the relational model.
    • Extract information of databases systems using SQL.
    • Develop software applications that interact with databases systems.
    • Model information systems using the entity-relationship model.

    TOPICS COVERED
    • Introduction and basic concepts of Databases
    • Entity ? Relationship model
    • Relational model
    • SQL
    • Relational database design. Normal forms
    • Integrity and security
    • Special Topics: Transactions, Concurrency, Indexation