Course Content
Detailed Content of Database Management System
0/1
About Lesson

Database System:

1. Application Program:

A Database Application is a Computer Program whose Primary Purpose is Retrieving Information from a Primary Purpose is Retrieving Information from a Computerized Database. From here Information can be Inserted, Modified or Deleted which is subsequently conveyed back into the Database.

2. Software to Process Queries:

DBMS is Software Systems used to Store, retrieve, and Run Queries on Data. A DBMS serves as an Interface between an end-user and a Database, allowing user to Create, Read, Update, Delete data in the Database.

3. Software to Store Data:

A DBMS is used for Storing, Manipulating, and Managing data in a Database Environment. It enables users to design a personalized database to meet their Analytics and Reporting needs.

4. Stored Database Definition (Meta Data):

Meta Data is Simply defined as data about data. It means it is description and context of the data. It helps to Organize, find and understand data.

5. Stored Database:

A Database is an organized Collection of Structured Information, Data, Typically Stored Electronically in a Computer System.

Example:

Consider a College Database for maintaining Information concerning Students, Course and Grades in a college. This figure shows the database structure and a few sample data for such a Database. The Database is organized as three files, each of which stores data records of the same type.