View RSS Feed

Java Database

  1. Integrity Rules

    by , 03-09-2012 at 08:26 PM
    It shall be ensured by the relational tables that data is always accessible and accurate. To do this, implementation of the integrity rules is required. These rules shall be followed.
    • There shall be uniqueness in a table’s rows.
    • Correct results are not found easily and accessing data might result into certain issues. This happens when duplicate rows are present.


    Rules can be applied by user in most DBMS that duplicated rows are not permitted. In those cases, the insertion ...
    Categories
    SQL