DBMS

Database is a collection of related data and data is a collection of facts and figures that can be processed to produce information. A database management system stores data in such a way that it becomes easier to retrieve, manipulate, and produce information.

Share WhatsApp

Course Overview

• Introduction to Database Systems

• Data Models

• Object based data models: E-R Model

• Concepts of DBMS

• Query Language: DDL, DML, TCL

• Database Users: DBA, Programmer, Other Users

• Data Independence: Logical & Physical

• Functional Dependencies & Closure of Functional Dependencies

• Types of Keys & Data Integrity

• Keys: Super Key, Candidate Key, Primary Key, Alternate Key, Foreign Key

• Constraints

• Normalization

• Working with databases & tables

• Using SQL Queries