DATABASE
الخطوط العريضة للقسم
-
-
-
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
-
-
-
-
-
·
- 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.
-
-
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.
-
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.
-
Test for chapter I إختبارمفتوح: الخميس، 9 أكتوبر 2025، 9:36 AMمغلق: الجمعة، 10 أكتوبر 2025، 9:36 AM
-
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.
