Introduction to RDBMS

• Concepts 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.