Note for Database Management System - DBMS By Lovely Kiitian

Topics ( 24 )

Text from page-1

Introduction to Database System Chittaranjan Pradhan Database Management System 1 Introduction to Database System Data & Information Limitations of File-Processing Systems Database DBMS Database Types Advantages of DBMS over File System Chittaranjan Pradhan School of Computer Engineering, KIIT University 1.1

Text from page-2

Data & Information Introduction to Database System Chittaranjan Pradhan Data & Information Limitations of File-Processing Systems • Data • Raw facts, unprocessed facts • Refers to what is actually stored • Information • Result of processing raw data • Refers to meaning of the data, understood by the user Database DBMS Database Types Advantages of DBMS over File System Data management focuses on the generation, storage & retrieval of data 1.2

Text from page-3

Limitations of File-Processing Systems Introduction to Database System Chittaranjan Pradhan Data & Information Limitations of File-Processing Systems Database DBMS Database Types Advantages of DBMS over File System • Redundancy problem • Repetitive data • Data-inconsistency problem • Incorrectness of data • Lack of data integration • Complex and time consuming 1.3

Text from page-4

Introduction to Database System Database Chittaranjan Pradhan • Database is a collection of interrelated data • Database is a shared, integrated computer structure that stores: • End- user data: raw facts of interest to the end-user • Meta data: through which the end-user data are integrated & managed. The metadata provides a description of the data characteristics and the set of relationships that link the data found within the database Data & Information Limitations of File-Processing Systems Database DBMS Database Types Advantages of DBMS over File System • Database is an organized collection of data of an organization or enterprise 1.4