Archive for the ‘Notes’ Category

  • Structured Query Language

    Sep 27, 13 • 3273 Views • Notes • • No Comments

    Structured Query language (SQL) is a standard language for making queries in relational database management packages such as SQL server, Ingress, Sybase, Oracle, etc. SQL  is a fourth generation language and it is very simple and powerful language because

  • Data Warehousing

    Sep 27, 13 • 1637 Views • Notes • • No Comments

    Data warehousing is the process of gathering information from different parts of a business process in a centralized database. It can be defined as the collection of data that is used by employees in an organisation for easy access and smooth running. Since

  • Distributed Database

    Sep 26, 13 • 6050 Views • Notes • • No Comments

    A distributed database system is a database which is stored in various storage devices which are neither physically connected to each other nor they are connected to a common Central Processing Unit. Distributed database system is a collection of data with

  • Entity Relationship Model

    Sep 26, 13 • 3664 Views • Notes • • No Comments

     As we all know that modelling is a very important phase in designing the database applications. Database applications define a particular database and programs that implement the database queries and updates. Such as, a bank database application keeps track

  • Physical Database Design

    Sep 26, 13 • 1403 Views • Notes • • No Comments

    As we all know that the data is an important resource of an organisation and the database is the most fundamental component of an information system. Therefore, management and control of data and database is very important. Database design is the process of