DBMS Tutorials 28 Lessons

DBMS Database Languages

In the previous chapters, you have learned about the various forms of relational algebra and relational calculus and their uses with the database management system. In this chapter, you will get to know about the various forms of languages that […]

     

    Database Normalization

    • What is Database Normalization?
    • Facts about database normalization.
    • Database normalization rules.

      DBMS Methodology (Conceptual)

      In this chapter, you will learn about the methodology for the database design stage of the database system development lifecycle for relational databases. The methodology is depicted as a bit by bit guide to the three main phases of database […]

        DBMS Methodology (Logical)

        You have already come across the basics of what methodologies are and its stages. You have gathered the basic concept of what conceptual methodology is and how it works within the main stages of the database system development life cycle. […]

          DBMS Methodology (Physical)

          This physical methodology is the third and final phase of the database design methodology. Here, the designer must decide how to translate the logical database design (i.e., the entities, attributes, relationships, and constraints) into a physical database design which can […]

            DBMS Transaction

            Earlier you have learned about the functions that a Database Management System (DBMS) should offer database users. Among these there are 3 closely related functions that are intended to ensure that the database is reliable and remains in a steady […]

              DBMS Query

              When the relational model was launched for the first time, one of the chief criticisms often cited was the inadequate presentation of queries. Since then, a significant amount of research has been committed to developing highly proficient algorithms for processing […]

                Distributed DBMS

                Database technology has transformed the database users from a paradigm of data processing where each application described and uphold its data, to one in which data is defined and managed centrally. During recent times, you have seen the fast and […]

                  Database Replication

                  From the earlier chapter, you have got the idea of what a distributed Database management system is? In this chapter, you will be learning about the opposite of the previous concept and potentially more simplified version of data distribution provided […]

                    Mobile Databases

                    You might have noticed the ever-increasing demands on mobile computing for providing the types of support required by a growing number of mobile workers and its technology. Such individuals require working as if they are in the office, but in […]

                      Transaction and Concurrency Control

                      DBMS implements a concurrency control technique using a protocol which prevents database accesses from prying with one another.

                      • What is Transaction in DBMS?
                      • What is Concurrency Control in DBMS?

                      Data Recovery in DBMS

                      Data Recovery is the method of restoring the database to its correct state in the event of a failure at the time of the transaction or after the end of a process.

                      • What is Data Recovery?
                      • What is the Need for Recovery of data?
                      • Recovery Facilities.

                      Web-based Database Management System

                      The Web-based database management system is one of the essential parts of DBMS and is used to store web application data. Web-based Database management system is used to handle those databases that are having data regarding E-commerce, E-business, Blog, e-mail and other online applications.