E.f codd rules for RDBMS which makes any database as Relational Database
E.F. for RDBMS Codd had created 12 rules that, if followed by a database management system, that DBMS can be called Relational Databases Management System.
Rule 0: Foundation rule - Every Relational database
Rule 1: Rule of Information - All the information available in the relational database should be kept in the same form as a table.
Rule 2: Rule of Guaranteed Access - It should be ensured that every data in the database is accessed based on table name, primary key and column name etc.
Rule 3: Rule of Systematic Null Value Support - While we insert insertion of records in the database, many values are omitted by us, which should be treated as null values in the relational database, null value is neither Blank Space. And there is no zero.
Rule 4: Rule of Comprehensive Data Sub-language - It is necessary to have at least one language support through each database, usually SQL - Structure Query Language is used in all RDBMS.
Rule 5: Rule of Active and online relational Catalog - In the same way as the data is accessed in a relational database, the database structure should also have access to it.
Rule 6: Rule of Updating Views - In a relational database, the methods of logical representation of a table are called View. Each View should support a similar Full Range of data manipulation.
Rule 7: Rule of Set level insertion, update and deletion - Insert updates and delete functions in relational databases should be done in a single statement.
Rule 8: Rule of Physical Data Independence - The physical method to obtain and store information from the database must be separate from the user.
Rule 9: Rule of Logical Data Independence - The logical structure of the database or changes made in the table, which should not be read on the data viewing method.
Rule 10: Rule of Integrity Independence - The database must have the necessary constraints in the database to maintain the integrity of the data being input by the user. OR In this rule any component of Primary key can not contain NULL values
Rule 11: Rule of Distribution Independence - When working in a relational database, the user should be completely unaware whether the database is distributed or not.
Rule 12: Rule of Non Subversion - In this rule, the database structure or database can not be modified without any change.In addition to the database language, there should not be any other rule to change the database structure.
E.f codd rules for RDBMS which makes any database as Relational Database
TEchMyEducation
easy tech learning....
TEchMyEducation
easy tech learning....
I just want to say that all the information you have given here is awesome...great and nice blog thanks sharing..Thank you very much for this one.And i hope this will be useful for many people.. and i am waiting for your next post keep on updating these kinds of knowledgeable things.
ReplyDeleteWebsite Design Company in Pune
thanks for sharing.Passive Networking
ReplyDeleteStructured Cabling