Course Content

Access all course materials including chapters and laboratory exercises for Database Management Systems

Course Chapters

PowerPoint presentations covering theoretical concepts and principles

Introduction to Database

Database ConceptsDBMS BasicsData Models

Database Systems and Architecture

DBMS ArchitectureSystem ComponentsDatabase Structure

The Relational Data Model and Constraints

Relational ModelConstraintsData IntegrityTables

Entity-Relationship (ER) Model

ER DiagramsEntity SetsRelationship SetsAttributes

Basic SQL

SQL QueriesSELECTINSERTUPDATEDELETE

ER-to-Relational Mapping

ER MappingDatabase DesignSchema Translation

Normalization

Normalization1NF2NF3NFBCNF