Résumé de section

  • Presentation

    Tout replier Tout déplier

    • database

      • About the Course

        • This course provides a comprehensive introduction to the principles and practices of database systems. It begins by addressing the limitations of traditional file-based data management and introduces students to the fundamental concepts of databases and Database Management Systems (DBMS). Through two structured chapters, learners explore topics such as data modeling, the relational model, SQL, and the architecture and functionality of relational DBMS like MySQL, Oracle, and SQL Server. The course emphasizes practical and theoretical understanding through the use of Entity-Relationship diagrams, schema design, and integrity constraints. Students will develop the ability to design, query, and manage databases efficiently while gaining insight into data integrity, security, and concurrent access control. This foundational knowledge prepares students for advanced studies in information systems and data-centric technologies.

        • Map

        • About Video URL

    • Contact

      Faculty: Faculty of Exact Sciences
       Department: Computer Science
       Subject: Database
       Level: 2nd year Bachelor's 
      Teaching Unit: Fundamental Teaching Unit (UEF 1.2)
       Weekly Time Volume: 4.5 hours per week (Lecture: 1h30 + Tutorial: 1h30+ Lab 1h30)
       Number of Credits: 6
       Coefficient: 3
       Total Duration: 4.5 hours per week for 12 weeks
       Evaluation Method:

      Continuous Assessment:

      • 40% (20% DW and 20% Lab)
      • Final Exam: 60%

       Email: abdelhafid.dakhia@univ-biskra.dz

    • Annonces Forum

  • General Objectives

    • Objectives

      ·       

      • Identify the basic concepts and terminology related to databases, including key components such as tables, attributes, and keys.
      • Explain the limitations of traditional file systems and describe the advantages offered by modern database systems.
      • Use conceptual models such as Entity-Relationship (ER) diagrams to design and represent structured data.
      • Analyse the relational model by examining its structure and applying it to real-world data scenarios through SQL (Structured Query Language) operations.
      • Evaluate the functionality, components, and benefits of Database Management Systems (DBMS), with particular attention to data integrity, security, and consistency.

  • Prerequisites

    •  To successfully engage with this module, students are expected to have a foundational understanding of computer Prior knowledge of data structures, file organization, and basic programming concepts, such as variables, control structures, and functions solving is essential.

      Familiarity with logical thinking and algorithmic problem will help students grasp the structure and manipulation of data in a database context. While not mandatory, prior exposure to basic data is system architecture stored and accessed.

       A general comfort with using computers and and operating systems navigating software sessions may involve the use of can provide helpful context for understanding how environments is also recommended, as practical database management tools and SQL queries .

      The purpose of the following pretest is to assess students' foundational understanding of key concepts in computer science, with a particular focus on databases and data management systems.

    • Test

  • Review Materials for Prerequisite Concepts

    If you found the pretest challenging or made several errors, it might be helpful to revisit some fundamental concepts before diving into the course. To support your review, we’ve provided a selection of recommended resources below.

  • Course Content

  • General Introduction

  • Chapter I: General information about Databases

    Chapter I introduces the foundational concepts of databases by highlighting the limitations of traditional file-based systems. It explains the need for databases and defines their structure, roles, and applications across various fields. The chapter explores how Database Management Systems (DBMS) improve data organization, security, and access. It also presents the architecture, components, and user roles within modern relational DBMS environments.

    • PDF Version of Chapter I Dossier
    • Web Version of Chapter I Dossier
    • SCROM Version of Chapter I Paquetage SCORM
    • Chapter I Content Video URL
    • Discussion Forum
    • Test for chapter I
      Ouvert : jeudi 9 octobre 2025, 09:36
      Terminé : vendredi 10 octobre 2025, 09:36
    • SPACE Wiki

  • Chapter II : The relational model

    Chapter II focuses on the relational model, the most widely used model in modern database systems. It begins with the database design process, including analysis, conceptual, and logical modeling using ER diagrams. Key relational concepts such as relations, attributes, tuples, domains, and keys are introduced and explained. The chapter also covers schema design, relationship diagrams, and integrity constraints to ensure data consistency.

  • Bibliography and References

    Bibliography

  • Final Test

    • Test

    • Final Test

  • Your Opinion Matters