DBMS Tutorial Library

29 Lessons

 

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 their 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 three closely related functions are intended to ensure that the database is reliable and remains in a steady-state, namely transaction support, […]

            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 upheld 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.

                      Database Security

                      Database security is the technique that protects and secures the database against intentional or accidental threats.

                      • What is Database Security?
                      • What is a Threat?
                      • Backup and Recovery.

                      Scroll Back to Top