1. Science
  2. Publications
  3. Information Processing Systems
  4. 5(95)'2011
  5. Relational database logical schemа synthesis from the set of discovered functional dependencies

Relational database logical schemа synthesis from the set of discovered functional dependencies

V.A. Radchenko, Y.A. Malkov, A.S. Balyuk, U.S. Horpinenko
Annotations languages:

This article presents the way of relational database logical schema engineering on the basis of existing RDB. Information stored in initial DB is the input data for the method described. Applying the method of functional dependencies’ discovery from the set of data that DB contains, it becomes available to restore relations in data that are caused by universe of discourse. These relations appear as integrity constraints for the chain of algorithms that form the logical schema synthesis method. It produces final result as RDB logical schemaе in third normal form.
Keywords: logical schemaе, functional dependency, universe of discourse, integrity constraint, third normal form