The Life and Contributions of Dr. Edgar F. Codd

Before the end of the war he was promoted to the lieutenant of the British Air Force Coast Commander. After the war he studied after returning to Oxford and changed his major to mathematics. He finally got a mathematics degree in 1948. In the meantime, Cod recognized that the United States must provide itself to as many people as himself (date). As part of the British Air Force service, he was stationed in the US for a short air training duration. This is when Cod found his love of leisure travel.

The term "relational database" was invented by EF Codd at IBM in 1970. Codd introduced this term in his research paper "Data Relation Model of Large Scale Database". In subsequent papers he has defined the meaning of "relations". A well-known definition of a relational database system consists of 12 rules of Codd. However, as most of the initial implementation of the relational model did not comply with all Codd rules, this term gradually formed a wider database system class. It should be at least as follows.

In 1970 IBM's British computer scientist Edgar F. Codd announced "Data Relation Model of Large Scale Database". At the time, this famous paper attracted a lot of attention, but few people understood how Codd's innovative work would define the basic rules of relational data storage . Provide Relational Operator - Code that allows you to test the relationship between two entities. A good example is the WHERE clause of the SELECT statement. That is, the SQL statement SELECT * FROM CUSTOMER_MASTER WHERE CUSTOMER_SURNAME = 'Smith' queries the CUSTOMER_MASTER table and returns all customers with the last name Smith.

Edgar F. Codd (1970) invented the relational database in 1970. The relational database is based on relational set theory which is the structure of the database. A database is a collection of one or more relationships or columns, including columns and rows. Due to the ordering relationship of the tables, normalization is an important part of the database relational model. Normalization is an integral part of the relationship model, increasing complexity and processing. The advantage of a relational database is that the system is simple, flexible, and efficient. Because the table is simple, the data is easy to understand and it's easy to communicate with other people. Relational databases are flexible because users do not have to use predefined keys to enter information. In addition, relational databases are more efficient because SQL is an easy-to-read language. SQL instructions are simple instruction formats that can be placed in a database for implementation.