INTRODUCTION TO DATABASE Introduction Data is collection of

INTRODUCTION TO DATABASE

Introduction �Data is collection of facts and statistic for reference and analysis. This data resource is traditionally called the database. With the data base , the information is processed and easily converted into information to satisfy the information needs of organisation.

DATABASE HIERAREHY �Traditional databases are organized by fields, records, and files. A field is a single piece of information; a record is one complete set of fields; and a file is a collection of records. For example, a telephone book is analogous to a file. It contains a list of records, each of which consists of three fields: name, address, and telephone number. All these files are combined in a database. So database is a set of interreleated files which can be used by serval users for accessing data.

FILES Customer master Accounts receivable Vendor master Accounts receivable employee Payroll

DRAWBACKS OF FILE SYSTEM �DATA DUPLICATION �DATA INCONSISTENCY �LACK OF DATA INTEGRATION �DATA DEPENDENCE �PROGRAM DEPENDENCE

DATABASE-THE MODERN APPROACH �A database is an organised collection of records and files which are releated to each other. Customer master Vendor master employee DBMS Accounts receivable Accounts payables payroll

OBJECTIVES OF DATABASE I. Controlled data redundancy, II. Enhanced data consistency, III. Data independence, IV. Application independence, V. Easy to use, VI. Economical and VII. Recovery from failure

ADVANTAGES OF DATABASE v. Redundancy control v. Data consistency v. Management queries v. Data independence v. Enforcement of standards

DISADVANTAGES q Centralised Database q. More disk space q Operationality of the system q. Security risk

THANK YOU