Tutorial for Designer/2000
and Developer/2000

Lesson 5

In this lesson you will learn:

What is an E-R model?

An E-R model or and entity-relationship model is a logical representation of the data for a firm or business area. The E-R model consists of entities, relationships between or among entities, and the attributes of the entities. In order to create a detailed and fairly comprehensive E-R model, you will have to be clear about some of its relevant components, such as the entities, attributes, relationships, and the degree as well as the cardinality of a relationship. (You will see repeated references to these above mentioned terms in the course of this lesson).

Relevant terms in E-R modeling

An entity is a person, place, object or concept about which the organization wishes to maintain some data (e.g., STUDENT).

Attributes are certain properties of an entity that is of relevance to the firm (e.g. Student_ID).

Relationships are associations between the instances of one or more of the entities. e.g. Student TAKES Courses where Student and Courses are two entities and "TAKES" is the relationship between them.

Degree of a Relationship is the number of entity types that participate in a relationship. In the example given above, the degree is two (or binary), since there are two entity types that participate in the relationship. (Note that Designer/2000 allows you to create unary and binary relationships only).

Cardinality of a relationship (from entity A to entity B) is the number of instances of entity B that can be associated with each instance of entity A. (See Figure 5.1 for a graphical representation of the E-R model to be created).

Figure 5.1

Figure 5.1: A graphical representation of the E-R diagram to be created in this lesson

Creating the E-R Diagram using the E-R Diagrammer

  1. To go to the E-R Diagrammer:

    By this time, you should have a conceptual idea about the entities, the attributes and the relationships among the entities, that you would like to represent in the E-R diagram. For us in this project, our two main entities will be Student and Courses.

On to page two

Page 1, Page 2, Page 3, Page 4 / Back to the tutorial index.

Main Page About the Book Student Resources Oracle Resources Instructor Resources Contact Us

1999 Prentice-Hall, Inc., A division of Pearson Education, Upper Saddle River, New Jersey 07458 Legal Statement
Comments should be directed to webmaster@prenhall.com