Database Management System-I

Contents

1. Introduction to DBMS
1. Introduction
2. File System Versus Databases
2.1 Overview of a Database
2.2 Traditional File System Vs DBMS
3. Levels of Abstraction
3.1 Data Independence
4. Architecture of DBMS
5. Users of a DBMS
6. Advantages and Disadvantages of DBMS
7. Applications of Database
2. Conceptual Design
1. Overview of DB Design
2. Introduction to Data Models
3. Conceptual Design using E-R Model
3.1 Entities and Attributes
3.2 Types of Attributes
3.3 Relationships, Relationship Sets
4. Constraints
4.1 Mapping Cardinalities or Constraints
4.2 Representation of Mapping Cardinalities
4.3 Existence Dependencies
4.4 Integrity Constraints
5. Extended E–R Features
5.1 Conceptual Design Using E-R
6. Pictorial Representation of E–R Model
7. Structure of Relational Databases
7.1 Relational Model Concepts
7.2 Conversion of E-R to Relational Model
8. DBMS Vs RDBMS
9. Case Studies on E-R Model
3. SQL
1. Introduction to Query Languages
2. Basic Structure of SQL
3. Data Definition Language (DDL)
4. DML Commands
4.1 Insert Command
4.2 Delete Command
4.3 Update Command
5. Forms of a Basic SQL Query
5.1 Order By Clause And Simple Queries
6. Set Operations
7. Aggregate Function
8. Null Values
9. Nested Queries
9.1 Set Membership
10. SQL Mechanism for Joining Relations
11. Views
11.1 Views and Data Security
11.2 Update on views
4. Relational Database Design
1. Introduction to Relational Database Design
1.1 Undesirable Properties of RDB Design
2. Functional Dependency
2.1 Trivial Dependencies
2.2 Closure of an Attribute Set of Functional Dependencies, F+
2.3 Closure of Attribute Set
3. Concept of Decomposition
3.1 Problems Related to Decomposition
3.2 Desirable Properties of Decomposition
3.3 Dependency Preservation
4. Concept of Normalization
4.1 First Normal Form (1NF)
4.2 Second Normal Form (2NF)
4.3 Third Normal Form (3NF)
4.4 Boyce – Codd Normal Form (BCNF)
5. Key Concepts with Examples
5.1 An Algorithm for Finding the Candidate Key / Primary Key for a Relation R