Skip to main content

Designing the Conceptual Database Schema — A Framework for an Interactive Approach

  • Chapter
  • 69 Accesses

Part of the book series: Informatik-Fachberichte ((INFORMATIK,volume 50))

Abstract

A framework for interactive conceptual database design methods is proposed, which captures top-down and bottom-up approaches, as well. Several constraints are defined, which are to be fulfilled by the final conceptual schema. Some of them can be completely or partially tested by an automatic design tool. Further we show, how inconsistencies as homonyms, redundancies and synonyms can be automatically tested. Finally we sketch by examples, how bottom-up and top-down approaches can be used within our framework.

This is a preview of subscription content, log in via an institution.

Buying options

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   53.00
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Chen, P.: The entity-relationship model — A basis for the enterprice view of data Proc. AFIPS Conf., 1977

    Google Scholar 

  2. Sakai, H.: Entity-relationship approach to the conceptual schema design Proc. SIGMOD 1980

    Google Scholar 

  3. Lum, V.Y. et al.: 1978 New Orleans Data Base Design Workshop Report Proc. VLDB 1979

    Google Scholar 

  4. Codd, E.F.: A relational model of data for large shared data banks Comm. ACM, vol. 13, 1970, no. 6

    Google Scholar 

  5. Beeri, C., Bernstein, Ph.A. and Goodman, N.: A sophisticate’s introduction to database normalization theory Proc. VLDB 1979

    Google Scholar 

  6. Smith, J.M. and Smith, D.C.P.: Database abstractions: aggregation generalization ACM TODS, vol. 2, 1977, no. 2

    Google Scholar 

  7. Chen, P.P.: The entity-relationship model: toward a unified view of data ACM TODS, vol. 1, 1976, no. 1

    Google Scholar 

  8. Weldon, J.L.: Using data base abstraction for logical database design The Computer Journal, vol. 23, 1979, no. 1

    Google Scholar 

  9. Raver, N. and Hubbard, G.: Automated logical data base design: concepts and applications IBM Systems Journal, vol. 16, 1977, no. 3

    Google Scholar 

  10. Flory, A. and Kouloumdjian, J.: A model and a method for logical data base design Proc. VLDB 1978

    Google Scholar 

  11. Baldissera, C., Ceri, S., Pelagatti, G. and Bracchi, G.: Interactive Specification and formal verification of user’s views in data base design Proc. VLDB 1979

    Google Scholar 

  12. Tardieu, H., Pascot, D., Nanci, D. and Heckenroth, H.: A method, a formalism and tools for database design (Three years of experimental practice) Proc. Entity-Relationship 1979, ed. P.P.Chen, 1980

    Google Scholar 

  13. Günther, H., Krieger, R., Lausen, G.: A method for interactive conceptual database design ICS 81, Proc. of the 6. ACM European regional conference, 1981

    Google Scholar 

  14. Codd, E.F.: Extending the data base relational model to capture more meaning ACM TODS, vol. 4, 1979, no. 4

    Google Scholar 

  15. Smith, J.M. and Smith, D.C.P.: Database Abstractions: Aggregation Comm. ACM, vol. 20, 1977, no. 6

    Google Scholar 

  16. Mijares, I. and Peebles, R.: A methodology for the design of logical database structures Modelling in DBMS, ed. Nijssen, North Holl. 1977

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 1981 Springer-Verlag Berlin Heidelberg

About this chapter

Cite this chapter

Karszt, J., Krieger, R., Lausen, G., Stucky, W. (1981). Designing the Conceptual Database Schema — A Framework for an Interactive Approach. In: Brauer, W. (eds) GI — 11. Jahrestagung. Informatik-Fachberichte, vol 50. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-662-01089-1_21

Download citation

  • DOI: https://doi.org/10.1007/978-3-662-01089-1_21

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-10884-9

  • Online ISBN: 978-3-662-01089-1

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics