Application Program: An application program is a program that is’ used to send commands to the database management system to manipulate database. These commands are sent to the DBMS through graphical user interface. The user interacts with the application program and the application program further interacts with the database management system. Relationship of Application Program and DBMS: A... 

The use of data base approach also has disadvantages. Some of disadvantages are as follows: High Cost of DBMS: A complete database management system is very large and sophisticated software. It is expensive to purchase database management software. Higher Hardware Cost: Database management systems are complicated and heavy software. Additional memory and processing power may be required to run... 

Database Management System: A database management system (DBMS) is a collection of programs that are used to create and maintain a database. DBMS is a general-purpose software system that provides the following facilities: 1. It provides the facility to define the structure of the, database. The user can specify the data types, format, and constraints for the data to he stored in the database. 2.... 

Following are some important examples of database: Phone Directory: Phone directory is a simple example of a database. A phone directory stores the phone numbers of different persons. You can search any phone number from the phone directory easily because all phone numbers are stored in an organized way. Library: A library contains thousands of hooks. It is very difficult to handle the records... 

Database can he defined as an organized collection of related data. The word organized means that data is stored in such a way that the user can store, manipulate and retrieve data easily. The word related means that a database is normally created to store the data about a particular topic. For example if you create a database for students, it will contain the data about the students such as roll... 

Atomicity Problem: When you perform an operation on data, it may consist of different steps. A collection of all steps required to complete a process is known as transaction. The atomicity means that either one transaction should take place as a whole or it should not take place at all. Suppose you want to transfer money from account A to account B. This process consists of two steps: 1. Deduct the... 

Data Isolation: The data in file processing system is stored in various files; it becomes very difficult to write new application, programs to retrieve the appropriate data. Suppose that student emails are stored in “Students” file and fee information is stored in “Fee” file. To send an email message to inform a student that the date for fee payment is over, you need data from both files.... 

In file processing system, the same data may be duplicated in several files. For example, there are two files “Students” and “Library”. The file “Students” contains the Roll No, name, address and telephone number and other details of all students in a college. The file “Library” contains the Roll No and name of those students who get a book from the library along with the information... 

Metadata can he defined as data about data. It is used to describe the properties and characteristics of some other data. Metadata describes the size, format and other characteristics of data. It also includes the rules and constraints about data. Example: When you create a table, you specify the data type, size, format and other constraints for entering data in different fields of the table. This...