Relational Data Model
"Dr. Edgar Frank Codd attempted to work on the working of DBMS to deal with enormous volume of information." He applied the rules of mathematics to solve the problem of earlier data model. Some important problems were as follows:
- Data Integrity
- Data Redundancy
Dr. Codd presented a paper A Relational Model of Data for Large Storage Databanks in June 1970 that contained 12 rule. A DBMS that satisfy these rules in called full Relational Database Management System (RDBMS).
Relational Basic Definition:
A relation is nothing more than a table. A Relational is a named two dimensional table of data. Each relation consists of a set of named names coulms and a number of unnamed rows. " Every Relational is a table but every table may or may not be a relation." Suppose we have two tables` table 1 and table 2 as.
0 Comments