| It's a computer world and data is saved electronically in | | | | in different file formats. |
| the form of files to avoid heaps of papers and files. | | | | • Difficulty in accessing data. |
| File system is a method for storing and organizing | | | | • Need to write a new program to carry out |
| computer files and data they contain to make it easy | | | | each new task. |
| to search and access them. File system provides | | | | • Integrity problems |
| access to data which is saved on a data storage | | | | • Atomicity of updates |
| device like hard disk where it maintains physical | | | | • Concurrent access by multiple users |
| location of the file for easy accessibility. | | | | • Security problems |
| For example, if you want to store the wedding | | | | Database systems offer solutions to all the above |
| anniversaries and birthdates of your relatives and | | | | problems. There are number of databases available in |
| friends, you can store them in file and this file will be | | | | the market like MS Access, DB2, My SQL, FileMaker |
| saved at some location of your hard drive so that you | | | | Pro, SQL Server, Oracle and many more. . Amongst |
| can easily retrieve the information stored in this file. But | | | | all, Microsoft Access is the widely used database to |
| when data becomes more to handle and it creates | | | | store and retrieve information in organizations. |
| problems in accessing those files, the file system | | | | Microsoft Access provides users with one of the |
| saving process also becomes poor in terms of | | | | simplest and most flexible RDBMS solutions in the |
| accessibility and retrieval. In such cases traditional file | | | | market today. Database solutions for MS Access has |
| system is in-efficient and in-convenient to use. | | | | been designed to help & assist Microsoft Access 97, |
| To store huge amount of data, businesses, corporate, | | | | 2000, 2002 (XP), 2003 and 2007 database users and |
| organizations are now using Data Base Management | | | | developers of database applications to find answers |
| Systems (DBMS). It contains information about a | | | | of some frequently asked questions. It includes facilities |
| particular enterprise. It is a collection of interrelated | | | | to add, modify or delete data from the database, ask |
| data, set of programs to access data , and an | | | | questions (or queries) about data stored in the |
| environment that is both convenient and efficient to | | | | database and produce reports summarizing selected |
| use. Today, DBMS are used in each and every field | | | | contents. For example, organizations, corporates |
| like banking, airlines, sales, human resources, on-line | | | | maintain database of their employees such as emp_id, |
| retailing, and manufacturing. | | | | emp_name, designation, salary, address, |
| Previously, database application were built directly on | | | | date_of_joining, highest qualification using MS Access |
| top of file systems but data storage using file system | | | | database. Information like what's the name of an |
| resulted in to certain drawbacks, like | | | | employee and designation whose emp_id is 56 can be |
| • Data redundancy and inconsistency | | | | easily retrieved from MS Access database. |
| • Multiple file formats, duplication of information | | | | |