Explanation : This rule ensure that for a software to qualify and act as an RDBMS, the system must manage the database through its relational capabilities.
Explanation : The information of data in the relational database is stored in rows and column in the form of tables.
Explanation : Each and every atomic value is accessible by using the combination of Name of table(row), Primary-Key(column) and Name of attribute. Use of concept of pointers is not allowed.
Explanation : Support for NULL value acceptance is checked using this rule. It means table can have a missing or no value field and DBMS must support it to be called as an RDBMS.
Explanation : The description of structure of the whole database needs to be stored online which only can be accessed by authorized or permissible users/personals.
Explanation : Multiple language support is required. It means, relational database languages such as SQL, OCL, TQL can be used, only if they are able to manipulate the data. Manipulation includes, creation of database, implementation, security and data retrieval. There must be support of at least one language to cater all the above mentioned request.
Explanation : The number of possible views of a database system which can be manually altered or updated, this rule requires the system to perform this task automatically too.
Explanation : This rule ensures that the database system must be able to support the insertion, deletion and updation function with the help of any query language such as SQL.
Explanation : Any changes or alteration in the physical structure of the database must not affect or change or manipulate the data stored in the database.
Explanation : Any changes or alterations in the logical structure of the database(such as changes in view of tables) must not affect or change the end user’s view and ability to interact with the database.
Explanation : Databases must need to support integrity constraints such as primary key value must be not NULL and other constraints such referential integrity constraint must be followed.
Explanation : The application view database known to user must have an abstract view. It means for request of data made by users, the user should feel that data is getting retrieved from a single location rather than multiple location. There must not be any delay while retrieving data.
Explanation : If database system allows users to access the low level views of database files, one cannot violate rules and constraints defined for the database files by producing any changes to the database files.
Note : For further details on EF Codd Rules, kindly visit THIS. |