Database Management Systems (DBMS) KNEC notes

Description

CHAPTER 1: INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS
Introduction to Database management system (DBMS)
Advantages of DBMS
Meaning of “database system
Components of DBMS
Database Access Language
Users (role of key players in database design and development)
Evolution of DBMS
Current Trends
Definition of the database approach
CHAPTER 2: DATABASE ORGANISATION
Meaning of Database Organization
Database Organization – Types/Approaches
CHAPTER 3: PRINCIPLES AND TECHNIQUES OF DATABASE DESIGN
Introduction to Database design Principles
The database life cycle (DBLC)
Basic Design Principles
Types of Database Modeling Techniques
CHAPTER 4: RELATIONAL DATABASE SYSTEM
Introduction to relational database management system
Characteristics of Relational Databases
Relational algebra
Relational Algebra Types and Operations
Set Operations on Relations
Selection (σ)
Projection (Π)
Join
Implementing Set Operations
Expressing Queries in Relational Algebra
Relational calculus
The Tuple Relational Calculus [TRC]
The Domain Relational Calculus [DRC]
CHAPTER 5: ENTITY RELATIONSHIP
Introduction and meaning of Entity Relationship
Connotations of Entity Relationship
Data Models
CONCEPTUAL DATA MODEL
LOGICAL DATA MODEL
PHYSICAL DATA MODEL
Drawing ERD
Conceptual ERD Symbols
Physical ERD Symbols
CHAPTER 6: NORMALIZATION
Introduction and meaning of Database normalization
Importance of normalization
Forms of normalization/Normalization rules
First normal form (1NF)
Second normal form (2NF)
Third normal form (3NF)
Fourth normal form (4NF)
Fifth normal form (5NF)
Performing Normalization by example
CHAPTER 7: QUERYING A DATABASE
Definition and Meaning of Database Query
SQL Features of Query language (SQL)
SQL Commands and categories
SQL statements/Queries design and interrogation of database
SQL statement design
SQL database interaction
More SQL commands
CHAPTER 8: FUNCTIONS OF DBMS
Introduction to DBMS functions
Importance of DBMS
DBMS Functions
CHAPTER 9: EMERGING TRENDS
Trends in Database Management
The Top Challenges and Solutions of Database Management