BIJU PATNAIK UNIVERSITY OF TECHNOLOGY, ODISHA Lecture Notes On DBMS Prepared by, Dr. Subhendu Kumar Rath, BPUT, Odisha.
Prepared by: Dr. Subhendu Kumar Rath DBMS: Basic Concepts 1. Introduction 2. Disadvantages of file oriented approach 3. Database 4. Why Database 5. Database Management System(DBMS) 6. Function of DBMS 7. Advantages of DBMS and disadvantage of DBMS 8. Database Basics 9. Three level architecture of DBMS 10. Database users 11. Database language 12. Database structure Introduction: In computerized information system data is the basic resource of the organization. So, proper organization and management for data is required fro organization to run smoothly. Database management system deals the knowledge of how data stored and managed on a computerized information system. In any organization, it requires accurate and reliable data for better decision making, ensuring privacy of data and controlling data efficiently. The examples include deposit and/or withdrawal from a bank,hotel,airline or railway reservation, purchase items from supermarkets in all cases, a database is accessed. What is data: Data is the known facts or figures that have implicit meaning. It can also be defined as it is the representation of facts ,concepts or instruction in a formal manner, which is suitable for understanding and processing. Data can be represented in alphabets(A-Z, a-z),in digits(0-9) and using special characters(+,-.#,$, etc) e.g: 25, “ajit” etc. Information: Information is the processed data on which decisions and actions are based. Information can be defined as the organized and classified data to provide meaningful values. Eg: “The age of Ravi is 25” File: File is a collection of related data stored in secondary memory.