Downloaded 38 times
Introduction to DBMS
- 1.
- 2. Data Data is raw,unorganized facts that need to be processed. Data can be something simple and seemingly random and useless until it is organized. Example:- Each student's test score is one piece of data. Information When data is processed, organized, structured or presented in a given context so as to make it useful, it is called information. Example:- The average score of a class or of the entire school is information that can be derived from the given data.
- 3. DATABASE A database (DB),in the most general sense, is an organized collection of data. More specifically, a database is an electronic system that allows data to be easily accessed, manipulated and updated. In other words, a database is used by an organization as a method of storing, managing and retrieving information.
- 4. DBMS DBMS standsfor Database Management System. We can break it like this DBMS = Database + Management System 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 & access those data in an easy and effective manner.
- 5. WHAT IS THENEED OF DBMS? Storage: According to the principles of database systems, the data is stored in such a way that it acquires lot less space as the redundant data (duplicate data) has been removed before storage. Fast Retrieval of data: Along with storing the data in an optimized and systematic manner, it is also important that we retrieve the data quickly when needed. Database systems ensure that the data is retrieved as quickly as possible.
- 6. FILE SYSTEM VSDBMS File Management System Database Management System File System is a general, easy-to-use system to store general files which require less security and constraints. DBMS is used when security constraints are high. Data Redundancy is more in file management system. Data Redundancy is less in database management system. Security is low in File Management System. Security is high in Database Management System. File Management System stores unstructured data as isolated data files/entities. DBMS stores structured data which have well defined constraints and interrelation.
- 7.