Image of RDBMS |
RELATIONAL DATABASE MANAGEMENT SYSTEM
- RDBMS means relational database management system which is based on relational model.
- Which follow the rules of codd’slaw.
- RDBMS to store and access the data from the related table.
NAMING CONVERSION
DBMS RDBMS
1. Fields === Column and Attribute
2. Record === Row, Entity ,Tuple
3. File === able, Relation and Entity class.
The Rules of codd’s law.
Rule 1: The information rule: All information in the database must be represented in one and only one
way (that is, as values in a table).
Rule 2: The guaranteed access rule: All data should be logically accessible through a combination of
table name, primary key value and column name.
Rule 3: Systematic treatment of null values: A DBMS must support Null Values to represent missing
information and inapplicable information in a systematic manner independent of data types.