Functional Dependence and Relational Databases

Information has always had an adequate dynamic interest. The development of programming languages, relational databases and information technology has fundamentally changed the content and structure of interest. A certain strict system of representations has developed. Formalization, exact mathematics and binary relations have become a successful and rapidly developing field of knowledge and experience.

The natural world of information has not changed its dynamics and, developing the content and structure, has risen to a new height. It has smooth forms, and in nature there is nothing “rectangular” . Information, of course, lends itself to formalization, but it has dynamics, not only the data and algorithms for their processing are changing, the tasks themselves and the areas of their application are changing.

Functional dependence




Information> Formalization >> Data

, ( , , …) , . , , , .

, – . ( ) – .





: « = ()» : « » , . , .

: . + + , + ...

Relational databases




,

: . .

, :

  • ;
  • .

( , , , …), .

( , ) , .





Database functional dependency




, . , , - .

, - , , .

, . , , . .

Functional Dependence Examples




, . , , :

  • Oracle;
  • MS SQL Server;
  • MySQL.

, , . .

The concept of functional dependence




- , , - - , .

, , , . . , , . , , , , .

. , , MySQL, , , , .

, PHP .

. , .

Database functional dependency properties




:

, - (, MySQL), , . MySQL «» . Oracle, , , , , .

, . - . «» () – . , «» .

. . :

  • « »;
  • « »;
  • « »;
  • « ».

- .

– , , , .

Functional Dependence Feature




:

, – , – , – .

, :

F(x1, x2, …, xN) = (y1, y2, …, yN).

, – , . , , , , () .

, , . . , , … , , , , , , SQL.

, SQL. : , , .

Using functional dependency




Excel

, . , :

  • PHP, Perl, JavaScript, C++, Delphi.
  • MySQL, Oracle, MS SQL Server, Visual FoxPro.

:

  • Word.
  • Excel.

( ) Word - .

Excel - . , Excel, , , .

, , . «», Excel Oracle , .

, Excel – , ( ) , Oracle – , – () .

, , , … .

,

- - , . , *.dbf, , , . , - , .

:

Author's example is not a picture




, , , « », « », « » « , ».

. , ! - , . .

, , , , , !

= = , . , + = . .

, , - , , , , .

, . . . , -. , - , + .

, : , "", - : - .

, . - , - , - . ...

. . . - , , .

About strings and objects




, , , . , ( ) , .




All Articles