1.2.2 Advantages of file based system over paper based system with examples

Database Management System is a collection of inter related data and a set of programs to manipulate those data.
Data is a raw or isolated facts which can be stored or recorded.
Information processed or organized data.
Database is a collection of inter related data.
Management is a manipulation, searching and security of data.
System is Programs or tools used to manage database.
Data is Row materials used to derive information where Information is Product derived from Data.
Meta data is data about data.
Data field is a character or group of characters and it have specific meaning.
Record is a collection of logically related fields.
System catalog is a system created database.
Data dictionary contains metadata.
Data Warehouse is large storage of historical data.
DA means Data Administrator
DBA means Database Administrator
DA determines which data to be stored in database basis on requirement of the organization.
Role of DA is requirements gathering, analysis, and design phases.
There is no strict requirement of technical person in DA, it may be non technical person also.
DA is senior employee of the organization.
DBA provides technical support for implementing a database.
Role of DBA is design, development , testing, and operational phases.
DBA is a technical person which requires knowledge of database technology.
There is difficult to find and maintain records in paper based system.
File based system working good as compare to paper based system.
Back up, Compactness, Data Retrieval, Editing, Remote access and sharing are advantages of file based system

[jigneshkarkariya]

મેડમ, DBMS ના બધા chapters ઉપર વિડિયો સિરીઝ બનાવી આપશો !
તો તમારો ખૂબ ખૂબ આભાર .
Please DEVVRAT Knowledgevilla

1. INTRODUCTION TO DATABASE SYSTEM .

2. DATABASE SYSTEM ARCHITECTURE .

3. INTRODUCTION TO STRUCTURED QUERY LANGUAGE (SQL) .

4. RELATIONAL ALGEBRA AND IMPLEMENTATION USING SQL.

5. DATABASE INTEGRITY CONSTRAINTS.

6. ENTITY RELATIONAL MODEL .