Deck 4: Entity Relationship (ER)Modeling

Question 1

The Crow's Foot model is less implementation-oriented than the Chen model.

Answer 1

False

Question 2

Software vendors have adopted the Chen representation because of its compact representation.

Answer 2

False

Question 3

In both the Chen and Crow's Foot models,an entity is represented with a rectangle containing the entity's name.

Answer 3

True

Question 4

Derived attributes are stored in a special database table.

Question 5

All simple attributes are also single-valued.

Question 6

Ideally,a primary key is composed of several attributes.

Question 7

All attributes are either simple or composite.

Question 8

The DBMS can easily handle multivalued attributes.

Question 9

In the original Chen model,each attribute is represented using an oval with the attribute name connected to the entity with a line.

Question 10

An ERM is dependent on the database type.

Question 11

The word "entity" in the ER model corresponds to a table.

Question 12

Attributes are types of entities.

Question 13

The ER model refers to a specific table row as an entity occurrence.

Question 14

In an ER diagram,primary keys are usually bolded.

Question 15

Attributes cannot share a domain.

Question 16

The ER diagram represents the conceptual database as viewed by the end user.

Question 17

Attributes do not have a domain.

Question 18

The ER model refers to a specific table row as an entity instance.

Question 19

In the Chen model,a multivalued attribute is connected to the owning entity with a double line.

Question 20

A composite identifier is a primary key composed of more than one attribute.

Question 21

In an ER diagram,primary keys are indicated by ____.

A) bolding
B) italics
C) underlining
D) a special font

Question 22

You should always load data from the 1 side of a 1:M relationship.

Question 23

Relationships operate only in one direction.

Question 24

Connectivities and cardinalities are established by business rules.

Question 25

A ____ attribute can be further subdivided to yield additional attributes.

A) composite
B) simple
C) single-valued
D) multivalued

Question 26

The set of possible values for an attribute is a ____.

A) domain
B) range
C) set
D) key

Question 27

A ____ identifier is composed of more than one attribute.

A) primary
B) foreign
C) composite
D) domain

Question 28

A weak entity has a primary key that is partially or totally derived from the parent entity in the relationship.

Question 29

A recursive relationship is one in which a relationship can exist between occurrences of the same entity set

Question 30

The existence of a mandatory relationship indicates that the minimum cardinality is 1 for the mandatory entity.

Question 31

Cardinality expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity.

Question 32

The ____ attribute(s)make up the primary key in the table definition:
CLASS (CRS_CODE,CLASS_SECTION,CLASS_TIME,CLASS_ROOM,PROF_NUM)

A) CRS_CODE
B) CLASS_SECTION
C) CRS_CODE and CLASS_SECTION
D) There is no primary key

Question 33

Ideally,an entity identifier is composed of ____ attribute(s).

A) zero
B) one
C) two
D) six

Question 34

In Chen notation,there is no way to represent cardinality.

Question 35

A ____ attribute is one that cannot be subdivided.

A) composite
B) simple
C) single-valued
D) multivalued

Question 36

The ERD represents the ____ database as viewed by the end user.

A) condensed
B) physical
C) logical
D) conceptual

Question 37

Some ____ database modeling concepts can be expressed only using the Chen notation.

A) developmental
B) conceptual
C) actual
D) specific

Question 38

Attributes may share a ____.

A) name
B) domain
C) location
D) table

Question 39

A relationship is identified by a name that describes the relationship.

Question 40

A weak relationship exists if the primary key of the related entity contains at least one primary key component of the parent entity.

Question 41

A relationship is an association between ____.

A) objects
B) entities
C) databases
D) fields

Question 42

The existence of a(n)____ relationship indicates that the minimum cardinality is at least 1 for the mandatory entity.

A) mandatory
B) optional
C) multivalued
D) single-valued

Question 43

An entity is said to be ____-dependent if it can exist in the database only when it is associated with another related entity occurrence.

A) existence
B) relationship
C) business
D) weak

Question 44

A derived attribute is indicated in the Chen model by a ____.

A) single line
B) dashed line
C) circle
D) double line

Question 45

Some attributes are classified as ____.

A) simple
B) complex
C) defined
D) grouped

Question 46

A derived attribute ____.

A) must be stored physically within the database
B) need not be physically stored within the database
C) has many values
D) must be based on the value of three or more attributes

Question 47

A ____ should be a derived attribute.

A) person's name
B) person's age
C) person's social security number
D) person's phone number

Question 48

A(n)____ might be represented with a single-valued attribute.

A) person's phone number(s)
B) car's color
C) employee's educational background
D) person's social security number

Question 49

A ____ attribute can have only one value.

A) composite
B) simple
C) single-valued
D) multivalued

Question 50

The ____ type of attribute cannot be created in a DBMS.

A) derived
B) multivalued
C) simple
D) composite

Question 51

When the PK of one entity does not contain the PK of a related entity,the relationship is ____.

A) missing
B) weak
C) strong
D) neutral

Question 52

In the ERD,cardinality is indicated using the ____ notation.

A) (max,min)
B) (min,max)
C) [min ...max]
D) {min|max}

Question 53

If an entity can exist apart from one or more related entities,it is said to be ____-independent.

A) existence
B) relationship
C) business
D) weak

Question 54

Making sure all ____ are identified is a very important part of a database designer's job.

A) business rules
B) cardinalities
C) derived attributes
D) relationships

Question 55

____ might be represented with a multivalued attribute.

A) A person's name
B) Household phone numbers
C) A bank account balance
D) A book title

Question 56

A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.

A) strong
B) weak
C) business
D) relationship

Question 57

Another word for existence-independent is ____.

A) weak
B) alone
C) unary
D) strong

Question 58

The term "____" is used to label any condition in which one or more optional relationships exist.

A) participation
B) optionality
C) cardinality
D) connectivity

Question 59

____ attributes can have many values.

A) Composite
B) Simple
C) Single-valued
D) Multivalued

Question 60

Knowing the ____ number of entity occurrences is very helpful at the application software level.

A) maximum
B) minimum
C) approximate
D) maximum and minimum

Question 61

The Crow's foot symbol with two parallel lines indicates ____ cardinality.

A) (0,N)
B) (1,N)
C) (1,1)
D) (0,1)

Question 62

Some ____________________ database modeling concepts can be expressed only using the Chen notation.

Question 63

____ relationships are most common.

A) Unary
B) Binary
C) Ternary
D) Higher-degree

Question 64

If an employee within an EMPLOYEE entity has a relationship with itself,that relationship is known as a ____ relationship.

A) self
B) self-referring
C) looping
D) recursive

Question 65

A person's social security number would be an example of a(n)____________________ attribute.

Question 66

The Crow's Foot model is more ____________________-oriented than the Chen model.

Question 67

____________________ are underlined in an ER diagram.

Question 68

____________________ are characteristics of entities.

Question 69

A ____ relationship exists when three entities are associated.

A) unary
B) binary
C) ternary
D) weak

Question 70

A ____ relationship exists when an association is maintained within a single entity.

A) unary
B) ternary
C) binary
D) weak

Question 71

A ____ relationship exists when two entities are associated.

A) unary
B) binary
C) ternary
D) weak

Question 72

The ____________________ refers to a specific table row as an entity instance.

Question 73

Complex ____ requirements may dictate data transformations,and they may expand the number of entities and attributes within the design.

A) information
B) entity
C) design
D) processing

Question 74

____________________ attributes can be subdivided.

Question 75

The ERM forms the basis of a(n)___________________________________.

Question 76

A(n)____________________ is the attribute's set of possible values.

Question 77

A(n)____________________ attribute cannot be subdivided.

Question 78

The step,____,occurs first in the process of building an ERD.

A) Develop the initial ERD.
B) Create a detailed narrative of the organization's description of operations.
C) Identify the attributes and primary keys that adequately describe the entities.
D) Identify the business rules based on the description of operations.

Question 79

A(n)____ entity is composed of the primary keys of each of the entities to be connected.

A) associative
B) recursive
C) unary
D) binary

Question 80

The associative entity is also known as a ____ entity.

A) unary
B) weak
C) strong
D) composite