Archive for the ‘Notes’ Category

  • The Relational Model and Normalization

    Oct 23, 13 • 8178 Views • Notes • • 1 Comment

    A Relational Database Management System (RDBMS) is a database management system that is based on the relational model as introduced by Dr. E.F. Codd. Every model should be according to the Codd rules or it satisfies Codd Rules. But in practice there is no

  • Database Redesign

    Oct 23, 13 • 5602 Views • Notes • • 2 Comments

    Data is the most important part and need of database. It is the fundamental component of an information system. Through database design, we can arrange the required data for the organisation and arrange them in an organised structure. The ER approach has

  • Data Modeling with ER model

    Oct 21, 13 • 2867 Views • Notes • • No Comments

    A model is an abstraction process that concentrates essential and inherent aspects of the organisation’s  applications. It is a representation of the real world objects and events and their associations. A data model is a mechanism that provides this

  • Concept of ODBC

    Oct 21, 13 • 2329 Views • Notes • • No Comments

    ODBC stands for open database connectivity. It is a standard software API specification for using database management system. The ODBC interface enables windows applications to access the data from variety of data sources. SAS or ACCESS software enables you

  • Oracle in Database Engineering and Grid Computing

    Oct 18, 13 • 1965 Views • Notes • • No Comments

    Now a days Oracle is widely used in each and every organization, industry, and corporate sector. It runs virtually on any computer system. Nothing to worry about its desired system or platform. Like Java, it runs in any platform. Oracle is the largest