Advertisement

Particular Kinds of Relationship Type

Abstract

As we saw in Chap. 2, “entity types are concepts whose instances are identifiable objects ...” An entity is identifiable if there is a linguistic expression that denotes it. Most of these expressions are built from reference relationship types, a particular kind of relationship type described in Sect. 5.1. In Sect. 5.2, we discuss how to use reference relationship types to identify entities. Section 5.3 explains that in general the participants of a relationship type should be entity types rather than its identifiers.

Keywords

Functional Dependency Compound Reference Entity Type Relationship Type Compact Disc 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

5.6 Bibliographical Notes

  1. Kent W (1978) Data and reality. North-Holland. Chap. 3Google Scholar
  2. Sundgren B (1975) Theory of data bases. Petrocelli.Google Scholar
  3. Chen PPS (1976) The Entity-Relationship model: Towards a unified view of data. ACM Trans. Database Syst. 1(1):9–36.CrossRefGoogle Scholar
  4. Balaban M, Shoval P (1999) Resolving the “weak status” of weak entity types in Entity-Relationships schemas. ER 1999, LNCS 1728:369–383.Google Scholar
  5. Nijssen GM, Halpin TA (1989) Conceptual schema and relational database design. Prentice Hall. Chap. 7Google Scholar
  6. De Troyer O, Meersman R, Verlinden P (1988) RIDL* on the CRIS case. In Olle et al (eds) pp 375–459.Google Scholar
  7. Halpin T (2001) Information modeling and relational databases: From conceptual analysis to logical design. Morgan Kaufmann.Google Scholar
  8. Hofstede AHM ter, Weide, TP van der (1993) Expressiveness in conceptual data modelling. Data Knowl. Eng. 10:65–100.zbMATHCrossRefGoogle Scholar
  9. Thalheim B (2000) Entity-relationship modeling. Springer. Chap. 8Google Scholar
  10. Gogolla M (2000) Identifying objects by declarative queries. In Papazoglou MP, Spaccapietra S, Tari Z (eds) Advances in object-oriented data modeling. MIT Press, pp 255–277.Google Scholar
  11. Batini C, Ceri S, Navathe SB (1992) Conceptual database design: An entity-relationship approach. Benjamin/Cummings.Google Scholar
  12. Hainaut J-L (1996) Specification preservation in schema transformations-Application to semantics and statistics. Data Knowl. Eng. 19(2):99–134.zbMATHCrossRefGoogle Scholar
  13. Halpin T (2001) Information modeling and relational databases: From conceptual analysis to logical design. Morgan Kaufmann.Google Scholar
  14. Langefors B (1974) Information systems. IFIP Congress 1974. North-Holland, pp 937–945.Google Scholar
  15. Chen PPS (1976) The Entity-Relationship model: Towards a unified view of data. ACM Trans. Database Syst. 1(1):9–36.CrossRefGoogle Scholar
  16. Nijssen GM, Halpin TA (1989) Conceptual schema and relational database design. Prentice Hall.Google Scholar
  17. Ullman JD (1988) Principles of database and knowledge-base systems, Vol.1. Computer Science Press.Google Scholar
  18. Elmasri R, Navathe SB (2003) Fundamentals of database systems. Addison-Wesley.Google Scholar
  19. Fagin R (1977) Multivalued dependencies and a new normal form for relational databases. ACM Trans. Database Syst. 2(3):262–278.CrossRefGoogle Scholar
  20. Ling T (1985) A normal form for entity-relationship diagrams. ER 1985:24–35.Google Scholar
  21. Jones T, Song I-Y (1996) Analysis of binary/ternary cardinality combinations in entity-relationship modeling. Data Knowl. Eng. 19(1):39–64.zbMATHCrossRefGoogle Scholar
  22. Thalheim B (2000) Entity-relationship modeling. Springer.Google Scholar
  23. McAllister AJ, Sharpe D (1998) An approach for decomposing n-ary data relationships. Softw., Pract. Exper. 28(2):125–154.CrossRefGoogle Scholar
  24. Halpin TA, Proper HA (1995b) Database schema transformation and optimization. OOER 1995, LNCS 1021:191–203.Google Scholar
  25. Assenova P, Johannesson P (1996) Improving quality in conceptual modelling by the use of schema transformations. ER 1997, LNCS 1157:277–291.Google Scholar
  26. Halpin T (2001) Information modeling and relational databases: From conceptual analysis to logical design. Morgan Kaufmann. Chap. 12.2Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2007

Personalised recommendations