DATABASE MANAGEMENT SYSTEM (DBMS)
NEED FOR DBMS? A Database is an organised, persistent collection of data of an organisation. · The File Based System . File based system are an early attempt to computerize the manual filling system. For example, a manual file can be set up to hold all the correspondence relating to a particular matter as a project, product, task, client or employee. The manual filing system works well when the number of items to be stored is small. · The Database Approach. A database is a persistent collection of logically related data . A DBMS controls access to this data and thus needs to provide feature for database creation, data manipulation such as data value modification, data retrieval, data integrity and security etc. Advantage. 1. Reduction of redundancies 2. Shared data 3. Data independence 4. ...