DBMS

DBMS stands for "Data Base Management System", basically it stores a data with different methods of accessing it. To understand DBMS, first ask your self that why we need to store data?, in answer I want to give one example.

Example: Suppose you have created one C program for finding random value (between 0 to 499) of array index and print whatever value resides on that particular index of array, array is size of 500. You have to execute/run this program after every hour. Here note one thing value of array remain same every time, but we got different output every time because generated random value is different every time.

So you need to enter 500 value every time you execute the program. Now what happen if we store all the 500 values in a file (for example .txt file) and our C program read it every time when it execute. Because of that we do not need to enter all 500 values every time, it saves a lot of time and give faster performance of your program.
That's why we need to store data.

Content of DBMS Course is as Under:

CHAPTER 1

1) Basic Terms to Understand DBMS
2) Disadvantages of File oriented System
3) Advantages of DBMS
4) Applications of DBMS
5) Difference between File System and DBMS
6) Difference between Data Administrator (DA) and Database Administrator (DBA)
7) Role and Responsibilities of DBA

CHAPTER 2

1) Define Term: Schema, Instance and Sub-schema

2) Three level ANSI SPARC database system

3) Advantages of three-tier architecture

4) Data Independence

5) Mapping

6) Structure Components and Functions of DBMS

7) Types of Database System

CHAPTER 3

1) Data Types
2) Data Definition Language
3) Data Manipulation Language
4) Differentiate Single and multiple row function
5) Date functions
6) Numeric functions
7) Character functions
8) Conversion functions
9) Miscellaneous functions
10) Group functions
11) Order by, Group by and Having clause

CHAPTER 4

1) Structure of Relational Database
2) Domain
3) Keys of Relations
4) Relational Algebra
5) Implementing Relational Algebra using SQL
6) Set Operators
7) Joins
8) Sub queries (SQL)
9) Adding Views

CHAPTER 5

1) Domain Integrity Constraints
2) Entity Integrity Constraints
3) Referential Integrity Constraints

CHAPTER 6

1) Basic Entity-Relationship Concepts
2) E-R diagram symbols
3) Conversion of E-R model into Relations
4) Problems with E-R model
5) Specialisation and Generalisation