DBMS BCA Unit-1 DBMS - Introduction The File Based System Database System vs. File Based System Limitations of File Based System Database System Components Advantages of Database Approach DBMS ARCHITECTURE Three Level Architecture of DBMS External or View Level Conceptual Level Internal or Physical Level Data Independence Physical DBMS Architecture Database Manager Database Users Database Administrator (DBA) Roles and Responsibilities of DBA Data Models The Relational Data Model The Network Data Model The Hierarchical Data Model MySQL Installation in Ubuntu


Responsive image

Unit_1: Introduction

Unit 1: Introduction (12 hrs.)

Characteristics of the Database Approach - Database users : DBA, Database Designers, End users - Advantages of using the DBMS Approach - Data models, Schemas, and Instances - ThreeSchema Architecture and Data Independence. DBMS Languages: DDL, DML - The Database System Environment: DBMS Component Modules.
Database is a collection of data and Management System is a set of programs to store and retrieve those data. Based on this we can define DBMS like this:
  • DBMS is a collection of inter-related data and set of programs to store and access those data in an easy and effective manner.
  • A database system is basically a computer based record keeping system.
  • A DBMS is a collection of interrelated data and a set of programs to access those data.
  • The primary goal of a DBMS is to provide a way to store and retrieve database information.