Skip to main content

Posts

Showing posts from June, 2018

Database Management System rules and protocols by E.F. (Edger Frank) Codd or EF CODD's Rules

Edger Frank aka E.F. Codd suggested some rules to follow while implementing a relational DBMS. He suggested that a relational database should follow the following rules so that it would work functionally efficient and it will also avoid the unnecessary background operation of the system. Database Management System rules and protocols by E.F. (Edger Frank) Codd or EF CODD's Rules: Information Rule : A set of related tables forms a database and all data is represented as tables, the data can be viewed in no other ways.Guaranteed Access : Each value can be accessed by specifying tables name, primary key 7 column name. This way each & every value is uniquely identifiable & accessible. Basically its a restatement of the fundamental requirement for primary keys.Each piece of data must be logically accessible by referencing A Table, A Primary/Unique Key and A Column.Systematic Treatment of Null Values : Null must be always be interpreted as an unknown value. Dynamic online catalog …