Database Management System Suggestions (DBMS)

 Database Management System Suggestions 

Chapter-1:

1)    Definition, Types, Examples

2)    DBMS vs RDBMS, File System vs DBMS

3)    DBMS Architecture

4)    Instance, Schema

5)    DBMS Languages

6)    ACID Properties

 

Chapter-2:

1)    ER Diagram.

2)    Cardinalities, Relationship

3)    Mapping Constraints

4)    Keys

 

Chapter-3:

1)    DBMS Relational Algebra Concept

2)    Relational Algebra Query

 

Chapter-4:

1)    Functional Dependency

2)    Normalization (1NF, 2NF, 3NF, BCNF)

 

Chapter-5:

1)    Theory on Joins, Aggregate Functions, Group by, Having, etc.

2)    SQL query

 

Chapter-6:

1)    RAID Theory in DBMS

2)    Data Center.