Abstract
Multivalued dependencies are considered to be difficult to teach, to handle and to model. This observation is true if multivalued dependencies are treated in the classical approach. We introduce another treatment of multivalued dependencies based on ER modeling techniques and show that multivalued dependenices can be handled in a more natural and intuitive way within our framework. Based on the concept of competing multivalued dependencies we can prove in which case a unique ER schema representation exists. If multivalued dependencies are competing then either one of the competing schemata is chosen or an approximation which combines the competing schemata can be used.
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
Biskup, J.: Foundations of Information Systems. Vieweg, Braunschweig (1995) (in German)
Chung, I., Nakamura, F., Chen, P.P.: A Decomposition of Relations Using the Entity-Relationship Approach. In: Proc. ER 1981, pp. 149–171 (1981)
Levene, M., Loizou, G.: A Guided Tour of Relational Databases and Beyond. Springer, Berlin (1999)
Ling, T.W.: An Analysis of Multivalued and Join Dependencies Based on the Entity-Relationship Approach. Data and Knowledge Engineering 1, 3 (1985)
Ling, T.W.: A Normal Form for Entity-Relationship Diagram. In: Proc. 4th, Conference. Silver Spring, pp. 24–35. IEEE Computer Science Press, Los Alamitos (1985)
Moody, D.L.: Dealing with Complexity: A Practical Method for Representing Large Entity-Relationship Models. PhD., Dept. of Information Systems, University of Melbourne (2001)
Paredaens, J., De Bra, P., Gyssens, M., Van Gucht, D.: The Structure of the Relational Database Model. Springer, Berlin (1989)
Sciore, E.: Real-world MVD’s. In: Proc. Int. Conf. on Data Management, pp. 121–132 (1981)
Simsion, G.C.: Data Modeling Essential – Analysis, Design, and Innovation. Van Nostrand Reinhold, New York (1994)
Thalheim, B.: Dependencies in Relational Databases. Teubner, Leipzig (1991)
Thalheim, B.: Entity-Relationship Modeling – Fundamentals of Database Technology. Springer, Berlin (2000), http://www.informatik.tu-cottbus.de/thalheim/HERM.htm
Thalheim, B.: Component Construction of Database Schemes. In: Spaccapietra, S., March, S.T., Kambayashi, Y. (eds.) ER 2002. LNCS, vol. 2503, pp. 20–34. Springer, Heidelberg (2002)
Thalheim, B.: Scrutinizing Multivalued Dependencies through the Higher- Order Entity-Relationship Model. Preprint BTU Cottbus, Informatik (June 2003)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2003 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Thalheim, B. (2003). Conceptual Treatment of Multivalued Dependencies. In: Song, IY., Liddle, S.W., Ling, TW., Scheuermann, P. (eds) Conceptual Modeling - ER 2003. ER 2003. Lecture Notes in Computer Science, vol 2813. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-39648-2_29
Download citation
DOI: https://doi.org/10.1007/978-3-540-39648-2_29
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-20299-8
Online ISBN: 978-3-540-39648-2
eBook Packages: Springer Book Archive