General Objectives
Prerequisites
Pretest
Review Materials for Prerequisite
Concepts
General Introduction
Chapter I: General Information About Databases
1.Specific Objectives for Chapter I
2. Problems Posed by Classic Organizations (SGF)
2.1. Limitations of Traditional File-Based Systems
2.2. Information Redundancy
2.3. Dependency Between Data and Programs
3. Limits of the File System Approach
3.1. Problems of Classical Data Management
4. What Is a Database?
4.1. Definition of a Database
4.2. Database: Applications
5. Database Management System (DBMS)
5.1. Generalities5.2. DBMS: Objectives
5.3. Different Types of DBMS Users
5.4. DBMS Data Description Levels
5.5. Relational DBMS
5.6. Relational DBMS Architecture
5.7. Main DBMS Functions
5.8. Functional Architecture of a Relational DBMS
6. Test for Chapter IChapter II: The Relational Model
1. Specific Objectives for Chapter II
2. Database Modelling
3. The Entity/Association Model: Basic Concepts
4. The Relational Model4.1. Basic Model Concepts
5. Cartesian Product of a Set of Domains
6. Relation
6.1. Generalities
6.2. Tuple of a Relationship
6.3. Cardinality of a Relationship
6.4. Degree of a Relationship
6.5. The INSCRIPTION Relationship
6.6. Relationship Diagram
7. Schema of a Database
7.1. Generalities
7.2. Composite Key
7.3. Foreign Key
8. Test for Chapter II
Final Test

Last modified: Wednesday, 6 August 2025, 6:14 PM