Filters
Question type

Study Flashcards

A(n)attribute need not be physically stored within the database.

Correct Answer

verifed

verified

The Chen notation identifies a weak entity by using a double-walled entity .

Correct Answer

verifed

verified

The Crow's Foot notation is less implementation­oriented than the Chen notation.

A) True
B) False

Correct Answer

verifed

verified

Identifying the attributes of entities helps in the better understanding of among entities.

Correct Answer

verifed

verified

The entity relationship model uses the associative entity to represent a(n) relationship between two or more entities.


A) M:N
B) 1:M
C) N:1
D) M:1

E) A) and D)
F) A) and C)

Correct Answer

verifed

verified

Failure to understand the distinction between mandatory and optional in relationships might yield designs in which awkward (and unnecessary)temporary rows (entity instances)must be created just to accommodate the creation of required entities.

Correct Answer

verifed

verified

In the entity relationship model,a table row corresponds to an entity instance.

A) True
B) False

Correct Answer

verifed

verified

True

Explain multivalued attributes with the help of examples.How are multivalued attributes indicated in the Chen Entity Relationship model?

Correct Answer

verifed

verified

Multivalued attributes are attributes th...

View Answer

In Crow's Foot notation,an optional relationship between entities is shown by drawing a(n)on the side of the optional entity.

Correct Answer

verifed

verified

The entity relationship diagram (ERD) represents the database as viewed by the end user.


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

E) B) and D)
F) B) and C)

Correct Answer

verifed

verified

D

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

A) True
B) False

Correct Answer

verifed

verified

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

E) All of the above
F) B) and D)

Correct Answer

verifed

verified

The Crow's Foot notation depicts the strong relationship with a(n)line between the entities.

Correct Answer

verifed

verified

Explain recursive relationships with the help of an example.

Correct Answer

verifed

verified

A recursive relationship is one in which...

View Answer

Unary relationships are common in manufacturing industries.

A) True
B) False

Correct Answer

verifed

verified

True

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

A) True
B) False

Correct Answer

verifed

verified

are characteristics of entities.

Correct Answer

verifed

verified

To implement a small database,a database designer must know the "1" and the "M" sides of each relationship and whether the relationships are mandatory or optional.

A) True
B) False

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

Showing 1 - 20 of 75

Related Exams

Show Answer