Algorithmic Resolution of an ER Schema Into Relational DDL Statements Using Artificial Intelligence

The concept of this paper helps resolve an ER schema into an appropriate relational Data Description Language (herein standard SQL statements) while considering all the inherent complexity of such a schema. The algorithm resolves all the relationships between the concerned entities (even weak ones), their associated keys - primary and foreign, attributes - simple, composite and multivalued and relationships types from binary to n-ary. The algorithm (as implemented in ANSI C) is smart enough to consider the case of cascading weak entities.

Provided by: International Journal of Scientific & Engineering Research Topic: Data Management Date Added: Nov 2011 Format: PDF

Find By Topic