• Relational Database - Codd's Rules

    Relational Database - Codd's Rules !!!

    A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd. Most popular commercial and open source databases currently in use are based on the relational database model.

    A short definition of an RDBMS may be a DBMS in which data is stored in the form of tables and the relationship among the data is also stored in the form of tables.




    Codd's Rules
    • All database management must take place using the relational database's innate functionality
    • All information in the database must be stored as values in a table
    • All database information must be accessible through the combination of a table name, primary key and column name.
    • The database must use NULL values to indicate missing or unknown information
    • The database schema must be described using the relational database syntax
    • The database may support multiple languages, but it must support at least one language that provides full database functionality (e.g. SQL)
    • The system must be able to update all updatable views
    • The database must provide single-operation insert, update and delete functionality



    • Changes to the physical structure of the database must be transparent to applications and users.
    • Changes to the logical structure of the database must be transparent to applications and users.
    • The database must natively support integrity constraints.
    • Changes to the distribution of the database (centralized vs. distributed) must be transparent to applications and users.
    • Any languages supported by the database must not be able to subvert integrity controls.

    Tags: database, table, DBMS, RDBMS, columns, Codd, E. F. Codd, rules, oracle, data

    ================================================
    O************************O***********************O

0 comments:

Leave a Reply

.

FEEDS FROM THIS BLOG

FEEDJIT Live Traffic Feed

My Zimbio   Blog Directory - OnToplist.com   Red Hat Enterprice Linux RHCE RHCT RHCA RHCSS  Powered by  MyPagerank.Net  Academic blogs & blog posts   BlogRankers.com  TopOfBlogs  BuzzCritic     Academics  Blog Directory  Hihera.com  Technology Blogs - Blog Rankings   Visit blogadda.com to discover Indian blogs  Academics Blogs  Computers (Linux) - TOP.ORG    Rallyshare    Yahoo bot last visit powered by MyPagerank.Net     The Weblog Review  blogarama - the blog directory  SEO services    Academic blogs & blog posts