Introductory Database syllabus

Introductory Database

• 1 Introduction to DBMS (5 LHs)

  • Introduction to Database Management System
  • DBMS vs File System
  • View of Data and Data Models
  • Database Languages: DML and DDL
  • Database Users and Administrators
  • Transaction Management
  • Database System Structure and Application Architectures
• 2 Types of DBMS (2 LHs)

  • Types of DBMS
  • Relational DBMS
  • Object-oriented Database Management System
• 3 Data Models (5 LHs)

  • Basic Concepts, Constraints, Keys, and Design Issues
  • Entity Relationship Database Model
  • Weak Entity Sets and Extended E-R Features
  • Design of an E-R Database Schema
  • Reduction of an E-R Schema to Tables
• 4 Relational Database Model (5 LHs)

  • Structure of Relational Databases
  • Data Integrity and Integrity Constraints
  • Relationships within the Relational Database
• 5 Entity Relationship Modeling (6 LHs)

  • Entity Relationship Modeling
  • Entities, Attributes, and Relationships
  • Degree of a Relationship
  • Connectivity and Cardinality
  • Specialization and Generalization Entity Relationship Diagram
• 6 Structured Query Language (7 LHs)

  • SQL and Data Definition Language
  • SQL Constraints and Creating Tables
  • Data Manipulation Languages
  • SELECT Queries and Syntax
  • SQL Views and JOIN
• 7 Distributed Database Management Systems (5 LHs)

  • Distributed Database Management System
  • Characteristics, Advantages, and Disadvantages of DDBMS
  • Components of a Distributed Database System
  • Distributed Database Design
  • Horizontal and Vertical Fragmentation
• 8 Database Security (5 LHs)

  • Authorization and Privileges in SQL
  • Roles and Granting Privileges
  • Limitations of SQL Authorization
• 9 Designing Good Designed Database (5 LHs)

  • Normalization
  • Functional Dependencies
  • Update Anomalies
  • First through Fifth Normal Forms