Title :
Transform a NIAM conceptual schema into a EKNE relational database scheme
Author :
Zhang, Yanchun ; Orlowska, Maria E.
Author_Institution :
Dept. of Comput. Sci., Queensland Univ., St. Lucia, Qld., Australia
Abstract :
A system for enhancements of semantic methodologies for relational database design is described. In order to design a well-formed NIAM conceptual schema, dependency theory can be used as a heuristic tool to help the designer detect the derived fact types (FTs) in the NIAM conceptual schema. In order to design a minimal relational database schema, one can use dependency theory as a heuristic tool to find the candidate FTs for substitution, interact with the users to redesign the conceptual schema, and then transform it into an EKNF (elementary key normal form) relational database schema with the minimal number of relations. The proposed system is implemented using Turbo Pascal 5.5 on IBM PS2
Keywords :
heuristic programming; relational databases; EKNE relational database scheme; IBM PS2; NIAM conceptual schema; Turbo Pascal 5.5; dependency theory; derived fact types; elementary key normal form; heuristic tool; semantic methodologies; Algorithm design and analysis; Application software; Computer science; Data models; Inference algorithms; Information analysis; Information systems; Relational databases;
Conference_Titel :
Databases, Parallel Architectures and Their Applications,. PARBASE-90, International Conference on
Conference_Location :
Miami Beach, FL
Print_ISBN :
0-8186-2035-8
DOI :
10.1109/PARBSE.1990.77228
