Entity Relationship Model Quiz & Flashcards

Study Notes

Entity Relationship Modeling

ERD represents the conceptual database as viewed by the end user.
ERDs depict the database's main components: entities, attributes, and relationships.

Types of ERD Notations

Chen notation
Crow's Foot notation
UML notation

Entities

An entity is an "object" of interest to the end user.
An entity refers to the entity set, not to a single entity occurrence.
An entity in the ERM corresponds to a table, not to a row, in the relational environment.
The ERM refers to a table row as an entity instance or entity occurrence.
An entity is represented by a rectangle that contains the entity's name, usually written in all capital letters.

Attributes

Attributes are characteristics of entities.
In Crow's Foot notation, attributes are written in the attribute box below the entity rectangle.

Required and Optional Attributes

A required attribute is an attribute that must have a value; it cannot be left empty.
An optional attribute is an attribute that does not require a value; therefore, it can be left empty.
In Crow's Foot, a required attribute is indicated with a vertical line.

Domains

A domain is the set of possible values for a given attribute.
The domain for a grade point average (GPA) attribute is written (0,4).
The domain for a company's date of hire attribute consists of all dates that fit in a range (for example, company startup date to current date).

Identifiers (Primary Keys)

Identifiers are one or more attributes that uniquely identify each entity instance.
The entity identifier is mapped as the table's primary key (PK).
Identifiers are underlined in the ERD.

Composite Identifiers

Ideally, an entity identifier is composed of only a single attribute.
A composite identifier is a primary key composed of more than one attribute.

Composite and Simple Attributes

A composite attribute is an attribute that can be further subdivided to yield additional attributes.
Examples: ADDRESS can be subdivided into street, city, state, and zip code.
A simple attribute is an attribute that cannot be subdivided.
Examples: age, gender, and marital status.

Single-Valued and Multivalued Attributes

A single-valued attribute is an attribute that can have only a single value.
Examples: a person's gender, a student's GPA, an employee's SSN.
Multivalued attributes are attributes that can have many values.
Examples: a person may have several college degrees, a household may have several different phones, each with its own number.

Description

Test your understanding of the Entity Relationship Model (ERM) and its components, including entities, attributes, and relationships. Learn about different types of ERD notations, such as Chen, Crow's Foot, and UML, and how they represent the conceptual database. This quiz is based on Chapter 4 of Alan Amin's Introduction to Database Systems.