DATABASE MANAGEMENT SYSTEM

           Database is a collection of related data. It is the electronic equivalent of a file cabinet a database management system(DBMS) or database manager is a program that sets up, or structures, a database. It also provides tools to enter, edit, and retrieve data from the database. All kinds of individuals use databases, from teachers recording grades to police officers checking criminal histories. Colleges and universities use databases to keep records on their students, instructors, and courses. Organiza tions of all types maintain employee databases

Three of the most widely used database management systems de signed for microcomput ers are Microsoft Access, Corel Paradox, and Lotus Approach.


                The relational database is the most widely used database structure. Data is or ganized into related tables. Each table is made up of rows called records and columns called fields. Each record contains fields of data about some specific person, place, or thing.


A DBMS provides a variety of tools to create and use databases. A sort tool will quickly re arrange a table's records according to a selected field. A filter tool will quickly display only those records meeting the conditions you specify.


The greatest power of a DBMS, however, comes from its ability to quickly find and bring together information stored in separate tables using queries, forms, and reports. A query is a question or a request for specific data con tained in a database. Database forms look sim ilar to traditional printed forms. These electronic forms are displayed on the computer monitor and typically reflect the contents for one record in a table. They are primarily used to enter new records and to make changes to existing records. Data from tables and queries can be printed in a va riety of different types of reports from a simple listing of an entire field in a table to a list of selected fields based on a query involving several tables.

Comments

Post a Comment

Popular posts from this blog

Automations and robotics

Automations and robotics refer to the use of technology to automate and perform tasks that were previously done by humans. Automation involves the use of software, machines, and other systems to perform tasks without human intervention. Robotics, on the other hand, involves the design and development of machines that can perform tasks autonomously or with limited human intervention. Automations and robotics are widely used in industries such as manufacturing, healthcare, transportation, and agriculture. In manufacturing, robots are used to perform repetitive and dangerous tasks, such as welding and painting. In healthcare, robots are used to perform surgeries and assist patients with mobility issues. In transportation, automated systems are used to control traffic flow and ensure the safety of drivers and passengers. In agriculture, robots are used to plant and harvest crops, reducing the need for manual labor. Advancements in technology have led to the development of more sophisticate...
Read more

Solid Pattern Program In Java Language

  import java.util.Scanner; class Demo {     public static void main( String args[])     {         Scanner sc= new Scanner(System.in);         System.out.println( "Print Solid Pattern" );         System.out.print( "Enter the value of n: " );         int n = sc.nextInt();         System.out.print( "Enter the value of n: " );         int m = sc.nextInt();         for ( int i= 1 ; i<=n; i++)         {             for ( int j= 1 ; j<=m; j++){             System.out.print( "*" );             }             System.out.println();         }     } } OUTPUT: Print Solid Pattern Enter the value of n: 4 Enter the value of n: 7 ******* ******* ******* **...
Read more

Palindrome Pattern Program In Java Language

  class Palindrome_Pattern {     public static void main( String args[]){         int n= 5 ;         for ( int i= 1 ; i<=n; i++){             //spaces             for ( int j= 1 ; j<=n-i; j++){                 System.out.print( " " );             }             //number--1st part             for ( int j=i; j>= 1 ; j--){                 System.out.print(j);             }             //number --2nd part             for ( int j= 2 ; j<=i; j++){                 System.out.print(j);             }           ...
Read more