Entity-relationship approach to logical database design.
Proc. of the third international conference on Entity-relationship approach to software engineering
The design of an expert system for database design
Proc. of the ICOD-2 workshop on New applications of data bases
An introduction to database systems: vol. I (4th ed.)
An introduction to database systems: vol. I (4th ed.)
The duality of database structures and design techniques
Communications of the ACM
New methods and fast algorithms for database normalization
ACM Transactions on Database Systems (TODS)
Synthesizing third normal form relations from functional dependencies
ACM Transactions on Database Systems (TODS)
Principles of Database Systems
Principles of Database Systems
Design of Database Structures
An Expert Database Design System Based on Analysis of Forms
IEEE Transactions on Software Engineering
Database Management, Knowledge Base Management, and Expert System Development in PROLOG
Databases for Business and Office Applications, Database Week
Theory of Relational Databases
Theory of Relational Databases
A web-based tool for teaching data modeling
Journal of Computing Sciences in Colleges
| Hi-index | 0.00 |
This paper presents an assistant database design system, ExpertDB, which is based on entity-relationship (ER) approach. The approach is to synthesize a normalized ER schema (which consists of entity set and relationship set expressions) from functional dependencies (FD). Using as input the set of attributes and FD's, we derive the minimal cover of FD's, partition and regroup FD's, and finally form the entities and relationship sets. In every aspect of these derivations, ExpertDB provides assistance to the user, which is usually the database administrator (DBA), in the database design. The resulting ER schema is then mapped to relational schema.