
Codds rules for a relational data base management system A DBMS can become
a relational data base management system if it satisfies the Codds
rules. There are 13 rules that should be satisfied for a DBMS to become
RDBMS. Codd was a pioneer for relational model and he framed these rules
so that no vendor dilutes the features of a relational database management
system.
The first rule states
that a RDBMS must use relations exclusively to manage the database and
second states that information should be represented in columns and
that should be the only way of representing the information. The third
rule states that all data should be accessible in the database when
they are referred by the table name, column name and by using the primary
keys. Capability to update all views is the seventh Codds rule. The eighth rule is about high-level insert, update, and delete of data. It should be possible to do these in set of rows and not in singles. The next rule is that the data stored at the physical level, in the form of linked lists or arrays should not be changed based on the structure of the application. The next is about logical data independence. The other rules state about integrity independence and distribution independence. The final rule is about any bypass to the relational security of integrity constraint should not be provided by the low-level interface of the system. If these Codds rules are followed in an DBMS then it qualifies to become a relational database management system.
| Benefits of data management course you take online | Benefits of effective customer data management | Codds rules for a relational data base management system | Features to expect in engineering data management systems | How to make use of a data management magazine | Make yourself employable for data management jobs | Pros and Cons of distributed data management | Strategic data management to improve your business | The need for effective data management strategy | Understanding the benefits of using network data management protocol | Using the right data management tools for managing data | What is data management |
|
|
||
|
|
|||
|
Copyright - © 2005 - 2012 - www.management-hub.com |
Management-Hub.com
Privacy Policy | Disclosure
| Disclaimer
| Contact
| |