Introduction to RDBMS
DBMSConcepts of RDBMS:This part gives you details about the basic concepts like how the data is viewed in Relational Database management system and advantages of RDBMS over other systems.
Codd's rules: defines the relational completeness of a DBMS.
Primary keys: Any column or a set of columns that uniquely identify rows of a Table.
Entity integrity: The primary key of a table should not be partially or wholly NULL.
Referential integrity: No foreign key value may reference primary key that does not exist.
Normalization: It is a technique that logically groups the data over a number of tables, which are independent and contain no unnecessary data.
Structured Query language(SQL): It is a high level, set oriented, interactive database language for RDBMS. Used for definition and manipulation of database objects.