Jump to content

User:Matthew 1130/ER Draft

From Wikipedia, the free encyclopedia

Interesting prior versions of this article:

Note that Tony Drewry is a self-promoted author, who listed his own article in the External Links section on 7 Dec 2006. His article needs to be verified for quality.

Ideas:

  • A "weak entity" is also referred to as a "dependent child".

Introduction

[edit]

Databases are used to store structured data. The structure of this data, together with other constraints, can be designed using a variety of techniques, one of which is called entity-relationship modelling or ERM.

The objective of the ERM process is to produce an entity-relationship diagram (ERD) which identifies data objects, relationships between those objects, and describes cardinality rules for a given problem domain, which are verifiable by selected domain experts. Data modeling requires a graphical notation for representing such data models. An ERD is a type of conceptual data model or semantic data model. This provides:

  • A basis for further requirements analysis and definition of use cases relating to the defined entities, in conjunction with domain experts.
  • Cardinality rules for initial drafts of the logical and physical database designs.
  • Documentation for software developers to understand a broad overview of the relationships between various types of data in a system.


The first stage of information system design uses these models to describe information needs or the type of information that is to be stored in a database during the requirements analysis. The data modeling technique can be used to describe any ontology (i.e. an overview and classifications of used terms and their relationships) for a certain universe of discourse (i.e. area of interest). In the case of the design of an information system that is based on a database, the conceptual data model is, at a later stage (usually called logical design), mapped to a logical data model, such as the relational model; this in turn is mapped to a physical model during physical design. Note that sometimes, both of these phases are referred to as "physical design".

There are a number of conventions for entity-relationship diagrams (ERDs). The classical notation is described in the remainder of this article, and mainly relates to conceptual modelling. There are a range of notations more typically employed in logical and physical database design, including information engineering, IDEF1x (ICAM DEFinition Language) and dimensional modelling.

Examples

[edit]