Skip to content

Database Management System syllabus

IT 2328 units · 43 topicsAcademic year 2083/84
Browse the units

Database Management System

8 units

1. Database Concepts and Architecture (4 LHs)

  1. Database, Database Management System, Database Users, and Benefits of Databases
    1. Database, Database Management System, Database Users, and Benefits of Databases
  2. Data Models, Schemas, and Instances
    1. Data Models, Schemas, and Instances
  3. Three-Schema Architecture and Data Independence
    1. Three-Schema Architecture and Data Independence
  4. Database Languages and Interfaces
    1. Database Languages and Interfaces
  5. The Database System Environment
    1. the Database System Environment
  6. Centralized and Client/Server Architectures for DBMSs
    1. Centralized and Client/Server Architectures for DBMSs
  7. Classification of Database Management Systems
    1. Classification of Database Management Systems.

2. Data Modeling Using Entity-Relational Model and Relational Model (8 LHs)

  1. Using High-Level Conceptual Data Models for Database Design
    1. Using High-Level Conceptual Data Models for Database Design
  2. Entity Types, Entity Sets, Attributes, and Keys
    1. Entity Types, Entity Sets, Attributes, and Keys
  3. Relationship Types, Relationship Sets, Roles, and Structural Constraints
    1. Relationship Types, Relationship Sets, Roles, and Structural Constraints
    2. Weak Entity Types
  4. ER Diagrams, Naming Conventions, and Design Issues
    1. ER Diagrams, Naming Conventions, and Design Issues
  5. Relationship Types of Degree Higher Than Two
    1. Relationship Types of Degree Higher Than Two
  6. Concepts of Specialization and Generalization
    1. Concepts of Specialization and Generalization
  7. Constraints and Characteristics of Specialization and Generalization
    1. Constraints and Characteristics of Specialization and Generalization
  8. Converting ER Schema to Relational Schema
    1. Converting ER Schema to Relational Schema
  9. Structure of the Relational Database
    1. Structure of the Relational Database.

3. SQL (12 LHs)

  1. Data Definition and Data Types
    1. Data Definition and Data Types
  2. Specifying Constraints
    1. Specifying Constraints
  3. Basic Retrieval Queries
    1. Basic Retrieval Queries
  4. Complex Retrieval Queries
    1. Complex Retrieval Queries
  5. INSERT, DELETE, and UPDATE Statements
    1. INSERT, DELETE, and UPDATE Statements
    2. Views.

4. Relational Database Design (8 LHs)

  1. Informal Design Guidelines for Relational Schemas
    1. Informal Design Guidelines for Relational Schemas
  2. Functional Dependencies
    1. Functional Dependencies
  3. Normal Forms Based on Primary Keys
    1. Normal Forms Based on Primary Keys
  4. General Definitions of Second and Third Normal Forms
    1. General Definitions of Second and Third Normal Forms
  5. Boyce-Codd Normal Form
    1. Boyce-Codd Normal Form
  6. Multivalued Dependency and Fourth Normal Form
    1. Multivalued Dependency and Fourth Normal Form
  7. Properties of Relational Decomposition
    1. Properties of Relational Decomposition.

5. Transaction Processing and Concurrency Control, and Recovery (8 LHs)

  1. Introduction to Transaction Processing
    1. Introduction to Transaction Processing
  2. Transaction and System Concepts
    1. Transaction and System Concepts
  3. Desirable Properties of Transactions
    1. Desirable Properties of Transactions
  4. Serializable Schedule
    1. Serializable Schedule
  5. Two-Phase Locking and Timestamp Ordering Concurrency Control Techniques
    1. Two-Phase Locking and Timestamp Ordering Concurrency Control Techniques.

6. Database Recovery Techniques (4 LHs)

  1. Recovery Concepts
    1. Recovery Concepts
  2. NO-UNDO/REDO Recovery Based on Deferred Update
    1. NO-UNDO/REDO Recovery Based on Deferred Update
  3. Recovery Technique Based on Immediate Update
    1. Recovery Technique Based on Immediate Update
    2. Shadow Paging
  4. Database Backup and Recovery from Catastrophic Failures
    1. Database Backup and Recovery from Catastrophic Failures.

7. Advanced Topics (4 LHs)

  1. Database Performance Tuning
    1. Database Performance Tuning
    2. Database Security
  2. Concept of Parallel and Distributed Databases
    1. Concept of Parallel and Distributed Databases
  3. Concept of Data Warehousing and Data Mining, BigData, and NoSQL databases
    1. Concept of Data Warehousing and Data Mining, BigData, and NoSQL databases.

8. Laboratory Works

  1. SQL Database and Table Creation
    1. Laboratory Works: The laboratory work includes writing SQL statements to create databases and tables
  2. Inserting and deleting data
    1. inserting and deleting data
    2. updating data
  3. Writing select queries
    1. and writing select queries.