Aperçu des sections

  • Généralités

    •  09:00 ليكن في علم جميع طلبة المجموعة انه يو امتحان الاعمال الموجهة سيتم قسم المجموعة الى قسمين الفوج 01 و الفوج 02 و نصف الفوج 05 سيجتازون الامتحان من 08:30 الى   

       طلبة الفوج 05 المعنين باجتياز الامتحان على 08:30 اسماؤهم كالاتي: 

      ACHICHI SAMIR
      ADJROUD ALAA ERRAHMANE
      AMARA OMAYMA
      BAKHA CHOUROUK
      BELAZIZIA HADIL
      BENBELKACEM NOURHANE
      BENGHALIA MARAM
      BENTRAD NOUR EL YAKINE
      BOUDAB AMEL
      BOUGUENAFED YASSER
      BOUMAARAF NOUHA
      FERNANE CHARAF EDDINE
      ILIHEM MOUATEZ BILLAH AKRAM
      KALLI MOHAMMED
      KASSA MARWA
      KHAMMAR MIHAD
      KHELIFI IMED

      وليكن في علم طلبة الفوج 03 و 04 و باقي الفوج 05 سيجتازون الامتحان من 09:10 الى   09:40

          يرجى من الطلبة احترام التوقيت المحدد لكل فوج و عدم القيام بتجاوزات مهما كانت الاسباب.  

  • 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:  Data model

      Chapter 03: Relational model

      Chapter 04: Relational algebra

      Chapter 05: Relational calculus

      Chapter 06: SQL Language (Structed Query Language)

      Chapter 07: Functional dependancies, transitive closure and minimal cover



  • Chapter 01: Introduction to database

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

  • Chapter 02 Data 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.

      ☞ Practice designing a database using the hiearchical model.

      ☞ Practice designing a database using the network model.

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


  • 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

  • Chapter 07: Functional dependancies, transitive closure and minimal cover

    • Objectives : 
      ☞ Revision about functional depandencies

      ☞ Mastering transitive closure

      ☞ Mastering minimal cover


  • Practical Works