Introduction to Database management system (DBMS)

  1.  What is Database  Management System?



A database system is a software system designed to manage and store large amounts of structured data. It allows users to create, access, update and manage data efficiently and securely.


A database consists of one or more tables, each of which contains columns and rows. A column represents a specific attribute or field in the table, while a row represents a single instance or record.

There are several types of database systems, including relational databases, document-oriented databases, key-value databases, graph databases, and more.

Relational databases are the most common type of database system used today. They store data in tables, where each table has a primary key that uniquely identifies each row in the table. Tables can be related to each other through foreign keys, allowing data to be organized and retrieved efficiently.

Database systems provide many benefits, including data consistency, data security, data integrity, and the ability to easily query and manipulate large amounts of data. They are widely used in many industries, including healthcare, finance, retail, and many more.

Comments

Post a Comment

Popular posts from this blog

Quick Revision for Multimedia and Animation - Vikatu

Image
Unit 1     Multimedia is a type of medium that allows information to be easily transferred from one location to another . Multimedia is the presentation of  text ,  pictures ,  audio , and  video  with links and tools that allow the user to navigate, engage, create, and communicate using a computer. Multimedia refers to the computer-assisted integration of text, drawings, still and moving images(videos) graphics, audio, animation, and any other media in which any type of information can be expressed, stored, communicated, and processed digitally. Multimedia is being employed in a variety of disciplines, including  education ,  training , and  business . Applications of Multimedia   Multimedia indicates that, in addition to  text ,  graphics / drawings , and  photographs ,  computer information  can be represented using audio, video, and animation. Multimedia is used in: 1. Education In the subject of education, multimedia is becoming so popular. It is often used to pr
Read more

Java Quick revision

Image
UNIT I Parameters Java C++ First Release The Java language came into existence on 23rd May 1995. The C++ language first came into existence in October 1985. A stable form of Release The JDK 14 or Java SE was finally released on 17th March 2020. The C++ 17 was released back in December 2017. Founder James Gosling developed Java at Sun Microsystems. Bjarne Stroustrup developed C++ at Bell Labs back in 1979 in the form of an extension to the C language. Platform Dependency The Java bytecode can easily work on any given OS (operating system). It is very much platform-independent. The C++ language is platform-dependent. It means that we need to compile it for a different platform. Official Website The official website for Java is oracle.com/java The official website for C++ is isocpp.org Influenced By The C#, C++, Pascal, Ada 83, and many more languages have an influence on the Java language. Smalltalk, Simula, ML, C, ALGOL 68, Ada, and many more languages have an influence on the C++ langu
Read more

Quick revision for software engineering by vikatu

Image
UNIT I Software characteristics refer to the qualities or attributes that define the behavior, functionality, and performance of a software system. These characteristics help in evaluating, understanding, and designing software effectively. Here are some common software characteristics: Functionality : It refers to the extent to which the software performs its intended tasks. A software system should meet the specified requirements and provide the desired features to users. Reliability : This characteristic indicates the ability of the software to perform consistently and predictably under various conditions. Reliable software should be robust and resilient to errors and failures. Usability : Usability measures how easy it is for users to interact with the software. It involves aspects such as user interface design, intuitiveness, simplicity, and accessibility. Efficiency : Efficiency relates to the optimal use of system resources (such as CPU, memory, and disk space) to achieve desire
Read more