Database Management System Course

Database Management System

Database management system is software which allows to store and manipulate various operation on database. The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data. Dbms is actually a tool used to perform any kind of operation on data in database.

Database management system has 4 components Users, Database application, DBMS and Database.

DBMS facilitates fast data access, minimal duplication, easy retrieval of data etc….

DBMS contains following topics at TCCI:

Part-I: Database

Introduction to DBMS, Requirements of Database, Disadvantages of File, Architecture, Data Models, Data schemas, Data independence, ER Diagram, Cod’s Rules, RDBMS concepts, Keys, Normalizations

Part-II: SQL

Sql introduction, DDL command, DML command, DCL command, Advanced SQL, Sql Constraints, Sql Function