What is Database? What is Database Management System?

-
Database: 
Database is a collection of inter-related data which helps in efficient retrieval, insertion and deletion of data from database and organizes the data in the form of tables, views, schemas, reports etc. For Example, university database organizes the data about students, faculty, and admin staff etc. which helps in efficient retrieval, insertion and deletion of data from it.

Database Management System

  • Database management system is a software which is used to manage the database. For example: MySQL, Oracle, etc are a very popular commercial database which is used in different applications.
  • DBMS provides an interface to perform various operations like database creation, storing data in it, updating data, creating a table in the database and a lot more.
  • It provides protection and security to the database. In the case of multiple users, it also maintains data consistency.

DBMS allows users the following tasks:
  • Data Definition: It is used for creation, modification, and removal of definition that defines the organization of data in the database.
  • Data Updation: It is used for the insertion, modification, and deletion of the actual data in the database.
  • Data Retrieval: It is used to retrieve the data from the database which can be used by applications for various purposes.
  • User Administration: It is used for registering and monitoring users, maintain data integrity, enforcing data security, dealing with concurrency control, monitoring performance and recovering information corrupted by unexpected failure.

Comments

Post a Comment

Popular posts from this blog

How to Install Java? How to set Paths in Java?

-
Image
Step-1: Download the JDK From official website is: https://www.oracle.com/technetwork/java/javase/downloads/index.html  and click on JDK download button for latest version Step-2: click on Accept License Agreement.  click the Download link that corresponds to the  . exe  for your version of Windows. Step-3: Run the JDK Installer .exe file Start the JDK 11 installer by double-clicking the installer's icon or file name in the download location. Follow the instructions provided by the Installation wizard. once installation is complete click on Close. For setting the permanent path of JDK, you need to follow these steps: 1. Open Advanced System Settings In Windows 10 press Windows key + Pause Key, This will open the System Settings window. Go to  Change settings  and select the  Advanced  tab. Alternatively: Open “Windows search” – you will find it next to the Windows logo open Windows 10 search ...
Read more

what are difference between C and C++?

-
Similarities between C and C++ are: Both the languages have the same syntax. Code structure of both the languages are same. the compilation of both the languages is about the same (not 100% sure, but it should be given that syntax & grammar are similar) They share the same basic syntax. Nearly all of C’s operators and keywords are also present in C++, and do the same thing. grammar, although C++ has a slightly extended grammar than Ruby that is all the OOP features introduce a few new operators but they both are similar else. Basic memory model of both is very close to the hardware. Same notions of stack, heap, file-scope and static variables are present in both the languages. Main Differences: C++ can be said a superset of C. Mainly added features in C++ are Object Oriented Programming, Exception Handling and Richer Library. Detailed Differences between C and C++ are: C C++ C was developed by Dennis Ritchie between the year 1969 and 1973 a...
Read more

What is char charAt (int index) in Java, and how can I use it?

-
Java String charAt() method The Java String charAt() method returns the character at the specified index. The index value should lie between 0 and length()-1. Signature: public char charAt(int index) Parameter: index- Index of the character to be returned. Return: returns character at the specified position. Exception: StringIndexOutOfBoundsException- If index is negative or greater then the length of the String. Example: To show working of  charAt()  method class Gfg {      public static void main(String args[])      {          String s = "Welcome! to Java Planet" ;              char ch = s.charAt( 3 );          System.out.println(ch);              ch = s.charAt( 0 );          Syst...
Read more