Topic outline

  • General

  • Course presentation

    • Database and Database management system

      • Purpose of the database module: 

        This course should enable the student to identify the importance of structuring and manipulating data in a tabular form. Through the relational model and its underlying relational algebra, which are more practice-oriented, the student should understand the significance of data structuring, the concept of data independence from processing, as well as data integrity and consistency.

      • Targeted public: 2nd year licence Computer Science

      • Prerequisites: The study is based on what files are (text, binaries or typed) and having created them with the languages ​​previously studied.

      • Evaluation method: 60% exam, 40% continuous evaluation.

      • Coefficient: 3

  • Module program:

    • Chapter 01 : Introduction to database

      Chapter 02:  Entity relationship model

      Chapter 03: Relational model

      Chapter 04: Relational algebra

      Chapter 05: Relational calculus

      Chapter 06: SQL

  • Chapter 01: Introduction to database

    • Objective :
      ☞ Understand why we use database instead directly using files.

  • Chapter 02 E/R Model

    • Objectives :
      ☞ Understand what is an entity and know how to define entities.
      ☞ Understand what is an association and know how to define associations.
      ☞ Understand the meaning of cardinalities and know how to express cardinalities.
      ☞ Know how to define the primary key of an entity.
      ☞ Understand what is a weak entity and know how to identify weak entities.
      ☞ Practice designing a database using the Entity-Relationship (E/R) model.


  • Chapter 03 Relational model

    • Objectives :
      ☞ Understand the concept of functional dependency.
      ☞ Definition of a universal relational schema of a database.
      ☞ Definition of a primary key.
      ☞ Definition of a foreign key.
      ☞ Normalization of a universal relational schema of a database.

      ☞Training on eliminating redundancy in the database.

  • Chapter 04 Relational algebra

    • Objective: Understand Relational Algebra
      ☞ Understand set operations:

      • Union
      • Intersection
      • Difference

      ☞ Understand specific operations:

      • Projection
      • Selection (Restriction)
      • Join
      • Division

  • Chapter 05 Relational Calculus

    • Objectives :
      ☞ Mastering TRC (Tuple Relational Calculus) query writing

      ☞Master querying concepts such as :

      -          Union

      -          Intersection

      -          Difference

      -          Projection

      -          Selection

      -          Joins

      -          Division

      -          Logical quantifiers (∀, ∃).


  • Chapter 06 SQL

    • Objectives :
      ☞ Mastering SQL(Structed Query Language)

      ☞ Mastering query writing


  • Practical Works