Page 170 - DCAP104_EXPOSURE_TO_COMPUTER_DISCPLINES
P. 170

Mandeep Kaur, Lovely Professional University                                     Unit 8: Database System



                                    Unit 8: Database System                                       Notes



             CONTENTS

             Objectives
             Introduction
             8.1  Database
                 8.1.1  Types of Database
                 8.1.2  Database Models

             8.2  The DBMS
                 8.2.1  Building Blocks of DBMS
             8.3  Working with Database
                 8.3.1  Relational Databases
                 8.3.2  Three Rules for Database Work

             8.4  Database at Work
                 8.4.1  Database Transaction
             8.5  Common Corporate DBMS
                 8.5.1  ORACLE
                 8.5.2  DB2
                 8.5.3  Microsoft Access

                 8.5.4  Microsoft SQL Server
                 8.5.5  PostgreSQL
                 8.5.6  MySQL
                 8.5.7  Filemaker

             8.6  Summary
             8.7  Keywords
             8.8  Self-Assessment Questions
             8.9  Review Questions
             8.10 Further Reading


            Objectives

            After studying this unit, you will be able to:
              • Explain Database.
              • Discuss DBMS.
              • Understand working with database.

              • Explain database at work.
              • Explain common corporate DBMS.




                                             LOVELY PROFESSIONAL UNIVERSITY                                   163
   165   166   167   168   169   170   171   172   173   174   175