Skip to main content

     RDBMS


RDBMS:

  • It stands for relational database management system
  • so the data is stored in the form of the relational model
  • The RDBMS is developed by CODD   when he was working at IBM company in the year 1970
  • so CODD came up with one decision he decided that any information must come to the table





CODD'S RULES

  •  If we satisfy more than 7 rules we can say it is a relational database model

RULE NO 1:- INFORMATION RULE

  •  Every  information must be in the form of rows and columns only
  • any kind of information that must be displayed the basics of  information

RULE NO 2:- GUARANTEED ACCESS RULE

  • It means every piece of information must be accessed and have permission to read and make changes 

  • Every single data element (value) is guaranteed to be accessible logically with a combination of the table name, primary key (row value), and attribute name (column value).

RULE NO 3:-SYSTEMATIC TREATMENT OF NULL VALUES

  • The NULL values in a database must be given a systematic and uniform treatment.
  • If there are no values we can say it contains NULL values
  • Whatever data does not come into the  table we can be called NULL values
  • NULL values means missing values, inconsistent data ..etc

RULE NO 4:-DYNAMIC ONLINE CATALOG BASED ON RELATIONAL MODEL                                    





Comments

Post a Comment

Popular posts from this blog

                            Data Science        This article tells about the data science introduction, descriptive, diagnostic, predictive and perspective, database management system, data models -conceptual data model, logical data model, physical data model, object-oriented data model, relational data model, and history of data models , hierarchical database management system, network database management system, relational database management system      Data    Data is nothing but a piece of information (OR) we can say data is a collection of record   Data can be of different types, such as numerical, categorical, text, image, audio, and video data.   Data can be collected through various sources such as surveys, experiments, observations, sensors, and social media platforms                Science  S...
Post a Comment
Read more