×
Start where you are. Use what you have. Do what you can.
--Your friends at LectureNotes
Close

Note for Database Management System - DBMS By Lovely Kiitian

  • Database Management System - DBMS
  • Note
  • KIIT University - KIIT
  • Computer Science Engineering
  • 24 Topics
  • 8115 Views
  • 110 Offline Downloads
  • Uploaded 11 months ago
0 User(s)
Download PDFOrder Printed Copy

Share it with your friends

Leave your Comments

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

Text from page-5

DBMS Introduction to Database System Chittaranjan Pradhan • DBMS (Database Management System) is a collection of programs that manages structure & controls access to the data stored in the database • It includes tools to add, modify or delete data from the database, ask questions (or queries) about the data stored in the database and produce reports • DBMS serves as the intermediary between the user & the Data & Information Limitations of File-Processing Systems Database DBMS Database Types Advantages of DBMS over File System database 1.5

Lecture Notes