论文信息 - Design of relational database schemas

Design of relational database schemas

Abstract The development of an optimal database schema for an enterprise and the subsequent selection of a suitable set of database relations, represent a major problem during the logical design of a relational database which has not been adequately tackled so far. The potential and limitations of the major approaches to the conceptual database schema and the relational schema design problems are evaluated briefly and a number of concepts are introduced in order to assist the database designer develop an appropriate database schema and overcome some of the problems currently encountered.

George Pangalos | G. Pangalos

[1] Raymon D. Garrett,et al. Hospitals--a systems approach , 1973 .

[2] E. F. Codd,et al. A relational model of data for large shared data banks , 1970, CACM.

[3] Gio Wiederhold,et al. Database Design , 1977 .

[4] Henk Sol,et al. Information Systems Design Methodologies: A Comparative Review , 1983 .

[5] Henk Sol,et al. Information Systems Design Methodologies: A Feature Analysis , 1983 .

[6] G. Pangalos,et al. Design and implementation of an integrated hospital database. , 1986, Medical informatics = Medecine et informatique.

[7] Catriel Beeri,et al. A Sophisticate's Introduction to Database Normalization Theory , 1978, VLDB.

[8] Ronald Fagin,et al. Multivalued dependencies and a new normal form for relational databases , 1977, TODS.

[9] Douglas T. Ross,et al. Structured Analysis for Requirements Definition , 1977, IEEE Transactions on Software Engineering.

[10] Carlo Zaniolo,et al. Analysis and design of relational schemata for database systems. , 1976 .

[11] Philip A. Bernstein,et al. Synthesizing third normal form relations from functional dependencies , 1976, TODS.

[12] C. West Churchman,et al. The Systems Approach , 1979 .

[13] I G MacDonald. Information engineering—an improved, automatable methodology for the design of data sharing systems , 1986 .