Abstract
Although systems analysis has provided a number of valid practical techniques for the determination of user functional requirements, it has failed, so far, to develop a complete and coherent methodology to integrate these techniques into an overall and objective cycle. Data analysis, on the other hand, has established a number of fundamental rules whereby attributes can be defined and interrelated to form viable entities [Housel et al, 1979; Yao et al, 1982]. Attribute and entity relationships can then be investigated further [Chen, 1976] to identify the inherent data structure (or model) of the enterprise.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Aho, A. V., Beeri, C. & Ullman, J. D., ‘The Theory of Joins in Relational Database’, ACM TODS, Vol. 4, No. 3, pp. 297–314, 1979.
Albano, A., de Antonellis, V. & di Leva, A., ‘Computer Aided Database Design: The DATAID Approach’, In: Computer-Aided Database Design — The DATAID Project, Albano A., de Antonellis V. & di Leva A. (eds), North Holland, pp. 1–13, 1985.
Atzeni, P., Batini, P., Carboni, E., de Antonellis, V., Lenzerini, M., Villanelli, F. & Zonta, B., ‘INCOD-DTE: A System for Interactive Conceptual Design of Data, Transactions and Events’, In: Methodology and Tools for Database Design, Ceri S. (ed), North Holland, pp. 205–288, 1983.
Beeri, C., Fagin, R. & Howard, J. H., ‘A Complete Axionatization for Functional and Multivalued Dependencies’, ACM SIGMOD International Symposium on Management of Data, pp. 47–61, 1977.
Borgida, A. T., Mylopoulos, J. & Wong, H. K. T., ‘Methodological and Computer Aids for Interactive Information System Development’, In: Automated Tools for Information Systems Design, Schneider H. J. & Wasserman A. I. (eds), North Holland, pp. 109–124, 1982.
Carlson, C. S. & Kap[lan R. S., ‘A Generalized Access Path Model and Its Application to a Relational Database Systems‘, Proc. ACM SIGMOD International Symposium on Management of Data, pp. 143–156, 1976.
Chen, P. P., ‘The Entity-Relationship Model: Toward a Unified View of Data’, ACM TODS, Vol. 1, No. 1, pp. 9–36, 1976.
Codd, E. F., ‘A Relational Model of Data for Large Shared Databases’, CACM, Vol. 13, No. 6. pp. 377–387, 1970.
Codd, E. F., ‘Further Normalisation of the Database Relational Model’, In: Database Systems, R. Rustin (editor), Prentice-Hall, Englewood Cliffs, New Jersey, pp. 33–64, 1972.
Delobel, C., ‘Normalisation and Hierarchical Dependencies in the Relational Data Model’, ACM TODS, Vol. 3, No. 3, pp. 201–222, 1978.
Fagin, R., ‘Multivalued Dependencies and a New Normal Form for Relational Databases’, ACM TODS, Vol. 2, No. 3, pp. 262–278, 1977.
Howe, D. R., ‘Data Analysis for Database Design’, Edward Arnold, 1985.
Kent, W., ‘A Simple Guide to Five Normal Forms in Relational Database Theory’. CACM, Vol. 26, No. 2, pp. 120–125, 1983.
Kouvatsos, D. D. & Yannakoudakis, E. J., ‘A New Approach to the Design of Structured Bibliographic Records’, Information Technology: Research and Development, Vol. 1, No. 4, pp. 285–300, 1982.
Olle, T. W., Sol, H. G. & Verrijn-Stuart, A. A., ‘Information Systems Design Methodologies’, IFIP WG 8. 1 Working Conference, The Netherlands, North-Holland, May 1982.
Teorey, T. J. & Fry, J. P., ‘Design of Database Structures’, Prentice-Hall, 1982.
Yao, S. B., Waddel, V. E. & Housel, B. C., ‘View Modeling and Integration Using the Functional Dependency Model’, IEEE Transactions on Software Engineering, SE-8, 6, pp. 544–553, November 1982.
Zaniolo, C. & Melkanoff, M. A., ‘On the Design of Relational Database Schemata’, ACM TODS, Vol. 6, No. 1,pp. 1–47, 1981.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 1988 Springer-Verlag Berlin Heidelberg
About this chapter
Cite this chapter
Yannakoudakis, E.J. (1988). Database Design Methodology. In: The Architectural Logic of Database Systems. Springer, London. https://doi.org/10.1007/978-1-4471-1616-5_6
Download citation
DOI: https://doi.org/10.1007/978-1-4471-1616-5_6
Publisher Name: Springer, London
Print ISBN: 978-3-540-19513-9
Online ISBN: 978-1-4471-1616-5
eBook Packages: Springer Book Archive