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 b...
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...